Documentation Index

Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt

Use this file to discover all available pages before exploring further.

Have Questions?  Need Expert Answers?  JOIN LUNCH N' LEARNS!

Convert Spreadsheet to XLSX

Prev Next
Step Details
Introduced in Version10.2
Last Modified in Version--
LocationData > Excel






The ConvertSpreadsheetToXlsx step converts XLS, XLSM, XLSB, and XLSX files to XLSX format so other Excel steps are able to read the file.

Considerations

  •  This source format is detected from the file contents, not from its extension. 
  • VBA macros in a macro-enabled workbook are not preserved in the XLSX output.
  • The output is generated unprotected. Enable Lock Excel File to protect the workbook.

Properties

Inputs

PropertyDescriptionData Type
SpreadsheetEnables Users to specify an Excel file. This file must be one of the following formats:
  • XLS
  • XLSM
  • XLSB
  • XLSX
Filedata
PasswordSpecifies the logged-in User's password. String

Outputs

PropertyDescriptionData Type
ConvertSpreadsheetToXLSX1_OutputConverts specified file to XLSX. FileData

Example Inputs and Outputs

INPUTS: {
spreadsheet: {
Id:
FileName:
Length:
FileType:
}
password: 
}

OUTPUTS: [
0: {
path: "Done"
data: {
Output: {
Id:
Filename:
Length:
FileType: