حوّل JSON إلى CSV
حوّل JSON إلى CSV
يدعم Aspose.Cells التحويل البسيط والمتداخل من JSON إلى CSV. لهذا الغرض ، يوفر API**[JsonLayoutOptions] (https://reference.aspose.com/cells/net/aspose.cells.utility/jsonlayoutoptions)** و**[JsonUtility] (https://reference.aspose.com/cells/net/aspose.cells.utility/jsonutility)** الطبقات. ال**[JsonLayoutOptions] (https://reference.aspose.com/cells/net/aspose.cells.utility/jsonlayoutoptions)**توفر class خيارات تخطيط JSON مثل**[IgnoreArrayTitle] (https://reference.aspose.com/cells/net/aspose.cells.utility/jsonlayoutoptions/properties/ignorearraytitle)**(يتجاهل العنوان إذا كانت المصفوفة خاصية لكائن) أو**[ArrayAsTable] (https://reference.aspose.com/cells/net/aspose.cells.utility/jsonlayoutoptions/properties/arrayastable)**(يعالج المصفوفة كجدول). ال**[JsonUtility] (https://reference.aspose.com/cells/net/aspose.cells.utility/jsonutility)**يقوم class بمعالجة JSON باستخدام خيارات التخطيط التي تم ضبطها باستخدام**[JsonLayoutOptions] (https://reference.aspose.com/cells/net/aspose.cells.utility/jsonlayoutoptions)**صف دراسي.
يوضح نموذج التعليمات البرمجية التالي استخدام**[JsonLayoutOptions] (https://reference.aspose.com/cells/net/aspose.cells.utility/jsonlayoutoptions)**و**[JsonUtility] (https://reference.aspose.com/cells/net/aspose.cells.utility/jsonutility)** فئات لتحميلالمصدر JSON ملف ويولد الملف الإخراج CSV.
عينة من الرموز
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
//Source directory | |
string sourceDir = RunExamples.Get_SourceDirectory(); | |
//Output directory | |
string outputDir = RunExamples.Get_OutputDirectory(); | |
// Read JSON file | |
string str = File.ReadAllText(sourceDir + "SampleJson.json"); | |
// Create empty workbook | |
Workbook workbook = new Workbook(); | |
// Get Cells | |
Cells cells = workbook.Worksheets[0].Cells; | |
// Set JsonLayoutOptions | |
JsonLayoutOptions importOptions = new JsonLayoutOptions(); | |
importOptions.ConvertNumericOrDate = true; | |
importOptions.ArrayAsTable = true; | |
importOptions.IgnoreTitle = true; | |
JsonUtility.ImportData(str, cells, 0, 0, importOptions); | |
// Save Workbook | |
workbook.Save(outputDir + @"SampleJson_out.csv"); |