| Name
|
Brief
|
Example
|
| add_user_label
|
Add user parameter
|
Examples
|
| get_book_sheet_names
|
check given string to see if in the form of [Book]Sheet1, if yes, break down and return book and sheet names
|
Examples
|
| find_col_by_name
|
To find column by long name, if not found then find column by short name.
|
Examples
|
| find_user_defined_label
|
To find the user defined label by name in Worksheet.
|
Examples
|
| is_col_all_text
|
check a worksheet column to see if it is really a text column
|
Examples
|
| is_column_in_bounds
|
Check the column if is in the bound
|
Examples
|
| make_book_sheet_name
|
return string in the form of [Data1]Sheet1
|
Examples
|
| okoc_create_workbook
|
creating a new workbook with more controls
|
Examples
|
| out_tree_to_wks
|
output result from tree to worksheet.
|
Examples
|
| save_data_2_Wks
|
put XY or XYZ data to worksheet
|
Examples
|
| setLabelValueFromRows
|
Set column label value from rows value
|
Examples
|
| sheet_find_empty_dataobject
|
Find first DataObject of last empty range in the specified Datasheet starting with the specified DataObject.
|
Examples
|
| wks_add_show_labels
|
Add more labels to worksheet column lablel region, make display order according order in vnType
|
Examples
|
| wks_copy
|
Copy a worksheet from another worksheet
|
Examples
|
| wks_find_empty_column
|
Find first column of last empty range in the specified worksheet starting with the specified column.
|
Examples
|
| wks_from_book_sheet_name
|
Attach a worksheet by [Book]Sheet string
|
Examples
|
| wks_get_book_sheet_name
|
construct the [Book1]Sheet1 string from given Datasheet
|
Examples
|
| wks_has_complex_col
|
Checks whether worksheet has complex column
|
Examples
|
| wks_has_x
|
when import data, if we need not show time column and use append col import mode, we need check if wks has x column. It will return true, if wks is not empty AND has X column.
|
Examples
|
| wks_insert_column
|
It appends or inserts a column to worksheet at a desired position.
|
Examples
|
| wks_scroll_into_view
|
worksheet scroll function
|
Examples
|
| wks_sep_label
|
Extract units from worksheet column Long Name or other label row
|
Examples
|
| wks_set_label_text_control
|
Change worksheet label text style control.
|
Examples
|
| wks_set_show_labels
|
Configure worksheet column lablel region display options
|
Examples
|