Page 1 of 1

Reading data from an Excel Spreadsheet

Posted: Thu Jul 05, 2007 10:32 pm
by ScottBot
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.

Posted: Sat Jul 07, 2007 11:00 am
by Richard Naninck
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.