Python extract table data from Microsoft One Note (O365)

Job ID: 35682887

Budget: $30 – $250 USD

I use Microsoft's OneNote (O365 version) to document all aspects of my Python development. When I need to change the database definition, I want to make the change in One Note; export to a file using Python; transform the file into data definition language (DDL); then execute. I always know my documentation is accurate, because the OneNote documentation builds the tables!

Note, all my tables are defined in their own, separate OneNote page, as shown below. Also note that every OneNote page is formatted the same, as shown below. Here is my task:
• Python reads a OneNote page. The screen shot below shows OneNote page tblPOHdr containing the DDL.
• Python parses the table, extracting the rows and fields into a list.
• I will take further programming from this point, when I have the list.
Related categories: Python Microsoft Office