Convert Excel

Overview

The 'Convert Excel' Power Automate action allows you to the following file formats to either PDF, XLSX, HTML, CSV or TXT files:

  • xls
  • xlsx
  • xltx
  • xlsb
  • csv
  • tabdelimited
  • ods
  • spreadsheetml

Example Flows

Please refer to the following article showcasing the 'Convert Excel' action

Default Parameters

The default 'Convert Excel' flow action parameters are detailed below:

  • Filename: The filename (including file extension) of the file to be converted.
  • File Content: A Base64 encoded representation of the Excel file to be processed.
  • Output Format: Select the output format: PDF, XSLX, HTML, CSV or TXT.

mceclip0.png

Advanced Parameters

The advanced 'Convert Excel' flow action parameters are detailed below:

  • Worksheet Name: Specify the name of a worksheet to target for conversion.
  • One Page Per Sheet: Place all worksheets onto a single page (PDF only).
  • All Columns in One Page Per Sheet Name: Include all columns from a single sheet on the same page (PDF only).
  • Remove Markup: Sets whether comments and tracked changes should be removed from the document upon conversion.
  • Generate Bookmarks: Set whether bookmarks should be automatically created for documents converted to PDF.
  • Culture Name: This setting is used to set the culture for the workbook prior to conversion. Please refer to the Culture Names article for a list of supported cultures. 

mceclip0.png

Return Parameters

The 'Convert Excel' flow action returns the following data. 

Action Specific Return Values

  • File Content - The PDF document (Base64)

Standard Return Values

  • OperationId - The unique ID assigned to this operation.
  • HttpStatusCode - The HTTP Status code for the response.
  • HttpStatusMessage - The HTTP Status message for the response.
  • Errors - An array of error messages should an error occur.
  • Operation Status - Indicates whether the operation has completed, has been queued or has failed.

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk