ExcelXml Class

ExcelXml Class

Reads the content from an Excel XML file (SpreadsheetML format).

Inheritance Hierarchy

SystemObject
PDTec.IceNet.Domain.DX.Excel.XmlExcelXml

Namespace: PDTec.IceNet.Domain.DX.Excel.Xml
Assembly: PDTec.IceNet.Domain (in PDTec.IceNet.Domain.dll) Version: 6.0.0.0 (6.0.6225.27214)

Syntax

Copy

public static class ExcelXml

The ExcelXml type exposes the following members.

Methods

	Name	Description
	CleanXml	Applies a XML transformation to an Excel XML document and produces a simplified book/page/row/cell tree.
	GetData	Reads the content from an Excel XML file (SpreadsheetML format).

Top

Examples

This example shows how to read the content of a multi-page Excel XML file and to write it to the console.

Copy

using (Stream s = File.OpenRead("excel.xml"))
{
    using (XmlReader xrExcelXml = XmlReader.Create(s))
    {
        List<ExcelXml.Table> ltBook = ExcelXml.GetData(xrExcelXml);

        foreach (ExcelXml.Table pTable in ltBook)
        {
            Console.WriteLine("### {0} ###", pTable.Name);

            foreach (string[] aRow in pTable.Data)
            {
                Console.WriteLine(CsvWriter.Join(aRow));
            }
        }
    }
}

Reference

PDTec.IceNet.Domain.DX.Excel.Xml Namespace