Kindly help me to resolve this issue.
Can you share your xmal please. if you don’t mind.
Thank you for your reply , Forum is not letting me to upload the attachment, Can I mail you ?
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.
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.
Yes it is installed , kindly find the screenshot.
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)
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.
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.
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)
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.
You can simply use this in Assign activity.
Okay Sure, I will try and confirm you.
Thank you very much for your help.