Hi
I am attempting to add multiple Excel sheets to one collection in order to combine the data contained in each sheet. Is it possible to loop through multiple excel sheets and add the chunks of data into a collection without overwriting each time? I am looping through each sheet in turn and trying to add the data to the same collection but each time i attempt it the data gets overwritten.
Thanks
I am attempting to add multiple Excel sheets to one collection in order to combine the data contained in each sheet. Is it possible to loop through multiple excel sheets and add the chunks of data into a collection without overwriting each time? I am looping through each sheet in turn and trying to add the data to the same collection but each time i attempt it the data gets overwritten.
Thanks