Internet explorer preserved in excel file name extension XLS, directly to the tip of open, file format and file extensions, before open the file, please confirm that the file is not damaged, and a reliable source, do you want to open the file now?
So every time I deal with these files, it need to open these files one by one click - information - conversion, convert file into XLSX format, and then close the file.
And then use has written a Python program to collect these documents information,

I just wonder whether have what method can make the manual operation of the steps I use Python automation: "manually open the excel click file - information - transformation", thank you!

CodePudding user response:

Try the VBA

Batch conversion should be Excel format

CodePudding user response:

The

reference 1 floor So. Ne response:

try VBA

Batch conversion should be Excel format

Now companies are afraid of macro viruses, dare not to use, so we have to think of some way to in Python

CodePudding user response:

Don't complicate the problem of simple?
You put your EXCEL directly set to compatible mode not line?

Steps:
1. Open the EXCEL
2. Click on the top left corner on the top of the circle, to find "EXCEL options"
3. Then set the diagram below:

CodePudding user response:

The

reference 3 floor paullbm response:

need not complicate the problem of simple?
You put your EXCEL directly set to compatible mode not line?

Steps:
1. Open the EXCEL
2. Click on the top left corner on the top of the circle, to find "EXCEL options"
3. Then set the diagram below:

Only save as in IE browser to download and only XLS format, we finally see the XLS format file, but need to convert format to open XLSX format to use process, with procedures directly hints file error, you said this method above is manual operation, at the moment, I did the same, but the data is too large, do repetitive operation to collapse

CodePudding user response:

Only save as in IE browser to download and only XLS format, we finally see the XLS format file, but need to convert format to open XLSX format to use process, with procedures directly hints file error, you said this method above is manual operation, at the moment, I did the same, but the data is too large, people do repetitive operation collapse

============
I know you save the.xls format, I described above is not to deal with a single file,
But the excel program itself directly to set up a can!

CodePudding user response:

Ok, I'll try in the afternoon

CodePudding user response:

reference 5 floor paullbm reply:

in IE browser to download only save as, and only when the preservation of the.xls format, we finally see the XLS format file, but need to convert format to open XLSX format to use process, direct application process hints file error, you said that the above method is a manual operation, at the moment, I did the same, but the data is too large, people do repetitive operation collapse

============
I know you save the.xls format, I described above is not to deal with a single file,
But the excel program itself directly to set up a can!

Thank you very much for your approach, but useless, don't know you provide the method before you try again?
I really not line, that the way you said this is to excel the default save format into XLS, and our target is all into XLS XLSX,

CodePudding user response:

https://blog.csdn.net/weixin_45903952/article/details/104786048
Can meet your requirements