Hi guys…ive been struggling with that simple step into my app for 2 days now and either i am dumb or my english is at fault here but i cant seem to get over this little hurdle.
I use apollo client inside my app which fetch some data from the database and brings me an array of objects.I should be able to convert that array into an excel file to download but each of the solutions ive tried have failed.Using babyparse and filesaver js , i’ve been able to generate and download the file only to find it not formatted like a proper table.so ive tried js-xlsx,and many other meteor related wrappers but each one of them throws either the jszip error or just simply dont work.
the query ran by apollo can fetch up to 5000 or more rows making the app very slow to perform.r
For anyone who came across this kind of issue before, id like to solicitate a little hand here. How can i get from my array of objects a proper excel file ready to be downloaded and properly formatted in rows and columns without the commas showing like a txt file ? If i shouldnt handle it on the client how can i do it using Meteor methods call from the client ?