For searching in a datagrid, here is an implementation of the datagrid's FindIndexes command. We are using this command in DGH for creating the content of its property palette from a datagrid dictionary. The properties are displayed depending of the context (datagrid form or datagrid table selected, column or form builder opened).
The command makes the usage of the “value” function, a powerful function capable of evaluating a string for rendering the corresponding value.
dgh_FindIndexes the longid of grp "myDatagrid", "Article", "is", "box"
How to import a MS Excel Worksheet in a datagrid?
The first usage that may come to mind with such an Excel library, is to import the content of a worksheet in LiveCode.
What would be the steps to follow for importing a Worksheet?
What are the keywords we need in the MS Library, for accomplishing that?
XCEL_Range_Ref_Add: Retuns a reference to a range.
XCEL_Range_Ref_CleanAll: Free up the range references from the memory.
This is our first article about our Excel Library. For importing an Excel Worksheet in a datagrid, we have combined 7 keywords from the Excel Library. 7 keywords only on the 174 keywords actually available.