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.
For those who want to learn Power Automate Desktop effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.