I want to copy selected columns in Microsoft Excel using its column number but it does not work. [image] 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?

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] Hi @ROBERT_RUSSELL_MONSA Mark as solution and like it if this helps you :slight_smile: Happy Automation :raised_hands: Best Regards Er Pratik W…

Hi @ROBERT_RUSSELL_MONSA Please have a look at this post. [image] Copy excel column Help i am trying to insert column after column name"2019". and copy column"2019 " and paste it into next column. and edit 2019 to 2020. check attached file. New Microsoft Excel Worksheet…

Hi @ROBERT_RUSSELL_MONSA Below is the updated workflow for the same CopyPratik.xaml (7.9 KB) [image] Output :- [image] Mark as solution and like it :slight_smile: Happy Automation :raised_hands: Best Regards Er Pratik Wavhal :robot::man_technologist:t4: :computer:

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

Thank you so much Sir @Pratik_Wavhal .

Hi @ROBERT_RUSSELL_MONSA You are welcome :slight_smile: Happy Automation :raised_hands: Best Regards Er Pratik Wavhal :robot::man_technologist:t4: :computer:

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]

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:

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

Copying of selected column in Microsoft Excel using its column number

Help Studio

Krishna_C (Krishna C) July 9, 2020, 4:41pm 2

Hi @ROBERT_RUSSELL_MONSA

Please have a look at this post.

regards,
Krishna

Topic		Replies	Views
Copy excel column Help excel , activities , question	4	3904	February 13, 2020
How to copy paste the last entire column Automation Ops question , automation_ops	4	145	August 20, 2024
Dynamic Excel Columns For Copy Data Studio datatable , excel , studio , question	7	2068	July 5, 2020
Copy cell value from excel 1 and paste the contents of excel to excel 2 , by adding another column in excel 2 Help excel , activities , question	8	1864	August 17, 2019
Add new Column excel form another excel Activities excel , activities , question	11	866	February 16, 2023

Copying of selected column in Microsoft Excel using its column number

Related topics