How I Create Excel Workbook from Uint8list or File ?

[berkbb]

Hi,

I got the Excel file from file-picker as Uint8list, and convert to it File now:

FilePickerResult result = await FilePicker.platform.pickFiles( type: FileType.custom, allowedExtensions: ['xlsx'], );

 if (result != null) 

{ var file = File.fromRawPath(result.files.single.bytes);

}

How I convert it to a workbook (fromUint8list or File)  for reading data from sheet 0 ? Thanks.

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Berk, 

Currently, we don't have support to read Excel using Flutter XlsIO library. 

However, you can create Excel files using "syncfusion_flutter_xlsio" library with the following features. 

• Create a simple Excel document
• Add text, number, and datetime values
• Add formulas
• Apply formatting
• Add images
• Add charts
• Add hyperlinks to texts and images
• Protect workbooks and worksheets
• AutoFit rows and columns
• Insert or delete rows and columns
• Apply conditional formatting

 

To know more about the "syncfusion_flutter_xlsio" library please refer the following link. 

https://pub.dev/packages/syncfusion_flutter_xlsio 

 

Regards,
Keerthi.