Welcome, guest | Sign In | My Account | Store | Cart
from java.lang import *
from java.sql import *

Path to the excel file.This can be an absolute path or the relative path. 
In case of relative path, relativity starts from where the script is run from.


cnExcel=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=%s;READONLY=true}" % excelfile,"","")

Sheet1 is the name of the workbook in the excel sheet.All the 
values in the columns of first row will be taken as the 
column names.
rs=cnExcel.createStatement().executeQuery("SELECT * FROM [Sheet1$])

while rs.next():
The number in getString(i) method is dependent on the number of columns
available in the excel sheet
    print rs.getString(1)

Play safe.Close the connection and the recordset.


  • revision 4 (20 years ago)
  • previous revisions are not available