Re: HSSF insert jpeg

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.