We’re using Aspose.Cells for Java 8.2.2.3.
We have a text file “test.csv” with one line:
0e61~18~abc~-~-~-~-~-~-~-~def~hij~-~mno~pqr~
When trying to import the above:
final Workbook workbook = new Workbook();final Worksheet sheet = workbook.getWorksheets().get(0);final Cells cells = sheet.getCells();final TxtLoadOptions options = new TxtLoadOptions();options.setSeparatorString("~");cells.importCSV(“C:\test.csv”, options, 0, 0);
We get this error:
Exception in thread “main” java.lang.NumberFormatException: For input string: “”at java.lang.NumberFormatException.forInputString(Unknown Source)at java.lang.Long.parseLong(Unknown Source)at java.lang.Long.parseLong(Unknown Source)at com.aspose.cells.b.a.zp.a(Unknown Source)at com.aspose.cells.zanx.c(Unknown Source)at com.aspose.cells.zanx.a(Unknown Source)at com.aspose.cells.zbix.a(Unknown Source)at com.aspose.cells.zbix.b(Unknown Source)at com.aspose.cells.zbix.a(Unknown Source)at com.aspose.cells.zbix.a(Unknown Source)at com.aspose.cells.Cells.importCSV(Unknown Source)at asposetest.AsposeTest.main(AsposeTest.java:36)
We tried importing the same file in Excel 2007 by simply opening it and going through Excel’s import wizard (selecting delimiter as ~), and Excel was able to import it fine.
Please advise.