EXCEL BASIC handles your local EXCEL
- Meaning you must have the EXCEL app installed in your device.
When it does not work
- Make sure the target EXCEL file is closed
- EXCEL file can be open even when it is not visible on the Windows screen – make sure to close it from the Task Manager (Details)
- When handling multiple cells, use User Variable in Array
- Check file path/name and sheet name for accuracy
1) Choose either Read or Write
2) Click here and select file to capture the entire path.
(Sorry, drag and drop does not work as yet.)
3) To obtain sheet name accurately, use copy and paste from the Excel file.
Write option can create a new Excel sheet too
- When you are in the Write mode, you can specify an EXCEL file that does not exist. In this case, it creates a new EXCEL file from your specifications automatically.
4) Specify cells to read from or write to
Note) EXCEL BASIC can only select one row or column. For multiple rows and columns, use Add Item
5) Specify User Variable here
6) Specify Data Orientation here
7) Remove all settings here
Related Tutorial Video