Narigo
Recommendations for interacting with Excel sheets (.xlsx) and GraphQL?
I managed to get SheetJS to run with Deno and I think I'm going to use that for now. The Danfo.js looks like it's tailored more to calculations on the values where I'm going to need to work with strings mostly and getting those streamlined
5 replies
Recommendations for interacting with Excel sheets (.xlsx) and GraphQL?
I want to parse the Excel data into a PostgreSQL database with the script. I do need to process the data a bit, though: Remove some columns, streamline cell values, etc. before putting it into the database. The devs who are going to maintain this shouldn't need to work with different language contexts, so the language is basically set to TypeScript.
Since the database is going to have a GraphQL frontend through Hasura, I wanted to check whether I can use that frontend to update the database itself. As I mentioned, I tried getting Prisma to run to work with the database directly, but that didn't work out too well and I'd like to have something that works with some type safety instead of writing raw SQL statements
5 replies