Directly populating XML data into Excel

Aspose.Cells Product Family
, ,
1

Hi we are evaluating the usage of aspose excel in our project.

Is it possible to directly bind a XML to a excel worksheet to populate data?
Or do we need to convert to a data table and use it for data population.

Please let me know

thanks
SRaj

2

Hi SRaj,

Currently Aspose.Excel doesn’t support to directly to import an XML file. We will put this feature in the future release.

Converting the XML to a data table is a good work around. I think it could meet your need.

3

@SRaj,
We are glad to share that Aspose.Cells which has replaced Aspose.Excel now supports this feature. Aspose.Excel is discontinued now and no more available. Aspose.Cells contains all the features of Aspose.Excel as well as latests features available in different versions of MS Excel. Here is an example which can be used to import XML into Excel file:

// Create a workbook
Workbook workbook = new Workbook();

// URL that contains your XML data for mapping
string XML = "http://www.aspose.com/docs/download/attachments/434475650/sampleXML.txt";

// Import your XML Map data starting from cell A1
workbook.ImportXml(XML, "Sheet1", 0, 0);

// Save workbook
workbook.Save(dataDir + "output_out.xlsx");

Following article contains detailed information about this feature:
Import XML Map inside a Workbook using Aspose.Cells

Free trial version of this product is available here:
Aspose.Cells for .NET (Latest Version)

A detailed solution is available here which can be used for testing different features of this product.