将JSON转换为Excel
将JSON转换为Excel工作簿
无需担心如何将 JSON 转换为 Excel 文件,因为 Aspose.Cells for Python via .NET 库提供了最佳解决方案。Aspose.Cells for Python via .NET API 支持将 JSON 格式转换为电子表格。您可以使用 JsonLoadOptions 类指定导入 JSON 到 Workbook 的附加设置。
以下代码示例演示了将JSON导入到Excel工作簿。请参阅用于参考的代码将源文件转换为由代码生成的xlsx文件。
from aspose.cells import Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# create a Workbook object | |
wb = Workbook("sample.json") | |
# save file to xlsx format | |
wb.save("sample_out.xlsx") |
以下使用JsonLoadOptions类指定附加设置的示例代码演示了将JSON导入到Excel工作簿。请参阅用于参考的代码将源文件转换为由代码生成的xlsx文件。
from aspose.cells import JsonLoadOptions, Workbook | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
# Create an options of loading the file. | |
options = JsonLoadOptions() | |
# Indicates whether importing each attribute of JsonObject object as one worksheet when all child nodes are array nodes. | |
options.multiple_worksheets = True | |
book = Workbook("sample.json", options) | |
# save file to xlsx format | |
book.save("sample_out.xlsx") |
以下代码示例演示了将JSON字符串导入到Excel工作簿。您还可以在导入JSON时指定布局的位置。请参阅用于参考的代码将JSON字符串转换为由代码生成的xlsx文件。
from aspose.cells import Workbook | |
from aspose.cells.utility import JsonLayoutOptions, JsonUtility | |
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
inputJson = r"[ | |
{ BEFORE: 'before cell', TEST: 'asd1', AFTER: 'after cell' }, | |
{ BEFORE: 'before cell', TEST: 'asd2', AFTER: 'after cell' }, | |
{ BEFORE: 'before cell', TEST: 'asd3', AFTER: 'after cell' }, | |
{ BEFORE: 'before cell', TEST: 'asd4', AFTER: 'after cell' } | |
]" | |
sheetName = "Sheet1" | |
row = 3 | |
column = 2 | |
# create a Workbook object | |
book = Workbook() | |
worksheet = book.worksheets.get(sheetName) | |
# set JsonLayoutOptions to treat Arrays as Table | |
jsonLayoutOptions = JsonLayoutOptions() | |
jsonLayoutOptions.array_as_table = True | |
JsonUtility.import_data(inputJson, worksheet.cells, row, column, jsonLayoutOptions) | |
# save file to xlsx format | |
book.save("out.xlsx") |