<!--
This Gel script allows to read from directly Excel
-->
<gel:script 
xmlns:core="jelly:core"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary" 
xmlns:sql="jelly:sql">

<!-- Filename of the excel file that is going to be read by gel script -->
<!-- The file should be placed under the %NIKU_HOME%\bin -->
<gel:parameter var="v_file_name" default="tac_resources_list.xls" />
<gel:parameter var="v_worksheet" default="Dummy Data" />
<gel:parameter var="v_worksheet_prefix" default="[Excel 8.0;HDR=YES;Database=${v_file_name}]." />

<!-- ODBC Connection is defaulted to Excel Files  -->
<core:set var="v_odbc">Excel Files</core:set>
<core:set var="v_driver">sun.jdbc.odbc.JdbcOdbcDriver</core:set>
<core:set var="v_connection_string" value="jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=${v_file_name}" />
<sql:setDataSource url="${v_connection_string}" driver="${v_driver}" />

<sql:query var="v_my_result_set">SELECT * FROM ${v_worksheet_prefix}[${v_worksheet}$$]</sql:query>
<core:forEach trim="true" items="${v_my_result_set.rowsByIndex}" var="row">
	<core:forEach trim="true" items="${row}" var="col" indexVar="i">
		<gel:out>${v_my_result_set.columnNames[i]}: ${col}</gel:out>
	<gel:out>${v_my_result_set.columnNames[i]}: ${col}</gel:out>
	</core:forEach>
</core:forEach>
</gel:script>