Got same error in this line
Object temp = range.Cells[i][0].Value;
Solved with non-zero based index
Object temp = range.Cells[i][1].Value;
How is it possible that the guys who created this library thought it was a good idea to use non-zero based indexing?
More Related Contents:
- How do I properly clean up Excel interop objects?
- Write Array to Excel Range
- Excel Interop – Efficiency and performance
- A Simple C# DLL – how do I call it from Excel, Access, VBA, VB6?
- How to use Microsoft.Office.Interop.Excel on a machine without installed MS Office?
- Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
- Microsoft.Office.Interop.Excel really slow
- Excel interop: _Worksheet or Worksheet?
- Excel error HRESULT: 0x800A03EC while trying to get range with cell’s name
- How do I import from Excel to a DataSet using Microsoft.Office.Interop.Excel?
- C# – How to copy a single Excel worksheet from one workbook to another?
- Resources for learning c# Excel interop [closed]
- No definition found for GetActiveObject from System.Runtime.InteropServices.Marshal C#
- how to solve Exception:Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) in C#?
- Printing Excel using Interop
- .Net Excel Interop Deleting a worksheet
- How to read data of an Excel file using C#?
- Handling unhandled exceptions problem
- Closing Excel Application Process in C# after Data Access
- How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
- What is the algorithm to convert an Excel Column Letter into its Number?
- Cell color changing in Excel using C#
- Please explain why I am able to instantiate the “Application” interface in Excel VSTO
- Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
- Lots of first chance Microsoft.CSharp.RuntimeBinderExceptions thrown when dealing with dynamics
- Is there a built in .NET exception that indicates an illegal object state?
- Asp.net mvc override OnException in base controller keeps propagating to Application_Error
- Explicit/implicit cast operator fails when using LINQ’s .Cast() operator
- Could not load file or assembly ‘System.Windows.Interactivity’ [duplicate]
- Send message to a Windows process (not its main window)