using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=somedataineed.xls;Extended Properties=\"Excel 12.0 Xml;HDR=NO\";");

The connection string is fairly standard. However, notice the ‘HDR=No’ under extended properties, this tells the connection to assume that the first row does not contain header text. By default, or if ‘HDR=Yes’, the first row will be disregarded as headers and the first row of data may be skipped, be CAREFUL.

Once the connection is open the spreadsheet can be queried like any SQL database,

OleDbCommand comm = conn.CreateCommand();
comm.CommandText = "SELECT * FROM Sheet1";
OleDbDataReader read = comm.ExecuteReader();

while (read.Read())
{
   // Do something here, manipulate the data, get a coffeee, something!
}

read.Close();
conn.Close();

Of course, if the spreadsheet has no headers (in the first row) then you have to reference the fields by ordinal, otherwise you can reference the column names. Thats it, the spreadsheet and its data are now at you mercy!

Keen observers will have noticed that the default Excel sheet name (”‘Sheet1″) was used as the table name in the query. What happens if you don’t know the name of the sheet? (or worse some pesky user didn’t like the sheet name and saw fit to change it, how dare they?)

If this happens (and it probably will), take a peek at the workbook layout (”database schema”) and find out the sheet names (”table names”). This is useful in a number of instances, for example, importing the data into another application without forcing the user to perform a text export from Excel.

Get it here.

This release includes an optional WifFi-VEN-DB.pdb (621KB). If you choose to install it, WifFi will attempt to “guess” the hardware behind each detected AP. To access this information click the SSID header twice, it will flip from SSID to MAC to VENDOR.

NOTE: This will only work for AP’s found (or refound) after the Vendor DB is installed.

Enjoy!

All content should now be available under the new site, let me know if something is missing otherwise enjoy.

In addition, a new version of WifFi will be available soon, with many new features and bug fixes including support for the Palm T|X.

Unfortunately, this move will break most existing links and render some content inaccessible for several days (until I get around to transferring it). If you absolutely need something that used to be here, send an email.

However, if your looking for WifFi, There is GOOD NEWS!