Databases
StackOverflow2013
Postsdbo
POHaving trouble with WritableSheet.addImage(WritableImage)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHaving trouble with WritableSheet.addImage(WritableImage)
    primarykey
    data
    text
    <p>I'm using jxl (JExcelApi) to save an Excel file, by copying an existing Excel file to a new file and modifying the copy. I've had great success in doing so, except for one issue. </p> <p>I'm trying to save two different PNG images at two different locations in the Excel sheet. I call the following function two successive times (once for each image), with a different row index and a different pngFile each time:</p> <pre><code>private static void putPngInExcel(File pngFile, int column, int row, int widthInColumns, int heightInRows, WritableSheet worksheet) { WritableImage image = new WritableImage(column, row, widthInColumns, heightInRows, pngFile); worksheet.addImage(image); } </code></pre> <p>Basically, it seems that if I call the above function twice, only the second call does what it should, ie. only the second PNG image appears in the Excel sheet, not the first PNG image. Maybe I'm doing something silly, but I'm wondering if anyone is aware of a known jxl issue in this regard?</p> <p>I'm not seeing any uncaught Exceptions being thrown. </p> <p>I've confirmed that valid PNG Files are being passed to the above function both times it is executed. </p> <p>I've swapped which PNG File goes to each call of the above function, and confirmed that the PNG associated with the second function call is always the one that gets added to the Excel sheet successfully. </p> <p>I've deleted one of the calls to the above function, leaving one call, and confirmed that I do see the relevant PNG image on the Excel sheet as I should (I tried passing different combinations of PNG files and row/column indices and it worked fine for one call to the above function). </p> <p>I haven't tried more than two calls, but it looks like only the most recent call to the above function works. </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRob K
    1. USRob K
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POHaving trouble with WritableSheet.addImage(WritableImage)
      1. This table or related slice is empty.
      1. VTUndeletion
    1. COAfter making some 'unrelated' changes, I just saw it work correctly at least once. However, I'm not sure why it suddenly worked, and I can't make it work again. I'll continue debugging and looking through my code.
      singulars
      1. POHaving trouble with WritableSheet.addImage(WritableImage)
      1. USRob K
    2. COThis just keeps getting more frustrating and more interesting at the same time. I tried calling the function 4 successive times, with a different PNG file each time (but always a valid file), and a different row/column location each time...the first call didn't add an image to the Excel sheet but the following 3 calls DID correctly! So, I was wrong when I said "it looks like only the most recent call to the above function works". Instead, it looks like only the first call to that function fails when there are multiple calls, but if there is just one call to that function, it works!
      singulars
      1. POHaving trouble with WritableSheet.addImage(WritableImage)
      1. USRob K
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload