Function: splitRangeText()

function splitRangeText(
   sheet, 
   range, 
   delimiter?, 
   customDelimiter?, 
   treatMultipleDelimitersAsOne?): ISplitRangeTextResult

Defined in: submodules/univer/packages/sheets/src/basics/split-range-text.ts:186

Split the text in the range into a two-dimensional array.

Parameters

Parameter	Type	Default value	Description
`sheet`	`Worksheet`	`undefined`	The worksheet which range belongs to.
`range`	`IRange`	`undefined`	The range to split.
`delimiter`?	`SplitDelimiterEnum`	`undefined`	The delimiter to split the text.
`customDelimiter`?	`string`	`undefined`	The custom delimiter to split the text. An error will be thrown if customDelimiter is not a character.
`treatMultipleDelimitersAsOne`?	`boolean`	`false`	split multiple delimiters as one.

ISplitRangeTextResult

The two-dimensional array of the split text and max column length.