Displaying 20 results from an estimated 3000 matches similar to: "Problem reading dates from Excel"
2005 Oct 20
1
Problem with Excel Files and Acls
Hi,
I've allready seen a lot of posts about problems with Excel 2000, but I
couldn't find one exactly matching my case.
I'm using a self (and maybe badly) compiled samba 3.0.20 on debian, using
ACLs. We're using ADS and winbind (some older NT4 domains remain)
The users can't open some excel files, spitting a message such as 'the file is
readonly or you're trying
2013 Nov 26
4
how to deal with xml files within Puppet ?
hi there,
I have to create a new server.xml which should be build from at least 3 or
4 another xml files. How could to copy and paste with puppet methods ?
On a command line under Unix I would do cat 1.xml > my_file.xml ; cat 2.xml
>> my_file.xml; cat 3.xml >> my_file.xml.
I have to say, I''m pretty new to puppet and simply have no clue how to
tackle this task ;=(
2004 Jul 13
1
Synatx Error on start with R --no-save < myfile.R
Dear all!
I wrote my R-code with an editor and loaded it with source("my_file.R").
Everything works fine as expected.
When I try to start my code with:
R --no-save < my_file.R
I do get a synatx error half way through. The version is 1.9.0 on a Linux
system. To start it with R --no-save < my_file.R works on some machines but
on some it doesn't.
Are there any rules
2015 Aug 25
5
sed question
I am trying to use sed to change a value in a pipe.
------------------- This is the two line script
CHANGE="1234"
cat my_file.txt | sed 's/CANCELID/$CHANGE/' > cancel.txt
-------------------
and the my_file.txt has:
<v1:notificationId>CANCELID</v1:notificationId>
it gets changed to $CHANGE instead of the actual value 1234 .
I tried putting a \ in front
2011 May 24
2
escape characters in shell commands
On a Windows platform I am trying to count the number of lines in a file.
In a DOS window, the following works:
C:\Users\jar>findstr /R /N "^" D:\my_dir\my_file | find /C ":"
5317
(it works with double \\ also)
But in R, I need to make this string up with the file name I get from
file.choose():
filename = file.choose()
#get the number of lines in the file
# first make a
2013 Feb 04
1
Problem loading hdf5 file
*Hi everyone, I am a new subscriber, so I hope I'm posting in the right way.
I need to load a hdf5 file, so I installed the hdf5 libraries ad the hdf5 R
package; in downloaded a small sample file from the hdf5 website and I
could correctly load it. But when I try to load my file:
*
require(hdf5)
rm(list=ls())
ls()
hdf5load("my_file.h5", verbosity=3)
*I get this error message:
*
2012 Nov 06
1
how Can make function for selecting the products
HI.
I make this code:
getdata<-function('a','b','c' ,'d','e','f'){
drv <- dbDriver("SQLite")
con<-dbConnect(drv, "sqlite.db")
lt<-dbListTables(con)
myf<-data.frame(NULL)
for (i in 1:length(lt))
{
myfile<-dbReadTable(con,lt[i])
myfile1<-myfile[-c(14:44)]
myfile1$MODEL<-gsub(" ",
2011 Jun 25
3
How to export to pdf in landscape orientation?
Does anybody know how to get a pdf file with landscape orientation?.
pdf(file= 'my_file.pdf' ,onefile=T,paper='A4')
plot(sin, -pi, 2*pi)
dev.off()
Thank's in advance
Juan A. Hernandez
Spain
[[alternative HTML version deleted]]
2004 Sep 10
2
Proposed change to code that handles output_prefix
On line 734 in src/flac/main.c, ver 1.77, change:
strcat(outfilename, infilename);
to
strcat(outfilename, flac__file_get_basename(infilename));
I did this change because I was calling flac with an input filename with a
path on the front of it, and I wanted the output file to go to a different
location, such as this:
flac --best --output-prefix /usr/share/flac /home/akehurst/tmp/my_file.wav
2017 Jul 15
2
readLines without skipNul=TRUE causes crash
hello, the last line of the code below causes a segfault for me on 3.4.1.
i think i should submit to https://bugs.r-project.org/ unless others have
advice? thanks
install.packages( "devtools" )
devtools::install_github("ajdamico/lodown")
devtools::install_github("jimhester/archive")
file_folder <- file.path( tempdir() , "file_folder" )
tf <-
2012 Oct 22
2
[LLVMdev] Reading IR from a std::ostream
Previously I had asked how to write then read back IR to/from a file. The write code looked like:
LLVMContext ctx;
SMDiagnostic diag;
Module *m = ParseIRFile( "my_file", diag, ctx );
However, the code I'm trying to retrofit LLVM IR into passes me just a std::ostream&. How can I read IR from a std::ostream?
I figured out how to use raw_os_ostream to adapt a
2008 Jul 20
2
problem with read.table
Hi,
Although I set check.names to FALSE in read.table, the duplicate names get modified. What should be done in this case?
the text file to be read by read.table
AM2 AM2 AM2 FAL
2 3 4 5
1 -1 -3 -2
t = read.table ("my_file", check.names = FALSE, header = T)
> t
AM2 AM2.1 AM2.2 FAL
2017 Jul 15
0
readLines without skipNul=TRUE causes crash
On 15/07/2017 7:35 AM, Anthony Damico wrote:
> hello, the last line of the code below causes a segfault for me on 3.4.1.
> i think i should submit to https://bugs.r-project.org/ unless others have
> advice? thanks
Segfaults are usually worth reporting as bugs. Try to come up with a
self-contained example, not using the lodown and archive packages. I
imagine you can do this by
2013 Feb 07
4
Sourcing my file does not print command outputs
I looked at the documentation of source() and summary(), and I could not
find the reason why calling something like:
> summary(resamps)
from the command line, works (it prints the summary)
whereas calling
summary(resampls)
from a file that I source with source("my_file.r") does not print anything.
How can I get summary(resamps) to print when I source a file with this
command?
2010 Feb 23
1
Importing Headers from excel files
Hello I am trying to import an Excel file but I am loosing the headers, My
headers are in the first to rows of the EXCEL file. In the following R
output, the NA are supposed to be the second item in the Header. Is there
any way to Import more than one row as headers?. Thank you
Felipe Parra
> Data<-odbcConnectExcel('Curva LIBOR.xlsx',readOnly=T,)
>
2006 Jul 12
1
RODBC, missing values, and Excel
Hi, all,
I'm trying to use RODBC to read data from Excel. However, I'm having
trouble converting missing values to NA and rather perplexed by the
output. Below illustrates my problem:
## DATA - copy to Excel and save as "tmp.xls"
## tmp.xls!Sheet1
x
0.11
0.11
na
na
na
0.11
## tmp.xls!Sheet2
x
0.11
0.11
na
na
na
na
0.11
## R Code
read.xls <- function(file, sheet =
2024 Jan 29
1
[External] readChar() could read the whole file by default?
My opinion is that the proposed feature would be greatly appreciated by users.
I had always wondered if I was the only one doing paste(readLines(f),
collapse="\n") all the time.
It would be great to have the proposed, more straightforward way to
read the whole file as a string: readChar("my_file.txt", -1) or even
better readChar("my_file.txt")
Thanks for your detailed
2012 Mar 23
1
[libvirt] Problem with Open vSwitch and dnsmasq
Date: Thu, 22 Mar 2012 11:43:03 -0700
Subject: Re: [libvirt] Problem with Open vSwitch and dnsmasq
From: aatteka at nicira.com
To: dano1988 at hotmail.it
CC: libvir-list at redhat.com; roberto.sassu at polito.it; paolo.smiraglia at polito.it; dev at openvswitch.org
On Thu, Mar 22, 2012 at 11:11 AM, Daniele Milani <dano1988 at hotmail.it> wrote:
I think I could try the first solution.
2014 Aug 15
2
leer ficheros excel en R en Ubuntu
Gracias Jorge por contestar tan rápido.
Con gdata hago eso del path, y directamente con el fichero, lo vi en una
web, y he intentado todas las opcioens que he visto.
En vez de install.packages('rJava', type = 'source')
he hecho install.packages('rJava')
Ahora probaré, y lo mismo con scan y readLines.
He visto en stackoverflow que mi problema puede ser actualizar java,
2014 Aug 14
3
leer ficheros excel en R en Ubuntu
Hola,
Pensé que esto iba a ser trivial en R, pero me estoy encontrado muchos con
mi problema en internet, y que las soluciones ofrecidas no terminan de
funcionar.
Estoy intentando leer un fichero .xls en ubuntu con los siguientes paquetes
y nada:
require(RODBC)
conn = odbcConnectExcel("madrid.xls") # open a connection to the Excel file
sqlTables(conn)$TABLE_NAME # show all sheets
df =