Extract data from XML in Excel Spreadsheet

Aspose.Cells Product Family
1

We are using a spreadsheet developed in Excel 2003. It contains XML data that we would like to extract to populate records in our database.

The web application is written using VB.Net.

Can Aspose.Cells be used to access the XML data in an existing spreadsheet?

2

Hi,

Do you mean XML Map in MS Excel?

Please post your template file, we will check it soon.

3

Simon:

I am new to XML so please forgive me if I use improper terminology or misunderstand some things.

The attached Excel 2003 workbook contains data in various cells. That data is accessible through an XML document/table (?) within the workbook. We have the schema. We would like to know if we can use Aspose.Cells to access the data in the XML document/table and extract various elements or attributes.

Does that make more sense?

4

Just want to check in to see if there a verdict on this. Is my question clear?

Let me know.

Thanks,

Theo

5

Thank you for considering Aspose.

Currently Aspose.Cells does not support this functionality. But you can perform following steps to achieve your desired results,

1: DataTable.ReadXML() or DataSet.ReadXML() methods to simply load xml data to a data table or dataset.

2: Use Cells.ImportDataTable() method to import data.

Thank you & Best Regards,