Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

Excel Limitations

by binlid (Initiate)
on Apr 27, 2005 at 09:05 UTC ( #451870=perlquestion: print w/replies, xml ) Need Help??

binlid has asked for the wisdom of the Perl Monks concerning the following question:

Hi All, I have a PERL script that basically goes to a database and returns all the details to a XLS file. However when I try to open it I get a "File not loaded completely" error. I have worked it out that in the old UNIX system this query was returned but split into three smaller files due to Excel Spreadsheet limitations. I was wondering could the same be done in the PERL script? Any help is much appreciated. Thanx Baz

Replies are listed 'Best First'.
Re: Excel Limitations
by ghenry (Vicar) on Apr 27, 2005 at 10:01 UTC

    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?


    Walking the road to enlightenment... I found a penguin and a camel on the way.....
    Fancy a Just ask!!!
      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

        Can we see your script?

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


        Walking the road to enlightenment... I found a penguin and a camel on the way.....
        Fancy a Just ask!!!
Re: Excel Limitations
by dragonchild (Archbishop) on Apr 27, 2005 at 12:33 UTC

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://451870]
Approved by Corion
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (2)
As of 2020-07-07 19:35 GMT
Find Nodes?
    Voting Booth?

    No recent polls found