QueryTables support

Aspose.Cells Product Family
1

Hi,

Does anybody knows if ASPOSE.Cells offers a equivalent method to this sintax?

I mean, manipulation of the QueryTables Collection?

Best Regards,

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://acme.com/testTable.aspx", Destination:=Range( _
"$A$1"))
.Name = "test"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlAllTables
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
ChDir "C:\Users\geraldo\Documents\temp"

2

Hi,

Do you want to import data from some external data source like Sql Server or MS Access and fill a worksheet with it? Yes, you may do this using a variety of methods of Aspose.Cells.Cells class: ImportDataTable(), ImportDataRow(), ImportDataView etc. You may try to use ADO.Net components to fetch the data from the data source based on some query and fill a dataset or datatable and import it to your workbook for your need

Related VBA/Macros we don't support it.

Thank you.

3

Hi,

I want to create a QueryTable. I don't want to create a Macro.

I would not like to use the ImportDataTable(), ImportDataRow(), ImportDataView etc. because I want my user to be able to refresh it after he dowload the generated Excel.

So, my question is: Can I create querytable with ASPOSE.CELLS?

Regards,

4

No, this feature is not supported.