import_xml method
Contents
[
Hide
]import_xml
Imports/Updates an XML data file into the workbook.
def import_xml(self, url, sheet_name, row, col):
...
Parameter | Type | Description |
---|---|---|
url | str | the url/path of the xml file. |
sheet_name | str | the destination sheet name. |
row | int | the destination row |
col | int | the 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):
...
Parameter | Type | Description |
---|---|---|
stream | io.RawIOBase | the xml file stream. |
sheet_name | str | the destination sheet name. |
row | int | the destination row. |
col | int | the destination column. |
See Also
- module
aspose.cells
- class
Workbook