Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1070
Excel Workblook.Load() takes a very long time
posted

I've seen many posts about Excel.Workbook.Load() taking a long time. We're using 2015.1. Have there been any improvements in this area in more recent versions?

Specifically:

1. We need to open a workbook and get the list of worksheets. This can take anywhere from 90 seconds to 15 minutes, depending on how many rows are in the spreadsheet.

2. We need to open a specific sheet and examine the first and second row to get column headers. 

3. In general, opening the file using Workbook.Load() takes far longer than just opening the file in Excel directly. Has this been optimized in new releases?

Thanks,

Parents Reply Children