excel
excel copied to clipboard
Lost style after save.
v2.1.0
import 'dart:io';
import 'package:excel/excel.dart';
void main() async {
var bytes = File('${Directory.current.path}/before.xlsx').readAsBytesSync();
var excel = Excel.decodeBytes(bytes);
var tableName = excel.getDefaultSheet();
var table = excel.tables[tableName];
table!.row(0)[3]!.value = 'abc';
var fileBytes = excel.save();
File('${Directory.current.path}/after.xlsx').writeAsBytesSync(fileBytes!);
}
I just change text and save.
Lost allcolumn width
and some cell style
and few cell type
(not show in this case)
I'm facing the same issue
I'm facing the same issue
Did u found solution to fix this?
I'm facing the same issue
Did u found solution to fix this?
In this issue the usage of Firebase Functions with Python was suggested.
As my application is very simple, I ended up using Python for the whole app. The UI was built with Flet (a Python package to build Flutter apps) and the Excel file was manipulated with the package openpyxl
Confirmed by #277. The ColumnWidth doesnt get parsed in the first place.