Aspose.Cells for .Net - Manage web queries

Aspose.Cells Product Family
1

Hi

A Web query can be set up manually in Excel 2007 via Data --> From Web (Get External Data from Web). Does Aspose cells provide methods that allow creating/editing "web queries" in a workbook?

Does it provide the ability to refresh a pivot table programatically?

Note - I am currently using v4.7.1.0.

Thanks

Nakul Ringshia

2

Hi,


I am afraid, your desired feature (create/manipulate web queries) is not available at the moment. I have logged a ticket with an id “CELLSNET-41500” for your case. Once we have any update on it, we will let you know here.

Regarding “Does it provide the ability to refresh a pivot table programatically?”, Yes, it does but for simpler data tables (without involving any external data sources). You may use the following two methods to do the refresh and calculate the pivot table report:

PivotTable.RefreshData() and PivotTable.CalculateData()

Thank you.