format-currency-excel
Service icon

Format Currency Excel

Stable version 1.0.1 (Compatible with OutSystems 11)
Uploaded
 on 10 Aug (yesterday)
 by 
0.0
 (0 ratings)
format-currency-excel

Format Currency Excel

Documentation
1.0.1

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. 

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

  • CellAddresses: List of cells, columns, or ranges that should be formatted as currency. 

  • StCellItem: Data structure containing the names of the cells to be converted to currency.

  • CellName: Cell name.  

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.


1.0.0

Options  

 

  • FormatCurrency

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

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

  • CellAddresses: List of cells, columns, or ranges that should be formatted as currency. 

  • StCellItem: Data structure containing the names of the cells to be converted to currency.

  • CellName: Cell name.  

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.