Excel Filter Issue

Learn Academy Feedback
1

Dear All,
Kindly help me to resolve this issue.

image
image721×250 11.7 KB

Regards,
VS01

2

Hi @Santhoshi_Gvs,

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

Regards
Balamurugan.s

3

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

Regards,
Santhoshi GV

4

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.

5

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

6

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

Regards,
Santhoshi

Capture GV

7

excel_invoke.xaml (22.3 KB)

8

@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…

9

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

10

@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.

11

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

12

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

13

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

image.png
image.png508×534 30 KB

14

Hello,

You can simply use this in Assign activity.

=

Thanks,
Meg

15

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

Regards,
Santhoshi