Dear All,
Kindly help me to resolve this issue.
Regards,
VS01
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
GV
excel_invoke.xaml (22.3 KB)
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
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.
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)
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
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