excel
excel copied to clipboard
Bug reading SpannedItems as empty
There are several merged cells in my Excel file, but it reads as empty。 Version: excel: ^4.0.3
Sample excel file : testMerge.xlsx
Code:
var bytes = File(file).readAsBytesSync();
var excel = Excel.decodeBytes(bytes);
for (var table in excel.tables.keys) {
Sheet? sheet = excel.tables[table];
if(sheet == null){
continue;
}
List<String> spannedCells = sheet.spannedItems;
print(" merge info :$spannedCells"); //!!! print : []
}
PR https://github.com/justkawal/excel/pull/343 will fix this error.
I see that the code in the repository has fixed this issue, but a new version of the plugin has not been released yet. Can you update the plugin? thanks