Hi, really i cant save *.xls to *.txt or *.csv because the file coming in real time, i need a library or programa what to transform in real time *.xls to tex file. Ruben
Your best bet is RODBC then. The file can stay open, but you can run queries even with the files open. Just need to learn a little SQL.. Shawn Way, PE Engineering Manager sway at tanox.com -----Original Message----- From: solares at unsl.edu.ar [mailto:solares at unsl.edu.ar] Sent: Tuesday, March 30, 2004 9:55 AM To: R-help at stat.math.ethz.ch Subject: [R] convert *.xls to text Hi, really i cant save *.xls to *.txt or *.csv because the file coming in real time, i need a library or programa what to transform in real time *.xls to tex file. Ruben ______________________________________________ R-help at stat.math.ethz.ch mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Has anyone looked into using the Jakarta POI to save R data directly to xls format? http://jakarta.apache.org/poi/index.html One of the advantages of POI over the DCOM interface is that one could use unix/linux platforms to generate excel files / reports. I would be interested in collaborating with anyone who has a serious interest in building an R package for this purpose. Thanks, Whit -----Original Message----- From: r-help-bounces at stat.math.ethz.ch [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of solares at unsl.edu.ar Sent: Tuesday, March 30, 2004 10:55 AM To: R-help at stat.math.ethz.ch Subject: [R] convert *.xls to text Hi, really i cant save *.xls to *.txt or *.csv because the file coming in real time, i need a library or programa what to transform in real time *.xls to tex file. Ruben ______________________________________________ R-help at stat.math.ethz.ch mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
<solares <at> unsl.edu.ar> writes:> Hi, really i cant save *.xls to *.txt or *.csv because the file coming in > real time, i need a library or programa what to transform in real time > *.xls to tex file. Ruben1. There was a post last month on r-help regarding this batch converter: http://www.analytics.washington.edu/statcomp/downloads/xls2csv 2. Googling for xls to csv will likely locate other alternatives too. 3. You can read the .xls directly into R as shown in the R Data Import/Export manual and then write it out as a text file.