hi all,
i m using xsp codes containing esql queries with corresponding
page2fo.xsl file for genrating pdf dynamically. now i have to generate
spreadsheets (xls) from the database (using HSSF Serializer)& i m
thinking of using the same xsp and a page2xls.xsl file. i have gone thru
the simple-page2xls.xsl but can't get much of it. can anyone tell me how
to write xsl codes for xls generation. i have following xsp codes:
<esql:connection>
<esql:pool>regol</esql:pool>
<esql:execute-query>
<esql:query>select * from table</esql:query>
<esql:results>
<esql:row-results>
<para>
<para1>
<esql:get-string column="field1"/>
</para1>
<para2>
<esql:get-string column="field2"/>
</para2>
<para3>
<esql:get-string column="field3"/>
</para3>
<para4>
<esql:get-string column="field4"/>
</para4>
<para>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
Thanking in advance,
----------------------------------------------------------------
Sleight of hand and twist of fate,
On a bed of nails she makes me wait...
ASHISH KUMAR,
B. TECH. 3rd YR.
IIT ROORKEE,
INDIA.
----------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
