Converts the spreadsheet string to an array of the dimension and representation of array type. This function works for arrays of strings as well as arrays of numbers. The connector pane displays the default data types for this polymorphic function.
![]() |
delimiter is the string used to delimit fields in the spreadsheet file. The default is a single tab character. |
![]() |
format string specifies how to convert the input array into a string. Use %s to convert an array of strings to spreadsheet string. Use %d or %f to convert arrays of numbers to spreadsheet string. Use the format string syntax. |
![]() |
spreadsheet string contains numeric or string values separated into columns by delimiters, such as tabs or commas, with an end-of-line (EOL) character separating rows. The function converts each element in spreadsheet string according to format string and stores the resulting values in array. |
![]() |
array type is the data type input for the array. The default is a 2D array of double-precision, floating-point numbers. Refer to Array To Spreadsheet String for information about the spreadsheet format expected for arrays of three dimensions or more. |
![]() |
array is spreadsheet string converted to an array of the dimension and representation of array type. |