Free Support Forum - aspose.com

Aspose Cells java-19.2,19.3 -Sheet getting renamed after import


#1

Hi,

We are using aspose java to merge CSV files to base excel.
After merging SWDATA csv to base excel , the sheet is getting renamed with the excel file name. Because of this
some of our formulas which are referring to the sheet are not working.
Below is the code we are using.

		Workbook wb=new Workbook(out+"\\ram.xlsb");
		if(wb.getWorksheets().get("SWDATA")==null)
		{
			wb.getWorksheets().add("SWDATA");
		}
		Cells cells =wb.getWorksheets().get("SWDATA").getCells();
		
		final TxtLoadOptions options = new TxtLoadOptions();	
		options.setLocale(Locale.getDefault());


		options.setSeparatorString("~");
		options.setLoadStyleStrategy(TxtLoadStyleStrategy.EXACT_FORMAT);	
		options.setHasFormula(true);	

		cells.importCSV(csv+"\\SWDATAbe2359e70a22dc8c0218da0f66b228da_1553673199564.csv", options, 0, 1);
		
		wb.save(out+"\\ram.xlsb",SaveFormat.XLSB);

Please note that the issue is not happening with aspose-cells-18.5.jar .
Issue is with latest jars (aspose-cells-19.2.jar,19.3.jar also) only.

Attached sample program and CSV,Excel files. Please look into this.

Regardsaspose issue.zip (1.1 MB)

Prasuna


#2

@PrasunaKota,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-42862 - Sheet name getting renamed in formulas after CSV import

#3

@PrasunaKota,

This is to inform you that we have fixed your issue (logged earlier as “CELLSJAVA-42862”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.


#4

Thanks for the quick fix.
We are waiting for this to be released so that we can perform QA and release it to our customers.


#5

@PrasunaKota,

You are welcome. We will let you know as soon as it will be released.


#6

@PrasunaKota,

Please try our latest version/fix: Aspose.Cells for Java v19.3.3 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells for Java_v19.3.3.zip (6.5 MB)


#7

Thanks for the solution. We will consume this jar and update you.


#8

@PrasunaKota,

Please take your time to test/evaluate the fix in your scenario. Hopefully it will fix your issue. Feel free to contact us any time if you still find any issue.


#9

The issues you have found earlier (filed as CELLSJAVA-42862) have been fixed in Aspose.Cells for Java 19.4. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi


#10

The same is true for the .Net library…


#11

@beat.ackermann,

Yes, the same fix is included in relevant .NET library. In the event of any further queries or issue, feel free to write us with details, we will be happy to assist you soon.