将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")