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.