import_xml method

import_xml

Imports/Updates an XML data file into the workbook.

def import_xml(self, url, sheet_name, row, col):
    ...
ParameterTypeDescription
urlstrthe url/path of the xml file.
sheet_namestrthe destination sheet name.
rowintthe destination row
colintthe destination column

Example

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

from aspose.cells import Workbook

wb = Workbook("Book1.xlsx")
wb.import_xml("xml.xml", "Sheet1", 0, 0)
wb.save("output.xlsx")

import_xml

Imports/Updates an XML data file into the workbook.

def import_xml(self, stream, sheet_name, row, col):
    ...
ParameterTypeDescription
streamio.RawIOBasethe xml file stream.
sheet_namestrthe destination sheet name.
rowintthe destination row.
colintthe destination column.

See Also