Hi Team,
I have 30 excel files , in which each excel consists of one row and 3 columns(with column names as SNO , Pending, Completed, To be processed) and there is only one row of data (like 1(SNO) ,389(pending),203(completed)900(to be processed),.. My requirement is to open all the 30 files and get the data into a single collection(need to open first file get into collection, open second file get data into collection,....)
Could anyone help me in this
Regards
Subhash
I have 30 excel files , in which each excel consists of one row and 3 columns(with column names as SNO , Pending, Completed, To be processed) and there is only one row of data (like 1(SNO) ,389(pending),203(completed)900(to be processed),.. My requirement is to open all the 30 files and get the data into a single collection(need to open first file get into collection, open second file get data into collection,....)
Could anyone help me in this
Regards
Subhash