how to add images in HSSFCell in apache POI?

Garudadwajan :

How to add Image in different different HSSFCell object in poi ?

I have written some code which is adding image but problem is, the cell were I added last image, That cell only showing image other than that no other cells are showing images ...

appreciate your help ...

My Code is

while(rs.next()){

    HSSFCell cell = getHSSFCell(sheet, rowNo, cellNo);

    cell.setCellValue(new HSSFRichTextString(rs.getString("TEST_STEP_DETAILS")) );
    cell.setCellStyle(style);

    String annotate = rs.getString("ANNOTATE");

    if(annotate != null){                       
        int index = getPicIndex(wb);
        HSSFPatriarch patriarch=sheet.createDrawingPatriarch();
        HSSFClientAnchor anchor = new HSSFClientAnchor(400,10,655,200,(short)cellNo,(rowNo+1),(short)cellNo,(rowNo+1));
        anchor.setAnchorType(1);
        patriarch.createPicture(anchor, index);                                         
    }
    cellNo++;
}

getPicIndex METHOD :-

public static int getPicIndex(HSSFWorkbook wb){
    int index = -1;
    try {
        byte[] picData = null;
        File pic = new File( "C:\\pdf\\logo.jpg" );
        long length = pic.length(  );
        picData = new byte[ ( int ) length ];
        FileInputStream picIn = new FileInputStream( pic );
        picIn.read( picData );
        index = wb.addPicture( picData, HSSFWorkbook.PICTURE_TYPE_JPEG );
    } catch (IOException e) {
        e.printStackTrace();
    }  catch (Exception e) {
        e.printStackTrace();
    } 
    return index;
}
Christian :

i hope you found the solution yourself. if not:
the problem is that you create for every image a new partiarch. HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
you should create only one patriarch instance and use its createPicture method for all images.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

How do I ADD bullet points to a word document using Apache POI in Java

How can i replace HSSFCell.CELL_TYPE_STRING in POI 4.1

How to add table heading drop-down with Apache Poi

Apache poi add label in excel chart

How to add image with border into table cell in Word with Apache POI?

How to add an altChunk element to a XWPFDocument using Apache POI

How to add a hyperlink to the footer of a XWPFDocument using Apache POI?

Apache Poi - Java-: How to add text containing blank lines as separate paragraphs to a Word document using Apache POI?

How to add Data validation to entire column of an excel sheet using apache poi in java?

apache poi add table in word document

Apache POI Add Column Label

How to add header column in excel using Java Apache POI?

How to Add image to image placeholder added in pptx using Apache POI API?

How to add comment by apache poi

How to reuse Fonts in Apache POI?

Apache poi putting hyperlink in images

How to add column field in pivottable using Apache POI

How can add different colour for each worksheet in excel using Apache POI

how to add comment to a table of word by apache poi

How to add a hyperlink to image in a Word document using Apache POI?

How to add new sheets to existing excel workbook using apache POI and PrimeFaces

How to use Apache POI in OSGi

How to add superscript text using Apache POI

Is it possible to add something extra to HSSFCell?

how to add images side by side word document using apache poi

How to Add negative value for DataBar in apache poi?

How to add columns to an existing large excel file using SXSSF Apache POI?

How to add text to a .docx file using Apache POI in Java

How to add number list in ppt using apache poi?

TOP Ranking

  1. 1

    Failed to listen on localhost:8000 (reason: Cannot assign requested address)

  2. 2

    Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

  3. 3

    How to import an asset in swift using Bundle.main.path() in a react-native native module

  4. 4

    pump.io port in URL

  5. 5

    Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

  6. 6

    BigQuery - concatenate ignoring NULL

  7. 7

    ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

  8. 8

    ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

  9. 9

    Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

  10. 10

    How to remove the extra space from right in a webview?

  11. 11

    java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

  12. 12

    Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

  13. 13

    flutter: dropdown item programmatically unselect problem

  14. 14

    How to use merge windows unallocated space into Ubuntu using GParted?

  15. 15

    Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

  16. 16

    Nuget add packages gives access denied errors

  17. 17

    Svchost high CPU from Microsoft.BingWeather app errors

  18. 18

    Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

  19. 19

    12.04.3--- Dconf Editor won't show com>canonical>unity option

  20. 20

    Any way to remove trailing whitespace *FOR EDITED* lines in Eclipse [for Java]?

  21. 21

    maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

HotTag

Archive