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

Create Excel File

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.
Clipboard

Sample 2: excel.amk
Show you how to operate an Excel file.
How to operate an Excel file

Sample 3: find_file.amk
Show you how to find files in a directory.
Find Files

Sample 4: named_data.amk
Show you a very useful data structure NamedData.
NamedData

Sample 5: sort_array.amk
Show you how to sort an array.
Sort Array

Sample 6: sqlite.amk
If you use the database SQLite, then you can see this sample.
SQLite

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.
Operate Excel File

© 2018 RobotSoft Suffusion theme by Sayontan Sinha