Zappy Docs

Excel Column Split

Zappy.ZappyActions.Excel

Split/divide a cell content into sub strings smaller in the excel workbook

Properties

.

INPUT

RowIndex – Row index of the opened workbook.

ColumnIndex – Column index of the opened workbook.

Index – Set array’s index which one splitting sub-string we want.

SheetName – SheetName of the opened workbook.

WorkbookName – Workbook name.

Separator – Separator as a delimiter.

ExcelPerpertyType – The Select from drop down whatever you want from the opened Workbook and set from “Value”,” WidthInChars”,” Formula”, ”HeightInPoints”, ”Wrap Text”, ”Text”, “CellBackgroundColor”, “FindTextInSheet”, “FindLastCellRow”, “FindSheetName”, “FitExcelWorksheet”.

OUTPUT

PropertyValue – Split value of set row and column index from the opened workbook.

Updated 6 months ago


Excel Column Split


Zappy.ZappyActions.Excel

Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.