Free Support Forum - aspose.com

Xml datasource

Can Aspose.Excel use XML datasource?
If not, when can it support?

Thanks

It’s easy to load an XML datasource with Aspose.Excel. Following is the sample code:

DataSet ds = new DataSet();
ds.ReadXml(“C:\datasource.xml”);

Excel excel = new Excel();
for(int i = 0; i < ds.Tables.Count; i ++)
{
excel.Worksheets.Add();
Cells cells = excel.WorksheetsIdea.Cells;
cells.ImportDataTable(ds.TablesIdea, false, 0, 0);
}

excel.Save(“C:\data.xls”);

thx…laurence,

let’s me try.

thanks