OleDB is a very useful API in .NET, especially when programmatically manipulating the data in an Excel spreadsheet. In fact, it can open an Excel spreadsheet and query the data using regular SQL statements.
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.
(more…)
July 20th, 2009
WifFi 1.2b (second edition) is ready!
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!
October 30th, 2006
Splitbits is now running on a new web host and new software!
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.
September 8th, 2006
Splitbits is moving, to a different server and a different software platform.
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!
August 27th, 2006
