extracting data into excel

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

Now I'm using oracle discoverer 10g and I want to extract may file into excel without splitting into multiple sheets. My files is about greater that 16000 and up and every time it reaches the 16000 rows or more than, it split to another sheet but it spreadsheet has 65000 something rows and I want it into one sheet only. What are the possible reason/cause in splitting in multiple sheets and how can I make it in one sheet only? or does it affect the RAM of the server or the pc that I am using. hope you can help me on this ...thanks in advance!!! please help me to answer to this question... I really need this...please.... Janejuzz

Comment on extracting data into excel

Replies are listed 'Best First'.
Re: extracting data into excel by ELISHEVA (Prior) on May 20, 2009 at 03:05 UTC
What Perl modules are you using to extract the data and convert it into spreadsheets? Perhaps you could provide a brief code sample showing how you are setting configuration parameters for these modules or using their methods/functions? Best, beth	[reply]