Hi every one.I have a customer who wants me to build a webapp that will help him manage his customers.The thing is all his data are stored in excel tables and as i have never written something to deal with this kind of problem im a lil bit lost…Here is my mental plan for this app…know that i could be wrong and i am counting on you guys to guide me pls :
-import the excel files in a Mongo collection
-use the newly inserted lines in the collection to get all the meteor features out of the box
-once the different operations are done,export parts or all the collection into a new excel file
that is basically it.If you know a way for me to do it right please show me…Thanks a lot
I actually have built a web app that is very similar to what you are trying to build.
I use Papa Parse to parse the Excel file data (without actually physically uploading the file), then transfer the data to a MongoDB collection. I believe that each line of the Excel sheet becomes an object with the colums being the keys to the object like {column1: "value", column2: "value", column3: "value"};
Then I manipulate the data however I want to afterwards in a reactive way using mostly Session variables. This manipulated data can be inserted into tables and downloaded by the customer via Excel or CSV.
thank you sprolee…ill look into that…so you are basically telling me that with Papa Parse i can achieve my goal without having to upload the excel file…Wow ill try to build a demo over the weekend and present it to my client…thanks
Hey pal thanks for saving me again on that one …you are incredible.ill use both your advices (converting to csv before using /using papa parse).But definitely as the client is a big insurance firm in my country i am mostly sure they have large datasets…