Here's a sample config to query data from an Excel spreadsheet. The sample import has an XLS file with data in the first sheet, Script Device, and VB script to display the data from the XLS.
It's very simple in what it does, but it will hopefully be helpful as a starting point to modify to meet any specific Excel spreadsheet needs.
To use the import, just drop the HBX file onto HouseBot and restart.
Reading data from an Excel Spreadsheet
Reading data from an Excel Spreadsheet
- Attachments
-
- XLSSample.hbx
- Excel Spreadsheet Sample Import
- (2.67 KiB) Downloaded 407 times
Scott
-
Richard Naninck
- HouseBot Guru Extraordinaire
- Posts: 1121
- Joined: Tue Sep 28, 2004 7:49 am
- Location: The Netherlands
Thanks Scott,
Never bothered about it until I just saw how it is done. Just changed my DVD selection sub from being text based to excel based.
First off I made a text export from an Excel file and built a script around it. This was so easy that I changed it to read the xls file directly. Saves me making a text export.
Never bothered about it until I just saw how it is done. Just changed my DVD selection sub from being text based to excel based.
First off I made a text export from an Excel file and built a script around it. This was so easy that I changed it to read the xls file directly. Saves me making a text export.