We are currently evaluating Aspose Cells for Java (8.8.0) and have a question regardin refreshgin external data.
We currently have a number of Excel Templates which contain embedded Web Query Data Source URLs. Ideally we would like to programmatically set these URL and refresh the data set on the sheet before saving the sheet as a PDF.
I can see that it is possible to update the URL, but is it possible to refresh the data connection programmatically so as the saved PDF will get automatically updated?
If there are any code examples you can send on that would be great.