null reference exception when trying to open a worksheet?

Dec 14, 2010 at 10:50 PM
Edited Dec 14, 2010 at 10:51 PM

I have .xlsm file that I'm using as a template to build out a series of excel files.  I want to open the file and then copy the worksheet for each account I have.  However, whenever I try to open the work sheet I get a null reference exception.  There are a series of macros, but I've tried taking them out... not sure what could be causing this?  If I try this with a blank .xlsm file it works fine.  Any thoughts?  My code is pretty basic, I'm just doing   

var ws = pck.Workbook.Worksheets[1];



- Dave

Dec 15, 2010 at 2:05 PM

There is properbly something in your template that is not supported by the library. Create an issue and upload the template so I can have a look at it.


Dec 15, 2010 at 5:47 PM

Is there a list anywhere of things that are not supported?  I'll see about uploading my template in a bit.  Thanks!


- Dave