I and my friends are working on a personal project. It’s kind of a quiz app and we have all the required data for the application in pdf format. And the pdf has some maths formulas and physics formulas in it. We somehow have to store it in the cloud Firestore(Firebase).
So we thought of transforming the pdf data into Excel(manually) and writing a script to store it in Firestore. But if we copy any of those formulas and paste them into Excel, it shows some weird characters and some misalignment instead of the exact formulas.
We are blocked by this issue for the past 2 weeks and we couldn’t find any solution yet.
So I’m wondering if is there any way we can copy those formulas as it is. And if there are any better ways to extract data from pdf and store it in Firestore, please guide me.
2
Answers
have you tried power query, get data from file>from pdf and then transform it?
Transform into LaTex, then into Excel or Javascript formulas