Free Support Forum - aspose.com

Change ExternalLink to a internal worksheet

Hello.

I need to change the cells formulas to target a new internal worksheet.
I´ve tried to get a substring from the original formula and set it up in the cell (because the source worksheets have the same name) but the excel file turns in a corrupted file.
Is there a correct ways to do this?
Regards

PS: The source is on a network folder and need to be updated many times. We will copy it to a internal worksheet on the excel files to be able to update values on the sources without need to open the excel files to update the links.

I hope that’s clear enough.

Thanks

@marsso,

Thanks for providing us some details.

We need to evaluate your code and template file. Please create a simple console application (runnable), zip the project and post us here to show the issue, we will check it soon.

PS. please zip the project/file(s) prior attaching.

Thanks for replying.

It is a simple project. Here I try to change the datasource to reference the internal spreadsheet.

Thanks
DataSourceUpdater.zip (5.8 MB)

@marsso,

Thanks for the sample code and template file.

Well, you are using some older version which might have this issue. I have tested using our latest version/fix and it works fine and I do not find any issue with the output file. Please upgrade to latest version of the product and try our latest version/fix (e.g Aspose.Cells for Java v19.11.5)
aspose-cells-19.11.5.zip (6.7 MB)

Let us know your feedback.

Thank you for the reply. I’ll try it.