formatting within excelbuffer

sbilly · **Posted:** Wed Feb 15, 2012 4:40 pm

Hi all,
Who knows how can I set the background color of a column when exporting a report to excel with excel buffer.
And how can I control the font size.
Thanks

ClausHamann · **Posted:** Wed Feb 15, 2012 9:09 pm

You can do this by adding the following lines to the CreateSheet function in table 370 - Excel Buffer

Code: Select all

IF "Font Size" <> 0 THEN
  XlWrkSht.Range(xlColID + xlRowID).Font.Size := "Font Size";

IF "Background Colour" <> 0 THEN
  XlWrkSht.Range(xlColID + xlRowID).Interior.ColorIndex := "Background Colour";

where "Font Size" and "Background Colour" are new fields in the Excel Buffer table.
Add the lines in the REPEAT UNTIL loop after

Code: Select all

IF Underline THEN
  XlWrkSht.Range(xlColID + xlRowID).Borders.Item(XlEdgeBottom).LineStyle := XlContinuous;

Regards

sbilly · **Posted:** Wed Feb 15, 2012 11:23 pm

Thanks for your replay, but tell how can I exploit it in the report.
Thanks

mohasin · **Posted:** Thu Feb 16, 2012 7:39 am

hi guys,
I m new to nav
can u tel me how i wil get xlSheet and XlWrkBk objects;
i knw only excel buffer object from that i hav used createbook();
please tel me all thing about this.

mohana_cse06 · **Posted:** Thu Feb 16, 2012 7:43 am

They are automation Variables..

Check Excel Buffer Table - 370

ClausHamann · **Posted:** Thu Feb 16, 2012 7:47 am

You have to find the places in the report that insets the data you want colored or changed size on and then update the code to populated the new fields in the Excel Buffer table.

Regards

mohasin · **Posted:** Thu Feb 16, 2012 8:00 am

Hi mohana, can u brief what autamtion variable how to creat that and use it

mohana_cse06 · **Posted:** Thu Feb 16, 2012 8:05 am

Did you check Table Excel Buffer..how it is created and used?
Search the forum please..

mibuso.com

formatting within excelbuffer

Who is online