We're sorry AsposeCloud doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.cloud

cellsWorkbookPostImportData (Import CSV into XLSX) not working anymore for certain cases

Hello,

For certain test cases which worked until 20 Jan 2022, calling cellsWorkbookPostImportData now either produces an “Object not set to reference” error, or imports data incorrectly into the XLXS

If CSV Import is so unreliable we will have trouble when going to production environment.

How can I attach or submit the CSV and XLSX file causing problems?

Thanks

@Huperty,
Could you provide a simple test case to reproduce the issue?
And tell us which version SDK?
We will fix it ASAP.

@Huperty,

We had tested and did not reproduce the issue you mentioned.
Please refer to our code sample.
If you are still facing this problem, please provide code and sample files.

public static void main(String[] args) {
try{
CellsApi cellsApi = new CellsApi(System.getenv(“ProductClientId”),System.getenv(“ProductClientSecret”));
File file1 = new File(“D:\projects\aspose\examples\testdata\source\TestImportData.xlsx”);
cellsApi.uploadFile(“JavaTest/Book1.xlsx”, file1, null);
File file2 = new File(“D:\projects\aspose\examples\testdata\source\TestImportDataCSV.csv”);
cellsApi.uploadFile(“TestImportDataCSV.csv”, file2, null);
ImportCSVDataOption importData = new ImportCSVDataOption();
importData.setSourceFile(“TestImportDataCSV.csv”);
importData.setDestinationWorksheet(“Sheet2”);
importData.setFirstRow(1);
importData.setFirstColumn(1);
importData.setConvertNumericData(false);
importData.setSeparatorString(";");
importData.setImportDataType(“CSVData”);
CellsCloudResponse response = cellsApi.cellsWorkbookPostImportData(“Book1.xlsx”, importData, “JavaTest”, null);
System.out.println(response.getStatus());
}
catch( Exception e)
{
System.out.print(e.getMessage());
}
}

We use to Aspose.Cells Cloud SDK for Java 22.1.

I will prepare a test case. This may take a few days, I have to anonymize our data. How can I upload our XLSX and CSV so it is only visible to Aspose?

@Huperty,
You may refer to how-to-send-license-file-to-support-team.