Workbook.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

• class Workbook
• namespace Aspose.Cells
• assembly Aspose.Cells

---

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

• class Workbook
• namespace Aspose.Cells
• assembly Aspose.Cells