getting below error while merging :-
ERROR [ExcelMerger:230]: java.lang.NumberFormatException: For input string: "Infinity"
java.lang.NumberFormatException: For input string: “Infinity”
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Long.parseLong(Long.java:441)
at java.lang.Long.parseLong(Long.java:483)
at com.aspose.cells.b.a.zp.a(Unknown Source)
at com.aspose.cells.zaor.b(Unknown Source)
at com.aspose.cells.zaor.a(Unknown Source)
at com.aspose.cells.zaor.a(Unknown Source)
at com.aspose.cells.zadr.a(Unknown Source)
at com.aspose.cells.zadr.A(Unknown Source)
at com.aspose.cells.zadr.z(Unknown Source)
Aspose version:- aspose-cells-8.4.1.4.jar
Java Version:- jdk1.7.0_71
below is the merger code to replicate the issue:-
import java.io.File;
import java.io.FileFilter;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import com.aspose.cells.License;
import com.aspose.cells.Workbook;
public class TestExcel {
public static void main(String[] args) {
License license = new License();
try {
license.setLicense(new FileInputStream(“D:\NavPack_Devel\conf\Aspose.Cells.lic”));
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String path=“Z:\My Documents\ASPOSE issue\”;
File clientDir = new File(path);
File[] list = clientDir.listFiles(new FileFilter() {
public boolean accept(File pathname) {
return (pathname.getName().endsWith(“xlsx”));
}
});
Workbook SourceBook1= new Workbook();
Workbook SourceBook2= new Workbook();
for ( int i = 0; i < list.length; i++) {
System.out.println(list[i].getName());
try {
SourceBook1 = new Workbook(path+list[i].getName());
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
SourceBook2.combine(SourceBook1);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
SourceBook2.save(path+“combine.xlsx”);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}