Find the answer to your Linux question:
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 ...
  1. #1
    Just 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.

  2. #2
    Just 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
...