How to convert between Roman numerals and Arabic numerals.(Power Automate Desktop)
Introduction to interconversion between Roman numerals and Arabic numerals in Power Automate Desktop.
Roman numerals are not machine dependent characters, but alphabetic characters.
Overall view of Flow
Robin(for copy and paste)
It can be copied and pasted into Power Automate Desktop.
Conversion from Roman numerals to Arabic numerals
Excel.LaunchExcel.LaunchUnderExistingProcess Visible: False Instance=> ExcelInstance
Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: $'''IV''' Column: 1 Row: 1
Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: $'''=ARABIC(A1)''' Column: 1 Row: 2
Excel.ReadFromExcel.ReadCell Instance: ExcelInstance StartColumn: 1 StartRow: 2 ReadAsText: False CellValue=> ExcelData
Excel.CloseExcel.Close Instance: ExcelInstanceConversion from Arabic numerals to Roman numerals
Excel.LaunchExcel.LaunchUnderExistingProcess Visible: False Instance=> ExcelInstance
Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: 4 Column: 1 Row: 1
Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: $'''=ROMAN(A1)''' Column: 1 Row: 2
Excel.ReadFromExcel.ReadCell Instance: ExcelInstance StartColumn: 1 StartRow: 2 ReadAsText: False CellValue=> ExcelData
Excel.CloseExcel.Close Instance: ExcelInstanceFlow creation steps
This Flow requires a lot of work using Power Automate Desktop alone, so an Excel sheet is utilized.
Set up an Excel Launch Action and create an empty Excel book.
| Parameter | Value |
|---|---|
| Launch Excel | with a blank document |
| Make instance visible | OFF |
Set up a Write to Excel worksheet Action.
| Parameter | Value |
|---|---|
| Value to write | Either of the following. Roman numerals to be converted (alphabetic characters). Arithmetic numbers to be converted (one-byte characters). |
| Write mode | On specified cell |
| Column | 1 |
| Row | 1 |
Set up one more Write to Excel worksheet Action.
Set up the ARABIC function to convert from Roman numerals to arithmetic numbers.
Set up a ROMAN function to convert from arithmetic to Roman numerals.
| Parameter | Value |
|---|---|
| Value to write | =ARABIC(A1) or =ROMAN(A1) |
| Write mode | On specified cell |
| Column | 1 |
| Row | 2 |
The result of this formula can be retrieved with Read from Excel worksheet Action to capture the converted result in a variable.
| Parameter | Value |
|---|---|
| Retrieve | The value of a single cell |
| Start column | 1 |
| Start row | 2 |
---