- Home /
How to create/update a spreadsheet on android?
Hello people. I want to update/create a spreadsheet (excel) on android. I achieved this on windows with "SpreadSheetLight", but it uses "System.drawing" dll, what only works on windows, so when I build for android that dll not works.
create a CSV not is usefull for me, because I need keep the cell formated/color/etc.
anyone can give me a help with this?, im stucked.
Answer by swanne · Oct 13, 2021 at 01:11 PM
Hi, I might be totally wrong, and please forgive me if I am, but it seems like you are not using the best solution to work with spreadsheets with Android. I recommend using Xamarin. I have used it numerous times to consume, manipulate and export .xlsx docs. There is a lot more support for that kind of stuff via Nuget packages. Unity is more focused on game creation than data and document management.
hey swanne, my app is main focused on 3d models and 2d sprites too. but I need to add this "function" as complement, but is beco$$anonymous$$g a nightmare.
@elfasito I am intrigued. Sounds really interesting. I found these that might be useful: https://unitylist.com/p/28t/Unity-excel-importer https://www.youtube.com/watch?v=sU_Y2g1Nidk https://assetstore.unity.com/packages/tools/integration/uni-excel-47540
I had seen those links, thanks anyways. I solved my problem of create/update xlsx with this library: https://www.nuget.org/packages/EPPlusSharp/
Now im stucked, because I cant read the excel sheet from the Strea$$anonymous$$gAsset folder on android.