Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Mon May 11, 2020 10:16 am

Hi,

When I try to open a file using Workbook.LoadFromFile the following exception is thrown:
System.ArgumentOutOfRangeException: 'Cannot find record with specified index
Parameter name: iColumnIndex'


This doesn't happen on every workbook but I can't find any material differences between the ones that do and do not work, apart from some different formula used. Can someone please assist? The sample file contains sensitive data, if I upload a file to this ticket is it visible to all users or just myself and support staff?

Thanks.

jon@alphakinetic.com
 
Posts: 2
Joined: Tue May 07, 2019 2:26 pm

Tue May 12, 2020 3:05 am

Hi,

Thanks for your inquiry.
Please provide your input documents to us for reference, then we will do further investigation. You could send it to us via email(support@e-iceblue.com). Don’t worry, we will absolutely keep your documents confidential and won’t use them for other purpose.

Sincerely,
Sara
E-iceblue support team
User avatar

Sara.Yang
 
Posts: 33
Joined: Wed May 06, 2020 1:05 am

Wed Jul 08, 2020 3:35 am

Hello,

Thank you for sharing your file via email.
Glad to inform that we just released Spire.XLS Pack(Hotfix) Version:10.7.2 which fixed your issue, please download it from the following links to test.
Website link: https: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget link: https: https://www.nuget.org/packages/Spire.XLS/

Sincerely,
Lisa
E-iceblue support team
User avatar

Lisa.Li
 
Posts: 1261
Joined: Wed Apr 25, 2018 3:20 am

Return to Spire.XLS