I want to copy selected columns in Microsoft Excel using its column number but it does not work.
This line of code in the right side of Assign Activity shows error: output.DefaultView.ToTable(false, {6})
What can I do to solve this?
Below is the updated workflow for the same
CopyPratik.xaml (7.9 KB)
Output :-
Mark as solution and like it 
Happy Automation 
Best Regards
Er Pratik Wavhal 
Sir @Pratik_Wavhal, sorry for the late reply. I try to execute it but the last row was not copied.
I have updated the flow now. Just one change was required.
CopyPratik.xaml (8.6 KB)
excel.xlsx (9.9 KB)
Output :-
Hi @ROBERT_RUSSELL_MONSA Mark as solution and like it if this helps you
Happy Automation
Best Regards
Er Pratik Wavhal
Thank you so much Sir @Pratik_Wavhal.
Although my question has already been answered, I just want to ask why is it necessary to put “+1” in the script to include the last row in copying?
Bcz rowCount it the count which starts Initially from 0
Happy Automation
Best Regards
Er Pratik Wavhal
Good Day, Ms. @Krishna_C. Sorry for the late reply. Please try to use the both .xaml file that I will send. Kindly see the attached file. Thank you.
Automatic change of year.xaml (6.5 KB) New Microsoft Excel Worksheet.xlsx (10.3 KB) User Input change of year.xaml (7.0 KB)
Best regards,
Robert Monsalud
Thank you, Sir.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
