Before starting, you may need to prepare:
- A PC running Windows 7 or a newer version
- A good compression software
Sample question settings for the collection form used in this practice
After waiting for classmates to upload the collection form, export the collection results to Tencent document spreadsheet. Click the "View in Spreadsheet" button next to "Collection Results"
In the newly opened tab, click the menu [Export As]—>[Local Excel Spreadsheet and Attachments (.zip)], to export the collection results compressed package containing attachments
Unzip the downloaded compressed package, the contents are as follows
Next, use Easy Language to write a batch processing program, the following is sample code, the complete source code can be downloaded at the end of the article
Open the program generated after compilation. This program can be downloaded at the end of the article.
Fill in the relevant settings.
- [Attachment Directory] Please select the directory that contains the collected result attachments, such as C:\Users\zhouminghao\Desktop\image\
- [Attachment Prefix Identifier] Characters before the name in the file name, such as two codes one report screenshot (non-Yu nationality)-*-Question 2- 【Note】 Text that will change with the file should be replaced with *
- [Attachment Suffix Identifier] Characters after the name in the file name, such as -
After filling in the settings, it should look like this:
Click the "Create Separate Directory for Them Now" button, the program will automatically place the attachments uploaded by each classmate in a folder named after their name under the result directory
At this point, you have successfully and elegantly exported the Tencent document collection form attachments.
The attachments involved in this article can be downloaded here:
(As of April 6, 2022, the supporting tools have been adapted to the 2022 new version of Tencent documents and are open source)