I am able to load data from a local JSON file and displays it in a dropdown menu. Then select a value from the dropdown and the application will display the corresponding "Range Array" and "Force Array" from the JSON data. I want to generate a Excel sheet with the data that was selected from the dropdown. The generated Excel would need to look like this:
At this moment i am able to generate a Excel that displays the values but without Chart.
But at this point i think how i am generating the Excel is not the right way.
Because the Excel would need to look like this, so that i could generate a Chart .
Follows the code that i have to read from the local Json and generating the Excel:
import 'package:flutter/material.dart';
import 'package:flutter/services.dart';
import 'package:syncfusion_flutter_xlsio/xlsio.dart' hide Column, Row;
import 'package:syncfusion_officechart/officechart.dart';
import 'package:path_provider/path_provider.dart';
import 'dart:io';
import 'dart:convert';
void main() => runApp(const MyApp());
class MyApp extends StatelessWidget {
const MyApp({super.key});
@override
Widget build(BuildContext context) {
return const MaterialApp(
home: JsonExcelView(),
);
}
}
//***********************************************************************************************
//** class JsonExcelView
//***********************************************************************************************
class JsonExcelView extends StatefulWidget {
const JsonExcelView({super.key});
@override
State<JsonExcelView> createState() => JsonExcelViewState();
}
class JsonExcelViewState extends State<JsonExcelView> {
var data;
late Map<String, dynamic> measure;
var selectedCount;
@override
void initState() {
super.initState();
_loadJsonData();
}
@override
Widget build(BuildContext context) {
return Scaffold(
body: data != null
? Column(
children: <Widget>[
Container(
padding: const EdgeInsets.only(left: 20, right: 20),
child: ElevatedButton(
child: const Text("Create Excel with Chart"),
onPressed: () async {
generateExcellOfficeChart("test");
},
),
),
DropdownButton(
items: (data["measure"] as List<dynamic>)
.map((item) => DropdownMenuItem(
value: item["count"],
child: Text(item["count"].toString()),
))
.toList(),
onChanged: (value) {
setState(() {
selectedCount = value;
});
},
value: selectedCount,
),
Row(
mainAxisAlignment: MainAxisAlignment.center,
children: [
Column(
children: [
const Text("Range Array:"),
Text(data["measure"].firstWhere((item) => item["count"] == selectedCount)["range_array"].map((e) => e.toString()).toList().join('\n'))
],
),
const SizedBox(
width: 30,
),
Column(
children: [
const Text("Force Array:"),
Text(data["measure"].firstWhere((item) => item["count"] == selectedCount)["force_array"].map((e) => e.toString()).toList().join('\n'))
],
),
],
),
],
)
: const Center(
child: CircularProgressIndicator(),
),
);
}
void _loadJsonData() async {
String jsonString = await rootBundle.loadString('assets/data.json');
data = jsonDecode(jsonString);
selectedCount = data["measure"][0]["count"];
setState(() {});
}
void generateExcellOfficeChart(String fileName) async {
// Create a new Workbook
final Workbook workbook = Workbook();
final Worksheet sheet = workbook.worksheets[0];
sheet.showGridlines = true; // Enable-Disable Gridlines
// Setting value in the cell.
sheet.getRangeByName('A1').setText('Range');
sheet.getRangeByName('B1').setText('Force');
//Create an instances of chart collection.
final ChartCollection charts = ChartCollection(sheet);
// Add the chart.
final Chart chart1 = charts.add();
var rangeArray = data["measure"].firstWhere((item) => item["count"] == selectedCount)["range_array"];
var forceArray = data["measure"].firstWhere((item) => item["count"] == selectedCount)["force_array"];
for (var i = 0; i < rangeArray.length; i++) {
sheet.getRangeByName('A${i + 2}').setText(rangeArray[i].toString());
sheet.getRangeByName('B${i + 2}').setText(forceArray[i].toString());
}
// Set Chart Type.
chart1.chartType = ExcelChartType.line;
chart1.dataRange = sheet.getRangeByName('A1:B1');
// set charts to worksheet.
sheet.charts = charts;
// Save the workbook to a file
final List<int> bytes = workbook.saveAsStream();
workbook.dispose();
await saveAndLaunchFile(bytes, '$fileName.xlsx');
}
}
//***********************************************************************************************
//** void saveAndLaunchFile
//***********************************************************************************************
Future<void> saveAndLaunchFile(List<int> bytes, String fileName) async {
String? path;
final Directory directory = await getApplicationDocumentsDirectory();
path = directory.path;
final File file = File(Platform.isWindows ? '$path\\$fileName' : '$path/$fileName');
await file.writeAsBytes(bytes, flush: true);
await Process.run('start', <String>['$path\\$fileName'], runInShell: true);
}
