- I need to be able to read all “Connection” objects in a workbook along with its associated settings. To see what I am referring to create a web query to some random webpage.
Then go to the “data tab” of Excel 2010 and click the “Connections” button. You should see a single item in the list called “Connection” … click that and click "Properies"
Click the “Definition” tab
On this tab I need to be able to access:
-The connection type (in this case Web Query)
-The connection string (aka the URL)
This information can be found in the “connections.xml” file in the “xl” folder of the unzipped XLSX doc.
- If you created a web query in step #1 you will need to select a worksheet to target the import to.
If you select any column/row inside of the data returned from the web query then right click you will be presented with a menu "Edit Data Range Properties"
I need to be able to access all of the properties in this dialog. Is there a way to do this in Aspose.Cells Java?
This information can be found in the “queryTables” directory in the “xl” folder, the sheet.xml.rels file for the worksheet that contains the external data range, and the “workbook.xml” file “definedNames” element.
- If you create a pivot table based on the web query from step #1 and #2 that pivot table will have a source that points back to a given sheet. The source is stored in the PivotCache for the pivot table.
Aspose.Cells has this object:
Can we get the same support in Aspose.Cells Java?