Saving htmldw to formatted excel

[Kevin Han]

Hi,

I'm currently using the below in jsp to output htmldw into pdf:

htmldw.setContentType("application/pdf");
htmldw.generate();
out.clear();
htmldw.printBinary();

I want to output to formatted excel instead however changing to the
below line only saves the resultset of the datawindow into excel:

htmldw.setContentType("application/vnd.ms-excel");

Does anyone know how to save the htmldw into formatted excel which
resembles the datawindow?

Many thanks.