Site icon Kaizen.Personal computer work.

How to convert between Roman numerals and Arabic numerals.(Power Automate Desktop)

Japanese version.

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: ExcelInstance

Conversion 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: ExcelInstance

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

ParameterValue
Launch Excelwith a blank document
Make instance visibleOFF

Set up a Write to Excel worksheet Action.

ParameterValue
Value to writeEither of the following.
 Roman numerals to be converted (alphabetic characters).
 Arithmetic numbers to be converted (one-byte characters).
Write modeOn specified cell
Column1
Row1

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.

ParameterValue
Value to write=ARABIC(A1)
or
=ROMAN(A1)
Write modeOn specified cell
Column1
Row2

The result of this formula can be retrieved with Read from Excel worksheet Action to capture the converted result in a variable.

ParameterValue
RetrieveThe value of a single cell
Start column1
Start row2

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.

Links

Tips(Power Automate Desktop)

Exit mobile version