Xml datasource

tamty · September 21, 2005, 9:04am

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

Thanks

Laurence · September 21, 2005, 6:52pm

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.Worksheets Idea .Cells;
cells.ImportDataTable(ds.Tables Idea , false, 0, 0);
}

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

tamty · September 21, 2005, 11:24pm

thx…laurence,

let’s me try.

thanks