I am using unix solaris and I have one requirement.
copy separate files ("*.csv") to one excel file(xlsx) with multiple sheets.
These "*.csv" files are my source files (NLS.ML.csv , NLS.MW.csv , FEP.ML.csv and FEP.MW.csv) my output file is "Template prefix.xls" with 8 sheets. for more details kindly refer to the below picture. about the sheets on red: Predefined sheet contain some formula to collect date from previous sheet
thanks and Regards