Convert excelfiles to docx by python script

1. dump your mysql database by sql command

open sql file paste the content in the navicatformyssql, then export the filtered contents to xlsx format

2. Convert excel

using vs studio run the python script, convert it to md.

3. Convert md

open cmd, navigate the target location of your excel files, run:

1
pandoc xxx.md -o yyy.docx