Re: HSSF insert jpeg

["Gene Burns" <burns.gene@xxxxxxxxx>]

I have the row size set in the template, but I set the column size, merged
cells, and cell formats in my program.
Our logo takes up 8 consecutive cells of the first row which is set to a row
height of 102, and I merge the cells in the program.
The logo that I am using is also a jpg.  I do increment the rowcount for the
row where the logo is displayed, but I don't do a HSSFSheet_createRow for
that row.

I'm not sure what else I can tell you that might help.


On Jan 8, 2008 1:12 PM, <DLee@xxxxxxxx> wrote:

> <I found it easiest to insert the company logo in a template, and then
> open
> the template, instead of creating a new spreadsheet.
>
> You basically use the following to open a template:
>
>        // Open template for new spreadsheet
>        book = hssf_open('/yourdir/template.xlt');
>
> And instead of creating a new sheet you open the existing one:
>
>        wkname = 'Sheet1';
>        sheetname = new_String(%trim(wkname));
>        Sheet = hssf_getSheet(book: %trim(wkname));>
>
> Gene Thanks for the reply.
>
> What you describe is bassically the same as what I'm doing, then I get the
> cells I'm interested in updating, and I save the workbook to a new name.
> Only problem is I'm losing all the cell formating of the template, and
> never see the logo in the saved workbook.
>
> Thanks for your reply
>
> Darrell Lee
> Information Technology
> Extension 7127
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.