将单元格链接到 XML 地图元素
Contents
[
Hide
]
可能的使用场景
你可以使用 Aspose.Cells for Python via .NET 将单元格连接到 XML 映射元素。请使用 Cells.link_to_xml_map() 方法实现此目的。
将单元格链接到 XML 地图元素
以下示例代码加载了包含 XML 地图的 源 Excel 文件，然后将单元格 A1、B2、C3、D4、E5 和 F6 链接到 XML 地图元素 FIELD1、FIELD2、FIELD4、FIELD5、FIELD7 和 FIELD8，然后将工作簿保存在 输出 Excel 文件 中。
如果您打开 输出 Excel 文件 并单击“开发人员 > 源”按钮，您将看到单元格已链接到 XML 地图元素，并且它们也将被 Microsoft Excel 标记，如下图所示。
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import Workbook | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # The path to the documents directory. | |
| dataDir = RunExamples.GetDataDir(".") | |
| # Load sample workbook | |
| wb = Workbook(dataDir + "sample.xlsx") | |
| # Access the Xml Map inside it | |
| map = wb.worksheets.xml_maps[0] | |
| # Access first worksheet | |
| ws = wb.worksheets[0] | |
| # Map FIELD1 and FIELD2 to cell A1 and B2 | |
| ws.cells.link_to_xml_map(map.name, 0, 0, "/root/row/FIELD1") | |
| ws.cells.link_to_xml_map(map.name, 1, 1, "/root/row/FIELD2") | |
| # Map FIELD4 and FIELD5 to cell C3 and D4 | |
| ws.cells.link_to_xml_map(map.name, 2, 2, "/root/row/FIELD4") | |
| ws.cells.link_to_xml_map(map.name, 3, 3, "/root/row/FIELD5") | |
| # Map FIELD7 and FIELD8 to cell E5 and F6 | |
| ws.cells.link_to_xml_map(map.name, 4, 4, "/root/row/FIELD7") | |
| ws.cells.link_to_xml_map(map.name, 5, 5, "/root/row/FIELD8") | |
| # Save the workbook in xlsx format | |
| wb.save(dataDir + "output.xlsx") |