Excel Package exception: Object reference not set to an instance of an object.

Sep 16, 2009 at 6:26 PM

Hi,

I tried this excel package by incorporating the dll to my project. It's working fine for read. But when i try to update the excel file and save it, it throws an exception:"Object refernce not set to an instance of an object. can anybody help me out? Follwing is my code:

<font size="2" color="#2b91af"><font size="2" color="#2b91af">

FileInfo 

</font></font><font size="2" color="#2b91af">

 

</font>

existingFile = new FileInfo(@"C:\Testing.xlsx");

using (ExcelPackage xlPackage = new ExcelPackage(existingFile))

{

 

// get the first worksheet in the workbook

ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets[1];

worksheet.Cell(1, 1).Value ="Testing";

<font size="2">

 

</font>

 xlPackage.Save();  // here it gives me an error: object reference not set to an insatnce of an object.<font size="2">

}

PLs help me out. Thanks.

</font>

 

Oct 1, 2009 at 4:04 AM

see http://excelpackage.codeplex.com/Thread/View.aspx?ThreadId=7005