An automated Excel report merging tool

實作項目：

UI

• Check: confirm the consistency of the header.
• Merge: perform a merge and export the merged file to the output folder.
• Clear: clear original selection.
• Exit: close the window.
• FreeDOS: default is checked, will change the value of “some related column” to N/A if the Col OS is FreeDOS.

Notes

• prompt: fail-safe mechanism prompt
• highlight: modified parts of the Excel cells will turn yellow.

使用之技術：

• Python
• numpy
• pandas
• PySimpleGUI
• pyinstaller