I am trying to load a sheet using both the excel and the designer. When the original file is saved using an older version of excel I receive the error “Invalid file format”, when i use a newer version of excel i get “Object not set to an instance…” (see below). The sheet contains both vba and macro’s that i dont need to call but i need to be able to open the file, modify some cells, save the file and the macro’s and vba should survive. I’ve tried opening both xlt’s and xls’s with the same result. I can send the actual excel under seperate cover if needed.
Sample Code:
Aspose.Excel.License lic = new Aspose.Excel.License();
lic.SetLicense(@“c:\work\dkr\Aspose.Excel.lic”);
ExcelDesigner designer = new ExcelDesigner();
designer.Open(@“c:\OASISTRDS.xlt”);
designer.Save(@“c:\OASISTRDS2.xls”);
// Excel excel = new Excel();
// excel.Open(@“c:\OASISTRDS_1.xls”);
// excel.Save(@“c:\OASISTRDS2.xls”);
“Object reference not set to an instance of an object.”
" at Aspose.Excel.av.a(MemoryStream A_0)\r\n at Aspose.Excel.av.a(String A_0)\r\n at Aspose.Excel.Excel.Open(String designerSpreadsheet)\r\n at ExcelMacroTester.Form1.button1_Click(Object sender, EventArgs e) in c:\work\p4\users\devperry\oasis\test\excelmacrotester\form1.cs:line 99"