Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Chas Owens
On 7/16/07, a_arya2000 <[EMAIL PROTECTED]> wrote: Thanks for your extra ordinary help guys. Actually, I already run similar type of script which created a spreadsheet with maximum member of rows and columns, the file size was 136 MB, it worked fine. Now you can conclude there is something wrong w

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread a_arya2000
Thanks for your extra ordinary help guys. Actually, I already run similar type of script which created a spreadsheet with maximum member of rows and columns, the file size was 136 MB, it worked fine. Now you can conclude there is something wrong with my script. However, when the script read a txt

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Chas Owens
On 7/16/07, Chas Owens <[EMAIL PROTECTED]> wrote: On 7/16/07, a_arya2000 <[EMAIL PROTECTED]> wrote: > By the way, my file size around 22 MB so, is it > possible that Spreadsheet::WriteExcel::Big is not good > enough for this size? snip What follows is a test script you can use to determine if it

RE: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Ken Foskey
On Mon, 2007-07-16 at 14:23 -0700, a_arya2000 wrote: > I have like around 24K rows. Thank you. Sounds like a design problem. Use a database and connect the excel spreadsheet to that data source. Seems a lot easier. -- Ken Foskey FOSS developer -- To unsubscribe, e-mail: [EMAIL PROTECTED] F

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Chas Owens
On 7/16/07, a_arya2000 <[EMAIL PROTECTED]> wrote: By the way, my file size around 22 MB so, is it possible that Spreadsheet::WriteExcel::Big is not good enough for this size? snip What follows is a test script you can use to determine if it is your code or Spreadsheet::WriteExcel::Big (or possi

RE: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread a_arya2000
o: beginners@perl.org > > Cc: a_arya2000 > > Subject: Re: Spreadsheet::WriteExcel problem with > large file > > > > By the way, my file size around 22 MB so, is it > > possible that Spreadsheet::WriteExcel::Big is not > good > > enough for this size? >

RE: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Wagner, David --- Senior Programmer Analyst --- WGO
> -Original Message- > From: a_arya2000 [mailto:[EMAIL PROTECTED] > Sent: Monday, July 16, 2007 14:06 > To: beginners@perl.org > Cc: a_arya2000 > Subject: Re: Spreadsheet::WriteExcel problem with large file > > By the way, my file size around 22 MB so, is it >

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread a_arya2000
By the way, my file size around 22 MB so, is it possible that Spreadsheet::WriteExcel::Big is not good enough for this size? --- a_arya2000 <[EMAIL PROTECTED]> wrote: > Thank you very much for suggestions guys, I tried > using Spreadsheet::WriteExcel::Big but still having > the same issue. I am n

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Chas Owens
On 7/16/07, a_arya2000 <[EMAIL PROTECTED]> wrote: Thank you very much for suggestions guys, I tried using Spreadsheet::WriteExcel::Big but still having the same issue. I am not sure, what I am doing wrong. My file size is indeed more than 7 MB. Thank you, Partha Dhar Did you try the suggestion

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread a_arya2000
Thank you very much for suggestions guys, I tried using Spreadsheet::WriteExcel::Big but still having the same issue. I am not sure, what I am doing wrong. My file size is indeed more than 7 MB. Thank you, Partha Dhar --- Raja Vadlamudi <[EMAIL PROTECTED]> wrote: > Use Spreadsheet::Big module if

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Raja Vadlamudi
Use Spreadsheet::Big module if the file size happens to be larger than 7 MB. The latest Spreadsheet module will have this Big module integrated, but if you are using older version, then you need to use this Big module. On 7/16/07 8:46 AM, "Rob Dixon" <[EMAIL PROTECTED]> wrote: > a_arya2000 wrote

Re: Spreadsheet::WriteExcel problem with large file

2007-07-16 Thread Rob Dixon
a_arya2000 wrote: Hi, the problem is, when write large spreadsheets of 20,000 rows or so, the module finishes without error, but when I try to open the spreadsheet with Excel I get error messages about the spreadsheet being 'unrecoverably scrambled'. I've never had a problem with it except for t