Answered

Copy Paste Into Excel Table

(0) Share

Report

Posted on by Zohaib1999

132

Hi, i succeed to copy text (Costumers) from a pogramm (textfield) with the keyboard command Ctrl + C. now i want this text paste to a excel table. This excel Table should have 2 Columns: Costumer and NR. Every time I run the flow the list should go on. For Example on the secon row should be a 2 with the costumer. on the third row 3 + costumer.

The following screenshot is in german btw.

Thank you!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Zohaib1999,

Please use action "Get First Free Column Row " to get first free row to write your data. Please find the below excel and code for your use case scenarios.

Excel file:
Code:
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Deenu\\Accounts_Details.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.GetFirstFreeColumnRow Instance: ExcelInstance FirstFreeColumn=> FirstFreeColumn FirstFreeRow=> FirstFreeRow
Excel.WriteToExcel.WriteNamedCell Instance: ExcelInstance Value: $'''test''' CellName: $'''A%FirstFreeColumn%'''
Excel.WriteToExcel.WriteNamedCell Instance: ExcelInstance Value: $'''test''' CellName: $'''B%FirstFreeColumn%'''
Excel.SaveExcel.Save Instance: ExcelInstance

Screenshot of code:

Thanks,
Deenu

Was this reply helpful? Yes No
Zohaib1999 132 on at

Like
a
(0)

Report
Copy link

Link copied!

Does it list automaticilly ? 1,2,3,4 ... next to the costumers

Was this reply helpful? Yes No
Verified answer

Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Zohaib1999
Yes, It does. Please find the below screenshots.
1. In the below scenario Excel has only header so during the debugging "Get First Free Column Row " Action returns first free row as "2"

2. After inserting the text value in the above scenarios, Now it shows next free row as "3".

Updated code:
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Deenu\\Customer.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.GetFirstFreeColumnRow Instance: ExcelInstance FirstFreeColumn=> FirstFreeColumn FirstFreeRow=> FirstFreeRow
Excel.WriteToExcel.WriteNamedCell Instance: ExcelInstance Value: $'''test''' CellName: $'''A%FirstFreeRow%'''
Excel.WriteToExcel.WriteNamedCell Instance: ExcelInstance Value: $'''test''' CellName: $'''B%FirstFreeRow%'''
Excel.SaveExcel.Save Instance: ExcelInstance

Thanks,
Deenu
-----------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up. Thank you.

Was this reply helpful? Yes No