Transcribing from one Excel book to another.(Power Automate Desktop)
Here is an example of transcribing in Excel.
Copy the cell values from one original file into a new file and save it.



Robin(for copy and paste)
It can be copied and pasted into Power Automate Desktop.
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Test\\Src.xlsx''' Visible: False ReadOnly: True Instance=> ExcelInstance
Excel.SetActiveWorksheet.ActivateWorksheetByName Instance: ExcelInstance Name: $'''Sheet1'''
Excel.ReadFromExcel.ReadCell Instance: ExcelInstance StartColumn: 1 StartRow: 1 ReadAsText: False CellValue=> ExcelData1
Excel.ReadFromExcel.ReadCell Instance: ExcelInstance StartColumn: 1 StartRow: 2 ReadAsText: False CellValue=> ExcelData2
Excel.CloseExcel.Close Instance: ExcelInstance
Excel.LaunchExcel.LaunchUnderExistingProcess Visible: False Instance=> ExcelInstance2
Excel.WriteToExcel.WriteCell Instance: ExcelInstance2 Value: ExcelData1 Column: 1 Row: 1
Excel.WriteToExcel.WriteCell Instance: ExcelInstance2 Value: ExcelData2 Column: 2 Row: 1
Excel.CloseExcel.CloseAndSaveAs Instance: ExcelInstance2 DocumentFormat: Excel.ExcelFormat.FromExtension DocumentPath: $'''C:\\Test\\Dst.xlsx'''
Procedure
First, set up Launch Excel Action and specify the source file for transcription.
Parameter | Value |
---|---|
Launch Excel | an open the following document |
Document path | Transcribing source file. |
Make instance visible | OFF |
Open as ReadOnly | ON |

Next, set up the Set active Excel worksheet Action.
Parameter | Value |
---|---|
Excel instance | %ExcelInstance% |
Activate worksheet with | Name |
Worksheet name | The name of the sheet from which the transcription. |

Next, two Read from Excel worksheet Actions are set up to capture the value of the transcription source into a variable.
Parameter | Value of the first Action | Value of the second Action |
---|---|---|
Excel instance | %ExcelInstance% | %ExcelInstance% |
Retrieve | The value of single cell | The value of single cell |
Column | 1 | 1 |
Row | 1 | 2 |
Variables produced | ExcelData1 | ExcelData2 |


Next, set up Close Excel Action.

Next, set up Launch Excel Action and create a new file to transcribe to.
Parameter | Value |
---|---|
Launch Excel | with a blank document |
Make instance visible | OFF |

Next, set up two Write to Excel worksheet Actions and
Write the value of the variable to the book to which it is to be transcribed.
Parameter | Value of the first Action | Value of the second Action |
---|---|---|
Excel instance | %ExcelInstance2% | %ExcelInstance2% |
Value to write | %ExcelData1% | %ExcelData2% |
Write mode | On specified cell | On specified cell |
Column | 1 | 2 |
Row | 1 | 1 |


Finally, set up Close Excel Action. and save the file to which you are transcribing.

Executing this flow copies the values from the source file to the the transcribing destination file.
---
Discussion
New Comments
No comments yet. Be the first one!