Can't output CellMatrix with more than 65536 rows

For discussion of the xlw project for producing xlls.

Can't output CellMatrix with more than 65536 rows

Postby Lip Jin » Tue Aug 13, 2013 9:24 am

Hi,
I'm using Excel 2010 and Visual studio 2008 and XLW version 4. My xlwwrap function can't output a CellMatrix in Excel with more than 65536 rows. I have 65673 rows in my original data and it only outputs the first 137 rows leaving out the remaining 65536 rows. Excel 2007 onwards should be able to handle more than 65536 rows.
How do I go about solving this? Thanks.
Jin
Lip Jin
 
Posts: 2
Joined: Tue Aug 13, 2013 9:11 am

Re: Can't output CellMatrix with more than 65536 rows

Postby Lip Jin » Wed Aug 14, 2013 7:35 am

Hi,
I suspect the function:
operator LPXLFOPER() { return XlfOperImpl::instance().operator_LPXLFOPER(*this); }
on line 131 of XlfOper.h is causing my data to be truncated because if I open *this up array has rw=137.
Does anyone know how I can go about solving this?
Lip Jin
 
Posts: 2
Joined: Tue Aug 13, 2013 9:11 am


Return to xlw

Who is online

Users browsing this forum: No registered users and 2 guests

cron