He had written in js a batch replacement tool, please have a look, use XLSX - style, XLSX - style cannot output formula and the excel image

For example, I have the following multiple Excel files, each file to the following replacement:




Tools to address: www.excelfb.com, click on the page: multiple Excel files batch replacement, (this does not need to know about vba, Excel formulas or other complex operation, also do not need to install)

1, create a new Excel file, production batch replacement rules file is as follows:

2, the choice to replace the file, choose to make good batch replacement rules file
3, if do not need to specify all range, if the fixed column replaced, input Excel column number
4, click "replace - generating new files," waiting for download replace the complete files (for Google browser: very convenient to download more files; Firefox: to save one by one point)
5, download the files in general computer - & gt; Download directory

CodePudding user response:

It is good to write about in PY directly