Hi, I have an app where I need to be able to upload an excel document and only read/get certain rows and have them behave like a JSON so that I can parse it and paste each cell into a new row. The issue is I know how to do it if the “progress” was vertical but the table is horizontal so I dont know how to take the rows I need and iterate them for my use. Would anyone know of something to be done either with Glide, Make o Zappier that could be of use?
I have tried using both but the format with which the clients has to upload said document makes it incredibly hard to be able to get all the data correctly
Is it possible for them to upload as CSV instead?
It is but I’ve tried xlsx, csv and pdf format and still the format used in the document makes it almost impossible to read, because it reads row by row, so if I want to explain which row I need it is very very difficult to say from which column to start