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.
---