Eclipse Community Forums: BIRT » XLS Emitter Configuration

Home » Archived » BIRT » XLS Emitter Configuration

XLS Emitter Configuration [message #256444]

Thu, 27 September 2007 09:27

Eclipse User

Originally posted by: amanita.mail.ru

Hello,

I have to determine fixed column width in Excel for report exported from
BIRT. My report have over 30 columns and XLS Emitter makes the columns
"one-character-width". This is unreadable. I have found this code:

// setup XLS emitter configuration
Map xlsConfig = new HashMap( );
// Check out constants in XlsEmitterConfig.java for more configuration
detail.
xlsConfig.put( "fixed_column_width", new Integer( 150 ) ); //$NON-NLS-1$
// Associate the configuration with the XLS output format.
config.setEmitterConfiguration( XLS_FORMAT, xlsConfig );

But it doesn't work for me, there are no changes in Excel file. I have
either error nor the columns have the fixed width. This code seems to be
ignored.

Can someone help me to fix this problem. Thank you!
Sam

Re: XLS Emitter Configuration [message #256647 is a reply to message #256444]

Mon, 01 October 2007 05:05

Eclipse User

Originally posted by: amanita.mail.ru

I do not need a complete solution. I would appreciate if you just give me
a hint if there is a possibility to configurate the emitter.

Thank you very much,
Sam

Re: XLS Emitter Configuration [message #256682 is a reply to message #256444]

Mon, 01 October 2007 15:39

Eclipse User

Sam,

Are you sure you are looking at the same XLS emitter? The code you have
posted seems like for the XLS emitter from tribix which is not same as the
one that comes built-in with the birt engine. I think that's why the code
does not have any effect on the final output. If you want to use tribix XLS
emitter, you can download it and use it. But make sure that the birt
internal xls emitter should be removed before using tribix one, because it
confuses the report engine and no output is generated.

Thanks
Bidyut

"Sam" <amanita@mail.ru> wrote in message
news:15cf5c9fdbe8b7c25b597192f69df14d$1@www.eclipse.org...
> Hello,
>
> I have to determine fixed column width in Excel for report exported from
> BIRT. My report have over 30 columns and XLS Emitter makes the columns
> "one-character-width". This is unreadable. I have found this code:
>
> // setup XLS emitter configuration
> Map xlsConfig = new HashMap( );
> // Check out constants in XlsEmitterConfig.java for more configuration
> detail.
> xlsConfig.put( "fixed_column_width", new Integer( 150 ) ); //$NON-NLS-1$
> // Associate the configuration with the XLS output format.
> config.setEmitterConfiguration( XLS_FORMAT, xlsConfig );
>
> But it doesn't work for me, there are no changes in Excel file. I have
> either error nor the columns have the fixed width. This code seems to be
> ignored.
>
> Can someone help me to fix this problem. Thank you!
> Sam
>
>
>

Re: XLS Emitter Configuration [message #256707 is a reply to message #256682]

Tue, 02 October 2007 03:59

Eclipse User

Originally posted by: amanita.mail.ru

Bidyut Pattanayak wrote:

> Are you sure you are looking at the same XLS emitter? The code you have
> posted seems like for the XLS emitter from tribix which is not same as the
> one that comes built-in with the birt engine.

Bidyut, thank you very much. I did not know there are 2 emitters: i have
just managed to install tribix emitter and it works according to my needs.

Thanks,
Sam

Previous Topic:	Taglib starts and shuts down engine every time
Next Topic:	Problems with Postscript fonts

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 17 20:31:16 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter