Do the pre-processing and the import to Excel need to be separate? I have
used Spreadsheet::WriteExcel and it is really easy to write an Excel
spreadsheet directly from perl.
You could parse the data into a perl structure, loop through it and
layout the Excel file in one script.
Just a thought....
On Mon, 6 Aug 2001, Chirag Patel wrote:
> Date: Mon, 6 Aug 2001 12:30:12 -0700
> From: Chirag Patel <[EMAIL PROTECTED]>
> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> Subject: formatting columns
>
> Hello,
>
> I have some data in a matrix from the linux world; I am attempting to
> construct columns from the matrix and output them to a file, which later
> needs to be opened in Microsoft Excel to be manipulated. Right now I am
> making the columns using "\t" as a delimiter.
>
> If the number of columns remains small, the columns, while looking suspect
> in xterm, format nicely in Excel, but as soon as the number of columns
> become > 10, the columns start to stagger which Excel doesn't like.
>
> Any modules out there to keep columns formatted nicely?
>
> thanks,
>
> chirag
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
Eric Wisti
Kinetic, Inc.
(651) 848-0477
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
