search for: xls2csv

I've created a Perl script that translates Microsoft Excel (.xls) files into comma-delimited text files (.csv) using the Perl Spreadsheet::ParseExcel module. Usage ----- perl xls2csv.pl <excel file> [<output file>] [<worksheet number>] Translate the Microsoft Excel spreadsheet file contained in <excel file> into comma separated value format (CSV) and store in <output file>. If <output file> is not specified, the output file will have the sa...

...c("na"," ","."),verbose=TRUE) Converting xls file "I:/subProjects/bh/HPGD//Platten_Liste_090421.xls" to csv file "C:\DOKUME~1\beckmann\LOKALE~1\Temp\RtmpCU2zBu\file4db74d06.csv" ... Executing perl C:/Programme/R/R-2.8.1/library/gdata/perl/xls2csv.pl "I:/subProjects/bh/HPGD//Platten_Liste_090421.xls" "C:\DOKUME~1\beckmann\LOKALE~1\Temp\RtmpCU2zBu\file4db74d06.csv" Platten gesamt ... Sheetnumber must be an integer larger than 0. at C:/Programme/R/R-2.8.1/library/gdata/perl/xls2csv.pl line 57. Done. Fehler in xls2csv(xls,...

....., method = method, : Intermediate file '/var/folders/cb/vvshkpm90lx_y2n69qlyw4z40000gn/T//RtmpK50r4g/file546a2722.csv' missing! In addition: Warning message: running command '"/usr/bin/perl" "/Library/Frameworks/R.framework/Versions/2.13/Resources/library/gdata/perl/xls2csv.pl" "/Users/peter/dev/R/telenor pricelists/ild_price_processor/ILD priser 2011.10.01.xls" "/var/folders/cb/vvshkpm90lx_y2n69qlyw4z40000gn/T//RtmpK50r4g/file546a2722.csv" "1"' had status 255 Error in file.exists(tfn) : invalid 'file' argument Error par...

...exe Using perl at C:\Perl64\bin\perl.exe Converting xls file “C:/Dropbox/R/library/gdata/xls/ExampleExcelFile.xlsx” to csv file “C:\Users\Robin\AppData\Local\Temp\RtmpWkmGgn\file1bccd743d36.csv” ... Executing ' "C:\Perl64\bin\perl.exe" "C:/Dropbox/R/library/gdata/perl/ xls2csv.pl" "C:/Dropbox/R/library/gdata/xls/ExampleExcelFile.xlsx" "C:\Users\Robin\AppData\Local\Temp\RtmpWkmGgn\file1bccd743d36.csv" "1" '... Loading 'C:/Dropbox/R/library/gdata/xls/ExampleExcelFile.xlsx'... Done. Orignal Filename: C:/Dropbox/R/library/gdat...

In R, How to read Excel file and access the data item? Thank you. --------------------------------- [[alternative HTML version deleted]]

A colleague has a dozen of excel sheets and also expects to get updates regularly. He could open these in M$-Excel and export as *.csv manually, "bring back to Unix" and then read into R. Of course there must be options to start programming this in something like visual basic, but we wouldn't to really want to... We also know that probably Gnumeric could do the job (since the xls

...ot;22_data.xls" downloaded from "Varieties_Country_A-E.xls" at "http://www.reinhartandrogoff.com/data/browse-by-topic/topics/7/": > library(gdata) > read.xls("22_data.xls") Wide character in print at C:/Users/sgraves/pgms/R/R-2.15.2/library/gdata/perl/xls2csv.pl line 270. > sessionInfo() R version 2.15.2 (2012-10-26) Platform: x86_64-w64-mingw32/x64 (64-bit) locale: [1] LC_COLLATE=English_United States.1252 [2] LC_CTYPE=English_United States.1252 [3] LC_MONETARY=English_United States.1252 [4] LC_NUMERIC=C [5] LC_TIME=English_United States.1252 att...

...of functions is now available on CRAN at http://cran.r-project.org/src/contrib/Descriptions/gregmisc.html for both Unix and Windows systems. The most notable enhancement provided by this release is: - read.xls(), a function to read Microsoft Excel files by translating them to csv files via the xls2csv.pl script has been added. I've also provided Unix and MS-Windows scripts in <R_LIBRARY_DIR>/gregmisc/bin which allow you to call xls2csv directly. The code uses perl libraries which are included in the package, so perl must be in the execution path. Other enhancements include...

...of functions is now available on CRAN at http://cran.r-project.org/src/contrib/Descriptions/gregmisc.html for both Unix and Windows systems. The most notable enhancement provided by this release is: - read.xls(), a function to read Microsoft Excel files by translating them to csv files via the xls2csv.pl script has been added. I've also provided Unix and MS-Windows scripts in <R_LIBRARY_DIR>/gregmisc/bin which allow you to call xls2csv directly. The code uses perl libraries which are included in the package, so perl must be in the execution path. Other enhancements include...

Frequently I need to convert a .xls to a .csv (for import into R) and I do this by opening the file in excel and saving it as a csv. I would rather do this using WinXP's context menu (right click the xls, choose "convert to csv") but I don't know of a utility that does this. Any ideas? Thanks, Mark

Sto imparando ora ad utilizzare R. Ho un problema: devo caricare i dati da un file xls creato da me, utilizzando la funzione "read.xls" produce il seguente errore: Errore in xls2csv(xls, sheet, verbose = verbose, ..., perl = perl) : Unable to read xls file 'indagineUSA.xls'. Errore in file.exists(tfn) : argomento 'file' non valido Cosa c'è che non va? La directory di lavoro è quella giusta. Grazie [[alternative HTML version deleted]]

...;XXX.xls'. Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file '/tmp/Rtmp5QQjSI/file1665315c.csv' missing! In addition: Warning message: running command '"/usr/bin/perl" "/home/t227/R/x86_64-pc-linux-gnu-library/2.12/gdata/perl/xls2csv.pl" "XXX.xls" "/tmp/Rtmp5QQjSI/file1665315c.csv" "1"' had status 9 Error in file.exists(tfn) : invalid 'file' argument And the file which I am trying to read opens perfectly in Open Office. Any help will be appreciated. -- Regards, Shrey Sinha [[a...

Dear R list, I am trying to read in .xls files. I have tried using package 'gdata', I get the following error. > dataset <- read.xls("June.xls") Wide character in print at /Library/Frameworks/R.framework/Versions/2.14/Resources/library/gdata/perl/ xls2csv.pl line 262. Seems like this is a problem coming from Perl? I tried to install package 'xlsReadWrite', it does not show up on my list of packages. I am using a Mac. Thanks, Bob [[alternative HTML version deleted]]

...sheet. Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file 'C:\Tmp\RtmpYvLnAu\file7f06650f.csv' missing! In addition: Warning message: running command '"C:\Apps\Perl\bin\perl.exe" "C:/Program Files/R/R-2.13.0/library/gdata/perl/xls2csv.pl" "excelFileName.xls" "C:\Tmp\RtmpYvLnAu\file7f06650f.csv" "Test Sheet"' had status 5 Error in file.exists(tfn) : invalid 'file' argument However, the same command works fine with another excel file stored in the same directory. Could you please...

...eet=i,verbose=TRUE,perl="perl")) rc<-class(wksh) print(sprintf("------- i=%2d rc=%s ---------------",i,rc)) if (rc != "try-error") { print("--- summary(wksh)= -----"); print(summary(wksh)) i <- i+1 } } At first I found the problem that xls2csv adds one space to the every item in the last column. The second problem is, that I could not found an a possibility to save the name of the worksheet. It is shown on the screen, if I use the last script. I see something like Writing Sheet number 1 ('strenger') to file '/tmp/RtmpFpSkB...

I have Excel files containing data that I would like to move to R. They are in the standard form of a one row header followed by rows of data, one record per row EXCEPT that there are a few rows of comments before the header. The number of rows of comments varies. For Excel files of this form without comments I have had success with: require(RODBC) z <-

...c $path; true) 2>/dev/null& ? ?wait_timeout 2>/dev/null ?elif [ $fmt = "ppt" ]; then -? (/usr/bin/catppt $path; true) 2>/dev/null& +? (/usr/local/bin/catppt $path; true) 2>/dev/null& ? ?wait_timeout 2>/dev/null ?elif [ $fmt = "xls" ]; then -? (/usr/bin/xls2csv $path; true) 2>/dev/null& +? (/usr/local/bin/xls2csv $path; true) 2>/dev/null& ? ?wait_timeout 2>/dev/null ?elif [ $fmt = "odt" -o $fmt = "ods" -o $fmt = "odp" ]; then ? ?xmlunzip "content.xml" --- src/plugins/fts/fts-parser-tika.c.orig? ? ?...

...some faint recollection that the Microsoft DLL incorrectly parses a column with non-empty rows due to some formatting issue of those particular columns, which I was unable to cure by re-formatting the source worksheet. I have had to resort to using the gdata package which runs a Perl script "xls2csv.pl", which converts an Excel spreadsheet to CSV, for a few Excel spreadsheets which exhibit the particular anomalies preventing use of RODBC. Leif Kirschenbaum Senior Yield Engineer Reflectivity, Inc. (408) 737-8100 x307 leif at reflectivity.com > Message: 21 > Date: Mon, 9 Jan 2006 1...

Hello, R users, I am a very beginner of R and tried read.csv to import an excel file after saving an excel file as csv. But it added alternating rows of fictitious NA values after row number 16. When I applied read.delim, there were trailing several commas at the end of each row after row number 16 instead of NA values. Appreciate your help. Kyong [[alternative HTML version deleted]]

Dear R gurus, particularly those of generous M$ tolerance and diverse gifts and knowledge! I have an interesting challenge that I will end up crunching in R involving service usage by patients. Maybe I can do all of it in R but I can't see how yet. My situation is that our IT Department can give me loads of XLS files about patients one of our services have seen. The are one per patient