生成新的Excel，同时保留模板Excel文件中的旧公式

I have an Excel template with first 5 columns left blank (to be populated from an XML). The sixth column has a drop-down list such that depending on whatever value is selected from the list, a value appears in 7th column. This is done by using INDEX-MATCH formula for the 7th column. I have an Excel template with first 5 columns l