Bank Reconciliation Excel Separation

I want to separate a bank statement excel file into several parts as Fund Purchase, Debit, Credit, etc. with the logical condition. What is the easiest way to do the operation?

Use Linq quires on the datatable and write into the related sheets , which is faster and best way to deal with large volume of data.

Sample quires

Data_table.AsEnumerable().Where(Function(row) row(“Document Status”).ToString=“OK”).CopyToDataTable()

dt_input.AsEnumerable().Where(Function(row) row(“ColumnName”).ToString.ToUpper=“text_filter_value”).CopyToDataTable()

dt_input.AsEnumerable().Where(Function(row) row(“ColumnName”).ToString.ToUpper=“Text_Folter_Value” and Convert.ToInt32(row(“Column_name”))>10000).CopyToDataTable()

dt_input.AsEnumerable().Where(Function(row) row(“Ref3”).ToString.StartsWith(“P”)).CopyToDataTable()

Few related links .


1 Like

thank you