I am working on a development that have to filter multiple sheets and tables in an individual excel to create multiple excel outputs. The current solution is to create multiple datatables for each tables and filter them into the new output.
This method is quite time consuming in both development and maintenance. I heard that Dictionary can replace the datatables in a more efficient way? Any ideas ?
Thank you very much !
Dictionary is only to contain key/value pairs and is NOT recommended for importing the data from Excel.
Data table is the right choice for the excel data manipulations. May be you can make use of LINQ queries (assign activities) for the faster processing or use parallel activity if the processing steps are independent of each other.
Like in parallel activity, block 1 process the data1
block 2 process the data 2 (independent of the block 1)