I have scenario wherein i need to read 3 excel files from input folder
Input Folder- AM.xlsx,GM.xlsx,FGM.xlsx
And there is template folder it contains VarianceTemplate.xlsx( template consist of three input sheets(AM,GM & FGM) and their pivot sheets respectively.
Ouput Folder - Should Contain VarianceAnalysis 0121.xlsx , It should contain All the AM,GM,FGM & their respective Pivot Sheets
Though I am able to read all the three input files and write that to ouput file, But in the Output File contains AM,GM sheet values are null but FGM Sheet values are Present.
Note: I Am Reading&Writting Input Files with “Add Headers” Unchecked.