in reply to Excel Limitations

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.

Walking the road to enlightenment... I found a penguin and a camel on the way.....
Fancy a yourname@perl.me.uk? Just ask!!!

Replies are listed 'Best First'.
Re^2: Excel Limitations
by binlid (Initiate) on Apr 27, 2005 at 10:11 UTC
    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
[reply]

      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.

      Walking the road to enlightenment... I found a penguin and a camel on the way.....
      Fancy a yourname@perl.me.uk? Just ask!!!
[reply]

In Section Seekers of Perl Wisdom