Results 1 to 2 of 2
Hi All,
I have been using shell script to write my data into .csv files. But I dont know if I can add and write into a new worksheet in ...
- 11-26-2008 #1Just Joined!
- Join Date
- May 2008
- Posts
- 9
Shell script for .csv files
Hi All,
I have been using shell script to write my data into .csv files. But I dont know if I can add and write into a new worksheet in the same .csv file using shell script. I tried finding for commands but could not get any. Perl script provides such options but I dont know perl scripting. Please help me in this regard. Thanks in advance.
- 11-26-2008 #2Just Joined!
- Join Date
- Nov 2008
- Posts
- 11
A .csv file doesn't contain worksheets, only values. When opened in Excel, the .csv file is treated as a worksheet but it isn't actually one.
The Perl module you found probably writes into an .xls (Excel binary file) not a .csv file. I don't know how you could do the same from shell, but a Python script with pyxlwriter could do it.
Second post in a row I've advocated Python - I'm scaring myself now.


Reply With Quote