browser problem with xls output

[2005 IR Help]

By: ajay kumar - ajaykumar

browser problem with xls output

2003-02-19 20:40

hi friends!

iam redirecting to an xls file generated from my jasper servlet..but browser is showing some junk characters.its not invoking excel application in broswer..suggestions are invited in this regard..

 

ajay

ajay@firstgensystems.com

 

 

 

 

By: Thomas Richter - hornet_f4c

RE: browser problem with xls output

2003-02-21 07:02

Another point - For the XLS output looks kind of weird. Layout seems not to correct and all lines and images are missing.

 

Pdf was fine ... so instead of running the report to a PdfStream I filled it into a JasperPrint Object to generate the xls from... what's wrong ?

 

 

 

 

By: Manu Karunta - karunta

RE: browser problem with xls output

2004-03-03 21:22

Hi,

I also got a problem with this,

the browser show only junk characters

 

I'm using:

JRXlsExporter exporter = new JRXlsExporter();

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp);

exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, sc.getRealPath("/view/report.xls"));

exporter.exportReport();

 

nb:

the report.xls file exist and it can be showed in excel application

 

the problem is:

the browser can't view the excel report by invoking the excel applocation installed in the OS

 

Any comment or solution?

 

thanks

Manu Karunta

 

 

 

 

 

 

 

 

 

By: David Lim - aberrant80

RE: browser problem with xls output

2004-03-03 22:18

Well, i don't know about xls not appearing but i do know why there's no images. If you've actually bothered to read the FAQ, you'll see this line:

 

"The Jakarta POI library that we use when exporting the report to XLS format does not currently supports images."

 

 

 

 

By: Manu Karunta - karunta

RE: browser problem with xls output

2004-03-03 23:21

The browser only show this:

 

Ðࡱể?;J?;?????????????????????????????????????????????????????????????????????????????????????????????????????????????Ó̇Aá‚°?✰Manu Karunta B?a>=>??>?>=h>>:?#8>X@?">?>Ú‚1È¿?>>Arial1È¿?>>Arial1È¿?>>Arial1È¿?>>Arial1" >?> >SansSerif1"äˆ> >SansSerif1"䈼 >SansSerif1"??> >sansserif"$"#,##0_);("$"#,##0)!"$"#,##0_);[Red]("$"#,##0)""$"#,##0.00_);("$"#,##0.00)'""$"#,##0.00_);[Red]("$"#,##0.00)7*2_("$"* #,##0_);_("$"* (#,##0);_("$"* "-"_);_(@_).))_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* (#,##0.00);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)???gt;???gt;?????????? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?gt; ??gt;+???gt;)???gt;,???gt;*???gt; ???gt; ? ?> ? ?> ? ?> ? ?> ? ?> ? ?> ? ?> ? ?> ? ?????????????t;? Sheet1?>>?>PT.Excelcomindo Pratama>Date :>4/3/2004>Time :>14:11:19>Page : >Detail Transaction per-Micro Report>1/3/2000 - 1/3/2007>CA : > Microsuck>>NO. >DATE TIME >SETTLE DATE>TRX TYPE>MSISDN>NAME>AMOUNT>B.CYCLE>CHANNEL>TERM.ID>APP.CODE>PROC.FEE>TRX.FEE>16/01/2004 12:05:42 >19-12-2003>Bill Payment Using Cash >JAUW ERWIN >1,951,124.00>EDC/POS>3,500.00>16/01/2004 12:33:23>19/01/2004 18:42:43>19/01/2004 18:47:24>19/01/2004 18:47:32>19/01/2004 18:49:32>19/01/2004 18:52:02>11/02/2004 16:03:47>12/02/2004 15:28:45>13/02/2004 09:39:08>13/02/2004 10:16:02 >SUB TOTAL >21,462,364.00 >38,500.00>TOTAL>?? ̇? > d>?P?_>*+?>?%????">d>>>,>,>à¿?U} } >>3} ?} V} ×} ? } 3} ?} ?} d} ^} } ?} ?} V} } á…} Û‚} `} } 7} +} 7} } X>} ?} Ù¦gt;} /} ?} G} ×} ×} ?} !!= } ""?} ##×} $$? } %%?} &&l } ''?} (( } ))×} **ë} ++?} ,,?} --?} ..?} //×} 00? } 11 E1>>>>>>>>>>> > > > >

 

................

 

Can someone help me?