For Excel 2007 you can use the following connection string:
“Provider=Microsoft.ACE.OLEDB.12.0;” + “Data Source=C:\\Book2.xls;” +
“Extended Properties=Excel 12.0;”
Method in c# for import data from Excel file….
private void btnImportExcelToGrid_Click(object sender,
System.EventArgs e)
{
String strConn = “Provider=Microsoft.Jet.OLEDB.4.0;” +
“Data Source=C:\\Book2.xls;” +
“Extended Properties=Excel 8.0;”;
DataSet ds = new DataSet();
//You must use the $ after the object
//you reference in the spreadsheet
OleDbDataAdapter da = new OleDbDataAdapter
(“SELECT [...]
Archive for September, 2008
How to import data from Excel file using C#
September 18, 2008Google Chrome – Rocks !!!!!!
September 5, 2008Here go one new browser which you all might be heard abt it from Searching gaint Google,
ITS “Google Chrome”
Pages do load a lot quicker. Browser feels a lot lighter. Nice clean interface.
I see alot of potential in Chrome, but there are some things that bug me about the idea of Google putting out a browser.
It’s [...]