i try to do a process related to filter data table.i run the process with a sample excel its working properly when i change the excel(BULK DATA) it only some header but it contain 53 headers. and data under the header also not reading.
Main.xaml (9.9 KB)
this is the code
This is some part of the excel(BULK DATA).
Does anyone have the solution for this.
Can you tell us the exact issue you are facing ? and the output wanted.
There is a column named "Approval date " we have to compare that date with the current date. if the date matches then read the entire row.(there are around 53 columns)
Issue:- I have used filter data table for this but the date is not filtering as per the condition. when i try read this excel and write it in a another excel the date format is changing.
This sounds like an Excel-related issue.
A workaround is to write it to an Excel file where all cells are formatted as Text.
I can’t help much more without a dummy version of your Excel file.
How about this expression
Use Assign Activity
Dtfilter → Variable Type DataTable
DtFilter = DtreadFull.AsEnumerable.Where(Function(r) currentrow("Approval date").Tostring=DateTime.Now.ToString("MM-yyyy")).CopyToDataTable
DateTime.Now.ToString(“MM-yyyy”) → Date Format is based on the excel format