Options
FormatCurrencyExcel
Extension library for Excel worksheet formatting, enabling dynamic currency formatting on cells and columns by address or header name while preserving the workbook's original formatting.
FormatCurrencyByHeader: Applies currency formatting to all cells in the columns identified by the specified header names and returns the updated Excel file.
ExcelFile: Excel file that will receive the currency formatting.
StartRow: Row number where formatting should start being applied. All previous rows will be ignored, preserving headers, subtitles, and existing formatting.
CurrencyFormat: Currency format to be applied to the selected cells.
HeaderNames: List of column header names that should be formatted as currency.
StCellItem: Data structure containing the names of the cells to be converted to currency.
CellName: Cell name.
FormatCurrencyCells: Applies currency formatting to the specified cells, columns, or ranges and returns the updated Excel file.
CellAddresses: List of cells, columns, or ranges that should be formatted as currency.
How can i use this component?
You need to insert the action you want to use into the flow, whether for formatting by header name or by cell.
FormatCurrency