Excel Automation with Specific conditions

Can anyone help me to design workflow.
Problem Statement–
Read the Excel sheet, check if Amount Spend >= Amount Allotted, if true then customer is not eligible for any further purchases, hence send an email with such type of customer info to ‘XXXXXX@mail.com’ with the exact status. If the above is not true than those customers are eligible for further purchase, hence list down those customers data into different sheet and send that sheet in email to ‘XXXXXX@mail.com’. Also the customers with Customer Class field as empty will not be considered for any further calculation, so you can simply ignore those types of customer.

Thanks in Advance…ExcelAutomation1.xlsx (9.7 KB)

Try below expression

varDT.AsEnumerable.Where(function(r) cdbl(r("Amount_Spend").ToString)>=cdbl(r("Amount_Alloted").ToString)).CopyToDataTable

It will give you the required data into datatable. You just need to use for each row and write range inside it.


Attached sample workflow.
Excel.xaml (7.1 KB)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.