- Dynamic Header & Footer: Make headers and descriptions dynamic with information such as date, user name, and report number.
- Data Formatting: Create more readable reports by applying custom formatting to dates and numerical values.
- Data Compression: Filter or split large data sets before converting them to Base64 format.
- Integration Potential: Download the generated Base64 data:
- Download File action to download,
- Send Email action to add to an email,
- Send to other systems via API.
Technical Risks and Controls
- Data Size: Large files may become bloated in Base64 format. Compression should be applied if necessary.
- Invalid Table: The Value parameter must contain a valid data format. Missing data may cause issues.
- Formatting Issues: Header and Footer text should be short, clean, and free of special characters.
The Get Excel Base64 action converts your data into Excel format and retrieves it in an encoded form. This enables secure and controlled processes such as downloading, sharing, emailing, or transferring data to a server. It is a powerful action, especially for large reports and integration scenarios.
