Read and Write Table with Query Table Data Source

Read and Write Table with Query Table Data Source

With Aspose.Cells, you can read and write a table that has a QueryTable as a data source. Support for this feature also exists for XLS files. The following code snippet demonstrates reading and writing such a table by first reading the table and then modifying it to add a totals row.

The source and output Excel files are attached for reference.

Source File

Output File