Excel Filter Issue

Dear All,
Kindly help me to resolve this issue.

Regards,
VS01

Hi @Santhoshi_Gvs,

Can you share your xmal please. if you don’t mind.

Regards
Balamurugan.s

Hello Sir,
Thank you for your reply , Forum is not letting me to upload the attachment, Can I mail you ?

Regards,
Santhoshi GV

Hi @Santhoshi_Gvs,

The exception states that, it is interrupted by something while processing the excel.
Or double check whether the excel is running background or the sheet names or path is incorrect.

Hello,

Is MS office is installed and activated?

if not use the workbook activities for that you can use the same excel activities without installing excel.

Thanks,
Meg

Hello Sir,
Yes it is installed , kindly find the screenshot.

Regards,
Santhoshi

Capture GV

excel_invoke.xaml (22.3 KB)

@Santhoshi_Gvs,

I did some changes in your workflow. Please find the sameexcel_invoke.xaml (13.5 KB)
New Microsoft Excel Worksheet.xlsx (9.9 KB)

Regards,
Lakshman Ganta…

Hello Lakshman,
Thank you so much for the effort you made in helping me. I am getting same error message even after I replaces the excel sheet.

may this be because of MS office issue ? I am not getting , everything seems fine at built level.

Regards,
Santhoshi GV

@Santhoshi_Gvs,

Do one thing. Could you please replace Read range and Write range activities with Workbook Read Range and Write Range and then try. Please let me know once it done.

image

Regards,
Lakshman Ganta.

Hello Lashman,
Yes It works, But not working with filer Data table option. I am trying as below.
I am getting wrong output , kindly suggest . Thank you in advance.

survey_NEW.xaml (24.0 KB)

  1. Only Resolved ==> Successful tickets
  2. Type NOT EQUAL != Service Bulletins
  3. Casetype NOT EQUAL To != Problem
  4. All requester login ids ==> must be UNIQUE
  5. Remove special character ==> () from all cloumts , If any.

Regards,
Santhoshi

Hello, you can use the LINQ for filtering the datatable,

DT = DT.AsEnumerable.Where(Function(row) row(“A”).ToString = VALUE ).CopyToDataTable’

you can put multiple conditions by joining each with OR or AND based on business rules.

Thanks,
Meg

Thank you for your reply. Which
LINQ , I need to use ?

Hello,

You can simply use this in Assign activity.

=

Thanks,
Meg

Okay Sure, I will try and confirm you.
Thank you very much for your help.

Regards,
Santhoshi