I want to read and write excel by using template excel as below.
In file input have 11 column follow by config.
I want write file output 2 sheet (Report,Detail)
Sheet report and Sheet Detail : I want delete row that dup Name by keep only max amount (in same Name)
Sheet Report : I want write 3 column.
By use column from file input (In_ColName , In_IssueDate , In_Paid)
Sheet Detail : I want write 5 column.
By use column from file input (In_ColName , In_ColNickname , In_Amount , In_IssueDate , In_Amount)
File as attached :
output.xlsx (9.6 KB)
Remark : in future, It have change name, add new rows in file config, But I want to.change in code.