Scenario: Read the file and store it in data table, next take total count of rows and divide it by a number which is configurable (3,4,5,6,7…).
Next based on divided value obtained it has create multiple excel files
Eg: If total count is 31 and in config file the no provided is 5,so it has to create 5 files with count of rows in excels files as 6+6+6+6+7
Similarly if total count is 30 and in config file the no provided is 3,it has to create 3 files with count of rows in excel files as 10+10+10.
Please can of you help me out on this.