Shell Programming and Scripting

Hi

I plan to read an excel file (using Spreadsheet::ParseExcel) and create a clone of it with some other name (using Spreadsheet::WriteExcel).

I am able to get the skeleton by reading cells in every[row,column] pair of every worksheet. But I am not able to get the format string of these cells. I want the clone to reflect the formatting present in the parent as well!

http://search.cpan.org/~kwitknr/Spreadsheet-ParseExcel-0.2603/ParseExcel.pm#Formatter_class
is supposed to help me out here. But the usage is not very user-friendly!

Could someone help me out here.

Thanks,
Yuga

The URL which I had specified in my request is incorrect.

Following is the correct URL:
Formatter Class

Thanks,
Yuga

Surely if you want to clone (i.e. create an exact copy), you could just do

system( "cp /my/oldfile.xls /my/newfile.xls" );

What's the point reading the whole file in and writing it out again if you just want to copy it?

Cheers
ZB

Hi zazzybob!

My requirement is to automate row additions into excel files. Since there is no module which lets me append rows to worksheets in an excel file, I decided to first clone the file (into a temporary file), append rows into the temporary file (once I complete cloning) and then save the temporary file as the original file (which I intended to append).

This way, I kind of simulate an append into an excel file.

'cp' would not help me!

You can try to write a macro in VB, embedded in the excel file.
The marco will do the importing of data from, say... text file in a directory.

You have to ftp, NFS, etc ... share the file from unix to windows..

Hey izy100, thats a pretty interesting and intelligent suggestion. I am a newbie to using Macros in VBScript. Well let me try to work this out.

Thanks for this suggestion