'Generate excel (.xlsx) for categorization of database/content
Problem: I have a folder name 'XYZ' (saved at D:\PQRS\2022), which comprises two more folders named 'January' and 'March'. Folder 'January' comprises multiple types of files. It also comprises three office (.doc or .docx) files. Each file comprises text 'message type : ', for example file 1 contains 'message type: Apple', file 2 contains 'message type: Banana' and file 3 contains 'message type: Apple'. The folder named 'March' has 2 files. File 1 comprises 'message type: Banana' and file 2 contains 'message type: '.
I want to generate an excel file named 'XYZ'which comprises the following information
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|