max rows

[mmertel]

I need to overcome the max_rows, 65536, limit. Is there something I
can do?

[jmcnamara]

On Aug 3, 3:59 pm, mmertel <mark.mer...@yahoo.com> wrote:
> I need to overcome the max_rows, 65536, limit. Is there something I
> can do?

Hi,

There is no way around this limit with the current (binary) version of
Spreadsheet::WriteExcel. It is only possible with the new Open XML
version of Excel that isn't supported by Spreadsheet::WriteExcel.

Sorry,

John.
--

[Mark Mertel]

John,

I figured that out reading up on the newsgroups. Bummer.

Thanks

 

---
Mark Mertel
mark....@yahoo.com

---

From: jmcnamara <jmcn...@cpan.org>
To: Spreadsheet::WriteExcel <spreadsheet...@googlegroups.com>
Sent: Wednesday, August 5, 2009 5:20:30 PM
Subject: [Spreadsheet::WriteExcel] Re: max rows

[donisback]

There is a workaround for the max number of rows. What I do is check
the number of rows in the text file before converting it to csv
If the number of rows exceeds 65000, then I put the text file in a
while loop which will insert in a separate worksheet.
I break each text file into rows <65000 and suffix the file with _1,_2
etc.

I do all this in the shellscript which in turn passes the number of
sheets and the filename as a parameter to the perl file.

Basically, we are adding worksheets instead of a new file.

Hope that helps you..

Thanks

On Aug 6, 8:54 pm, Mark Mertel <mark.mer...@yahoo.com> wrote:
> John,
>
> I figured that out reading up on the newsgroups. Bummer.
>
> Thanks
>
>  ---
> Mark Mertel

> mark.mer...@yahoo.com
>
> ________________________________
> From: jmcnamara <jmcnam...@cpan.org>