You can use the function XLS_GetCell to read a cell of an Excel file.
You can download the sample from ReadExcel.zip.
How to read Excel file
Script
Comments Off on How to read Excel file
Mar 252021
How to create an excel file
Uncategorized
Comments Off on How to create an excel file
Jun 142014
You can call the function XLS_Create to create an excel file. And you can call the function XLS_Open to check if an excel file exists. If it does not exist, then call XLS_Create to create. Sample: Excel.amk
There are many other excel functions in Automatic Mouse and Keyboard, to learn more about them, please see http://blog.robot-soft.com/how-to-operate-excel-file.
Some sample scripts of Automatic Mouse and Keyboard
Mouse Keyboard
Comments Off on Some sample scripts of Automatic Mouse and Keyboard
Sep 302013
If you have read the help document of Automatic Mouse and Keyboard, and want to learn more about it, then you can download and see these samples: amk_samples.zip
Sample 1: clipboard.amk
Show you how to get the clipboard text.
Sample 2: excel.amk
Show you how to operate an Excel file.
Sample 3: find_file.amk
Show you how to find files in a directory.
Sample 4: named_data.amk
Show you a very useful data structure NamedData.
Sample 5: sort_array.amk
Show you how to sort an array.
Sample 6: sqlite.amk
If you use the database SQLite, then you can see this sample.
How to operate excel file
Mouse Keyboard
Comments Off on How to operate excel file
Feb 282013
Excel functions now are available in Automatic Mouse and Keyboard. There are 15 Excel functions:
XLS_Open: Open an Excel file, will return the handle of the Workbook.
XLS_Create: Create an Excel file, will return the handle of the Workbook.
XLS_GetCell: Get value of a cell.
XLS_SetCell: Set value of a cell.
XLS_DelRow: Delete a row.
XLS_DelColumn: Delete a column.
XLS_GetRow: Get a row, return an Array which contains the values of the row.
XLS_GetColumn: Get a column, return an Array which contains the values of the column.
XLS_SetRow: Set a row.
XLS_SetColumn: Set a column.
XLS_Save: Save the Excel file.
XLS_AddSheet: Add a new sheet.
XLS_DelSheet: Delete a sheet.
XLS_SheetRowCount: Get row count of a sheet.
XLS_SheetColumnCount: Get column count of a sheet.
You can operate Excel files easily with these functions.
