Hi Peers,
i am trying to use the code i found in one of or CF expert on how to return an excel sheet to a query but i am not able to run it ...any help will be appreciated
:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<cffunction name= "getExcelSheet" access= "public" output= "false" returntype= "query" >
<cfargument name= "filename" required= "true" type="string" />
<cfargument name= "sheetName" required= "true" type="string" />
<cfscript>
var c = "";
var stmnt = "";
var rs = "";
var sql = "Select * from [#sheetName#$]" ;
var myQuery = "";
arguments.filename = expandPath(arguments.filename);
if(len(trim(arguments.filename)) and fileExists(arguments.filename)){
try{
CreateObject( "java","java.lang.Class" ).forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
c =
CreateObject( "java","java.sql.DriverManager" ).getConnection( "jdbc
dbc
river={Microsoft Excel Driver
(*.xls)};DBQ=" & arguments.filename );
stmnt = c.createStatement();
rs = stmnt.executeQuery(sql);
myQuery = CreateObject('java','coldfusion.sql.QueryTable').init(rs);
}catch(any e){
// e r r o r - h a n d l i n g c o d e
}
}
return myQuery;
</cfscript>
</cffunction>
<cfform name="tabform">
<input type="button" onchange="getExcelSheet("exercices.xls","Pull")" />
</cfform>
</body>
</html>
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
