Sqlite Database exporting to Excel

Hello so im a student trying to implement the exporting of data from my SQLite database into an excel sheet in Flutter. I tried using some codes I found online but was not able to integrate successfully. Does anyone have any suggestions?

1 Like

Perhaps you could share what is posing a problem when trying to export the data. Imho you can start with building the CSV file first and reduce entire problem of excel file generation - this feels like it could be a bit of challenge.

I found a solution but have not been able to try it out yet. I’ll update here if it doesnt work

You could also give an update here with your solution if it does work to help others that might have a similar problem.

2 Likes

To export data from SQLite to Excel in Flutter, you can use the sqflite package to handle the SQLite queries and the excel package to create and manipulate the Excel file. You’ll need to fetch the data from the database, then format it into rows and columns, and finally use the excel package to save it as an .xlsx file.