I have a need to open up an XLSM file and add data to an existing sheet. The data I'd be added would be columns worth of information. As my first step to see if I could use Aspose.Cells(I downloaded the latest version and am using the jar file for JDK 1.6) for this I have been trying just to open up the file. My attempts to open up an XLSM(I tried and XLSX as well but got the same error) have been unsuccessful. The problem stems from when I try to pass the file name to the "Workbook". Here is my test code:
objFileFormatType = CreateObject("java", "com.aspose.cells.FileFormatType");objLoadOptions = CreateObject("java", "com.aspose.cells.LoadOptions").init(objFileFormatType.XLSM);
objWorkBook = CreateObject("java", "com.aspose.cells.Workbook").init("C:\InductionHistoricalComparisonSpreadsheet.xlsm", objLoadOptions);
Here is the error that happens when I try executing it:
Object instantiation exception. |
An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. Error: ''. |
The error occurred in D:\inetpub\wwwroot\Projects\RRS\DeleteMe.cfm: line 58 |
56 : objLoadOptions = CreateObject("java", "com.aspose.cells.LoadOptions").init(objFileFormatType.XLSM); 57 : 58 : objWorkBook = CreateObject("java", "com.aspose.cells.Workbook").init("C:\InductionHistoricalComparisonSpreadsheet.xlsm", objLoadOptions); 59 : |