Displaying 3 results from an estimated 3 matches for "excelfilename".
2007 Jul 08
1
Writing Excel (.xls) files on non-Windows OSs using Perl
...ilar requirements. Please note that I am providing this 'as is' and
don't have any plans to substantively modify or enhance the code. It
does what I need it to do. Feel free to modify for other needs as may be
required.
The basic calling schema is:
WriteXLS.pl [--CSVpath] [--CSVfiles] ExcelFileName
Where:
CSVpath = Path to the csv files created in R, typically done
using write.table()
CSVfiles = globbed file name specification (ie. *.csv)
ExcelFileName = FULL name of Excel .xls file to create
When the Excel file is created, a new worksheet (tab) will be created
for each CSV fi...
2013 Feb 13
1
WriteXLS: 'object not found' error within function
Dear All,
I am using WriteXLS to write tables with multiple sheets with the command:
WriteXLS("tables", ExcelFileName = fileName, SheetNames = tableList, perl = "perl",
verbose = FALSE, Encoding = c("UTF-8", "latin1"),
row.names = TRUE, col.names = TRUE,
AdjWidth = TRUE, AutoFilter = FALSE, BoldHeaderRow = FALSE,
FreezeRow = 0, FreezeCol = 0...
2011 May 26
1
Using read.xls
...sep(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 let me know what is causing t...