Copying of selected column in Microsoft Excel using its column number

Help Studio
, ,
1

I want to copy selected columns in Microsoft Excel using its column number but it does not work.

image
image591×644 17.2 KB

excel.xlsx (9.9 KB) Copy.xaml (6.6 KB)

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?

2

Hi @ROBERT_RUSSELL_MONSA

Please have a look at this post.

regards,
Krishna

1 Like
3

Hi @ROBERT_RUSSELL_MONSA

Below is the updated workflow for the same
CopyPratik.xaml (7.9 KB)
image

Output :-

image
image944×475 9.33 KB

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

2 Likes
4

Sir @Pratik_Wavhal, sorry for the late reply. I try to execute it but the last row was not copied.

5

Hi @ROBERT_RUSSELL_MONSA

I have updated the flow now. Just one change was required.
CopyPratik.xaml (8.6 KB)
excel.xlsx (9.9 KB)

Output :-

image
image915×423 8.87 KB

Hi @ROBERT_RUSSELL_MONSA Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like
6

Thank you so much Sir @Pratik_Wavhal.

7

Hi @ROBERT_RUSSELL_MONSA

You are welcome :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like
8

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?

image

9

Hi @ROBERT_RUSSELL_MONSA

Bcz rowCount it the count which starts Initially from 0

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like
10

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

11

Thank you, Sir.

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.