Size limit on Excel Import?

Oct 1, 2012 at 2:25 AM

Is there a file size limit for Excel Imports? I have an application that attempts to import a file and fails. When I cut the number of rows in half (300) it works. When it fails the error indicates that it can't open the excel file. using Excel 2010 format (.xlsx).

Oct 11, 2012 at 4:08 PM

There is no intentional size limit within the Office Integration Pack. Have you noticed if there is a specific item that might be tripping it up? 

Oct 11, 2012 at 8:56 PM

There doesn't appear to be a specific item that it is choking on. I can split the spreadsheet up into smaller chunks and it appears to work for each chunk so it doesn't appear to be data dependent. It is a HUGE spreadsheet (746 rows by 450 columns). I only import a fraction of the columns, but the file is 1.1G. The behavior is similar but different in debug vs published app. The published app chokes on a much smaller number of rows. I was only able to import around 150 rows at a time when running the published app. It appears to be timing out on something.