× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Which version of POI are you using? An older version like 3.6 might not have the comment methods.

On 4/5/2021 8:39 AM, gio.cot via RPG400-L wrote:
Hi all

please be patient .


i have tried to write this program (just try to set the author ..)


H DFTACTGRP(*NO) BNDDIR('HSSF')

/copy hssf_h

D IFSDIR C '/tmp'

*------------*****

D ZCOMMENT_CLASS...

D C 'org.apache.poi.xssf.usermod-

D el.XSSFComment'

D ZCELL_CLASS...

D C 'org.apache.poi.xssf.usermod-

D el.XSSFCell'

D XSSFDrawing_CLASS...

D C 'org.apache.poi.xssf.usermod-

D el.XSSFDrawing'

D zSSComment S O CLASS(*JAVA: ZCOMMENT_CLASS)

D zSSCell S O CLASS(*JAVA: ZCELL_CLASS)

D zSSComment_setAuthor...

D PR EXTPROC(*JAVA

D : ZCOMMENT_CLASS

D : 'setAuthor')

D auothor like(jstring)

D zSSCell_setCellComment...

D PR EXTPROC(*JAVA

D : ZCELL_CLASS

D : 'setCellComment')

D comment like(zSSComment)

D XSSFDrawing_createCellComment...

D PR like(zSSComment)

D EXTPROC(*JAVA

D : XSSFDrawing_CLASS

D : 'createCellComment')

D anchor like(SSClientAnchor)

D book s like(SSWorkbook)

D sheet s like(SSSheet)

D row s like(SSRow)

D NameStyle s like(SSCellStyle)


D Drawing s like(SSDrawing)

D anchor s like(HSSFClientAnchor)

D comment s like(zSSComment)

D Mycell s Like(SSCell)

D MyStr s Like(jstring)

/free

ss_begin_object_group(10000);

book = new_XSSFWorkbook();

sheet = ss_newSheet(book: 'Test');

Row = SSSheet_createRow(sheet: 3);

myCell = SSRow_createCell(row: 5);

drawing = SSSheet_createDrawingPatriarch(sheet);

anchor = new_SSClientAnchor( book:3: 5: 3: 5:

0: 0: 0: 0);

comment = XSSFDrawing_createCellComment(drawing:anchor);

MyStr = new_String('Gio.cot');

zSSComment_setAuthor(comment: MyStr ) ;

zSSCell_setCellComment(mycell : comment);

ss_save(book: IFSDIR + '/Myexcel.xlsx');

ss_end_object_group();

*inlr = *on;


but i receive this error


received a Java exception "java.lang.NoSuchMethodError:

org / apache / poi / xssf / usermodel / XSSFCell.setCellComment (Lorg /
apache / poi / x "in

Call to the "setCellComment" method with signature

"(Lorg.apache.poi.xssf.usermodel.XSSFComment;) V" in the class

"org.apache.poi.xssf.usermodel.XSSFCell".


I have done many test , but without success .. i ask to people that know
java and RPG, if they can help me .. i would be gratefull

I think that without help, i could never success in this project

Many thanks in advance anyway

Gio






As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.