将CSV转换为JSON
Contents
[
Hide
]
将CSV转换为JSON
Aspose.Cells for Python via .NET 支持将 CSV 转换为 JSON。为此，API 提供了 ExportRangeToJsonOptions 和 JsonUtility 类。ExportRangeToJsonOptions 类提供了导出范围到 JSON 的选项。ExportRangeToJsonOptions 类具有以下属性。
- export_as_string：导出单元格的字符串值给JSON。
- has_header_row：指示范围是否包含标题行。
- indent：表示缩进。
JsonUtility类使用与ExportRangeToJsonOptions类设置的导出选项导出JSON。
以下代码示例演示了使用 ExportRangeToJsonOptions 和 JsonUtility 类加载 源 CSV 文件 并在控制台打印 JSON 输出。
示例代码
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 | |
| from aspose.cells.utility import ExportRangeToJsonOptions, JsonUtility | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # Source directory | |
| sourceDir = RunExamples.Get_SourceDirectory() | |
| # Load CSV file | |
| workbook = Workbook(sourceDir + "SampleCsv.csv") | |
| lastCell = workbook.worksheets[0].cells.last_cell | |
| # Set ExportRangeToJsonOptions | |
| options = ExportRangeToJsonOptions() | |
| range = workbook.worksheets[0].cells.create_range(0, 0, lastCell.row + 1, lastCell.column + 1) | |
| data = JsonUtility.export_range_to_json(range, options) | |
| # Print JSON | |
| print(data) |
控制台输出
[
{
"id": 1,
"language": "Java",
"edition": "third",
"author": "Herbert Schildt",
"streetAddress": 126,
"city": "San Jone",
"state": "CA",
"postalCode": 394221
},
{
"id": 2,
"language": "C++",
"edition": "second",
"author": "EAAAA",
"streetAddress": 126,
"city": "San Jone",
"state": "CA",
"postalCode": 394221
},
{
"id": 3,
"language": ".Net",
"edition": "second",
"author": "E.Balagurusamy",
"streetAddress": 126,
"city": "San Jone",
"state": "CA",
"postalCode": 394221
}
]