Hi Mullin,

Thanks for your suggestion. I've given the sample data for department wise but I want to read only the required columns from the excel file based on the input parameter (month). It will not be consistent as there are chances that month data will not be available.

I need only the first 5 columns from the excel if the input parameter value is Jan.

Here is the actual file,

Sum of Jan Balance Sum of Feb Balance Sum of Mar Balance
Col1 Col2 Col3 Incoming Outgoing Incoming Outgoing Incoming Outgoing
1022 1123357 Test1 9,169.49 0.00 9,370.47 0.00 9,370.47 0.00
1022 11234341 Test2 1.14 0.00 0.49 0.00 0.49 0.00

Thanks,
ArSample_data.jpg