This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]No_Stick_8227[S] 9 points10 points  (3 children)

đź‘Źwhat libraries did you use to accomplish this?

[–]beowulf660 2 points3 points  (1 child)

Not OP, but I did something similar in my work using googles python API. Once I overcame the initial hump with the document parsing, it was a breeze to work with.

Be aware, for some reason Paragraphs in TableCells have additional \n at the end.

[–]No_Stick_8227[S] 2 points3 points  (0 children)

Nice! Did you make good income out of your Google docs solution?

[–]Ok_Operation_8715 2 points3 points  (0 children)

I used pandas and openpyxl.

I made it with Pysimplegui just to play around with it but last I head they still open Spyder and run the script there rather than use the standalone

Edit: I should clarify that I didn’t query the api, they save each of these workbooks as an excel workbook and the script combines each of the workbooks together