ImportXml

ImportXml(string, string, int, int)

Imports/Updates an XML data file into the workbook.

public void ImportXml(string url, string sheetName, int row, int col)
Parameter Type Description
url String the url/path of the xml file.
sheetName String the destination sheet name.
row Int32 the destination row
col Int32 the destination column

Examples

The following code imports xml data into worksheet ‘Sheet 1’ at Cell A1.

Workbook wb = new Workbook("Book1.xlsx");

wb.ImportXml("xml.xml", "Sheet1", 0, 0);

wb.Save("output.xlsx");

See Also


ImportXml(Stream, string, int, int)

Imports/Updates an XML data file into the workbook.

public void ImportXml(Stream stream, string sheetName, int row, int col)
Parameter Type Description
stream Stream the xml file stream.
sheetName String the destination sheet name.
row Int32 the destination row.
col Int32 the destination column.

See Also