Skip to main content



      Home
Home » Archived » BIRT » EXCELRenderOption exported xls file cannot open in MS Excel(EXCELRenderOption exported xls file cannot open in MS Excel)
EXCELRenderOption exported xls file cannot open in MS Excel [message #1718274] Mon, 21 December 2015 22:10 Go to next message
Eclipse UserFriend
hi all,
I am newbie.
Now i use EXCELRenderOption to export xls(Excel2003 format) file,
the file can be exported, but when I use MS Excel to open the xls file,
some warning message occurred from MS Excel.

Warning message like this:
File format and extension name does not match. Files may have been corrupted or not safe. Please do not open unless you trust the source. Do you still want to open it?

When I click "Yes" bottun, the file can be opened normally。

Here is the source code:
IReportRunnable design = engine.openReportDesign("XXX/new_report.rptdesign");
IRunAndRenderTask task = engine.createRunAndRenderTask(design);
EXCELRenderOption options = new EXCELRenderOption();
options.setOutputFormat("xls");
options.setWrappingText(true);
options.setOutputFileName("D:/output.xls");
task.setRenderOption(options);
task.run();

Any hints will be appreciated.
THX
Wei
Re: EXCELRenderOption exported xls file cannot open in MS Excel [message #1837681 is a reply to message #1718274] Thu, 04 February 2021 01:24 Go to previous message
Eclipse UserFriend
up
Previous Topic:How to create an aggregate from an aggregate in a sub-group?
Next Topic:Showing data from a shift that covers two days
Goto Forum:
  


Current Time: Thu Mar 27 07:41:30 EDT 2025

Powered by FUDForum. Page generated in 0.03945 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top