Refreshing Data Using WebQueryConnection

Aspose.Cells Product Family
1

Hi,


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.

thanks

Dave
2

Hi Dave,


Thank you for contacting Aspose support.

I am afraid, the current implementation of Aspose.Cells APIs do not provide the ability to refresh the Web Query data source. If you can provide us a sample spreadsheet containing such source/connection, we can pass it on to the product team for feasibility analysis by logging an appropriate ticket in our database.