When exporting the report to Excel, the default xls file is limited to 64k rows

0
votes

I have created a c# winforms application that has a reportviewer. When exporting the report to Excel, the default xls file is limited to 64k rows. I have searched and found that changing the rendering to EXCELOPENXML will solve the problem, however when I inspect the array rendering extentions:

RenderingExtension[] re = reportViewer1.LocalReport.ListRenderingExtensions();

There are only 3, Excel, PDF and Word.

Without upgrading the application to vs2012? What do I have to do to get the export option to render an Excel 2007/10 format without the 64k row limit?

2
c#excelvisual-studio-2010reportviewer
You can't. The 64K row limit is internal to older versions of Excel. If you just want to output without a row limit for those who can actually read it, use CSV format. – Robert Harvey

2 Answers

0
votes

you just need the PIA office interop dlls you don't need VS 2012. The Office 2007 Dlls first came with Visual Studio 2008. These are the earliest ones to support the new larger format.

You can download the Office 2010 PIA DLLs here

0
votes

You can use NPOI for manipulate with Excel-files. This is a free library that does not need MS Office installed to work with it's file.