Re: Excel Limitations

[ghenry]

Your questions aren't very clear.

As I understand you:

1. Your script queries a database of some kind and creates a Excel spreedsheet of the results.
2. You open that spreadsheet and receive a "File not loaded completely" error
3. You have somehow worked out that in an old UNIX System your query created three Excel spreedsheets due to the Spreadsheet::WriteExcel Module?
4. You are wondering if something can be done in another script

Well, we don't know what you have worked out to be the error, and we don't know what you are asking.

Could you kindly explain each point again please?

Thanks.

[binlid]

Points 1&2 are correct. On the old UNIX system there was a shell script that after quering the database returned the results into 3 seperate files due to the size of the data returned. On our new W2K system the Perl script returns this into one single XLS file and this is where we get the error mentioned in point 2. I am wondering if I can add a piece of code to the PERL script that when it is returning the data and hits for example 64K rows that it closes the file and opens another XLS file to continue with the rest of the extract until it completes. Hope this makes a little more sense

[ghenry]

Can we see your script?

This would help by letting us see what modules you are using and what the script is actually doing.

Thanks.