excel_sheet_get_row_str¶
excel_sheet_get_row_str returns a string data matrix with the values of a section of an Excel sheet.
-
smString = excel_sheet_get_row_str(oSheet)
Return Value
smString is a string matrix. The matrix contains the string values of the segment of a sheet. Before this function is invoked excel_sheet_get_rows must be invoked to load the data. The number of columns is identical to the number of columns of the sheet. The number of rows is identical to the return value of excel_sheet_get_rows. If a cell is empty or contains a number the correspnding element of smString is set to “”.
Parameters
-
oSheet oSheet is an object created by excel_sheet_open.
Comment
Before this function is invoked excel_sheet_get_rows must be invoked.
Example
See excel_open.
History
| Version | Description |
|---|---|
| 5.5.0 | New |
See also
Overview Excel Files excel_open, excel_sheet_open, excel_get_sheetnames, excel_get_style_index, excel_get_style_map, excel_sheet_close, excel_sheet_get_rows, excel_sheet_get_row_num, excel_sheet_get_row_style, excel_sheet_get_row_type
id-440301