如何在C＃代码中设置Excel文件中的列格式

I have a protected standard template excel sheet with formulas that I am loading SQL data to Excel through SSIS. While loading all int columns are convert to text format in an excel. Because of that formulas is not working until I double click each cell. I have a protected standard template excel shee