Hi,
We got the the following while trying to copy the worksheet:
Exception in thread "main" java.lang.NullPointerException
at com.aspose.cells.AutoFilter.a(Unknown Source)
at com.aspose.cells.Worksheet.copy(Unknown Source)
at com.markit.mtp.excel.TestExcel.main(TestExcel.java:77)
The following are the sample code:
workbook.open("c:\\iTest-Input.xls",FileFormatType.DEFAULT);
Worksheet inputWorksheet = workbook.getWorksheets().getSheet(0);
System.out.println("ip file open");
Workbook dest = new Workbook();
dest.open("c:\\Test_Template.xls",FileFormatType.DEFAULT);
Worksheet destWorksheet = dest.getWorksheets().getSheet(0);
destWorksheet.copy(inputWorksheet); //Exception thrown