Successful Excel 2007 read/write experience

jivernaw

// Normal Excel 2007/2010 Worksheet

var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:\\sahi\\userdata\\scripts\\your_excel_file.xlsx;readOnly=false", "", "");

// Binary Excel 2007/2010 Worksheet (less space, faster operations)

var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:\\sahi\\userdata\\scripts\\your_excel_file.xlsb;readOnly=false", "", "");

PS: you can use any other driver available on your sistem with sahi, just check the driver name -> Control Panel\All Control Panel Items\Administrative Tools\Data Sources (ODBC)\Drivers\Name column

Example: {Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}

narayan

Thanks Jivernaw!