Re: formatting columns

2001-08-06 Thread Eric Wisti
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.

Re: formatting columns

2001-08-06 Thread Chris Garringer
Excel should only see the \t character. It sounds as though the \t is not being picked up correctly. Have you tried a comma delimiter? It not Perl, but I have had better luck with comma or semi-colon delimiters with Excel. Chris D. Garringer LAN/WAN Manager Master Certified Netware Engineer