Hi, I have a workbook with formula linking to other external workbooks, how do I refresh or update the links so that it can show actual values from the other workbooks? I’m using asposecells module for python running with jpype, currently I’m using the below codes to refresh the formula calculation but this only calculates values within the current workbook and not formula that are linked to external workbooks.
My current python code
import asposecells
jpype.startJVM()
from asposecells.api import Workbook
Yes, by default, Aspose.Cells for Python API does not support to calculate formulas whose source is external workbooks. You may try to use Workbook.updateLinkedDataSource() method for the task if it works. You need to load/open the source (external) file(s) via Workbook object separately. See the example code in the thread for your reference, the sample code is in .NET but you may easily convert it for Python(Java) accordingly.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.