java.lang.NoClassDefFoundError: Failed resolution of: Ljava/awt/Dimension

[fribeau]

I'm trying to insert an image xlsx but I end up with the following error:

Failed resolution of: Ljava/awt/Dimension;
E/flutter (25638): 	at org.apache.poi.ss.util.ImageUtils.getImageDimension(ImageUtils.java:63)
E/flutter (25638): 	at org.apache.poi.ss.util.ImageUtils.setPreferredSize(ImageUtils.java:146)
E/flutter (25638): 	at org.apache.poi.xssf.usermodel.XSSFPicture.getPreferredSize(XSSFPicture.java:221)
E/flutter (25638): 	at org.apache.poi.xssf.usermodel.XSSFPicture.resize(XSSFPicture.java:180)
E/flutter (25638): 	at org.apache.poi.xssf.usermodel.XSSFPicture.resize(XSSFPicture.java:155)
E/flutter (25638): 	at org.apache.poi.xssf.usermodel.XSSFPicture.resize(XSSFPicture.java:146)

This is my code (in Kotlin) :

val workbook = XSSFWorkbook()

val outputStream = FileOutputStream(File(path, "/poi.xlsx"))
val stream = FileInputStream(File(path, "/img.jpg"))

val helper = workbook.getCreationHelper()
val sheet = workbook.createSheet("Sheet 1")
val drawing = sheet.createDrawingPatriarch()

val anchor = helper.createClientAnchor();
anchor.setAnchorType( ClientAnchor.AnchorType.MOVE_AND_RESIZE )
val pictureIndex = workbook.addPicture(IOUtils.toByteArray(stream), Workbook.PICTURE_TYPE_JPEG);

anchor.setCol1( 0 );
anchor.setRow1( 2);
anchor.setRow2( 3 );
anchor.setCol2( 1 );
val pict = drawing.createPicture( anchor, pictureIndex );
pict.resize();

workbook.write(outputStream)
outputStream.close()

[centic9]

Android does not provide the java.awt.* packages and also actively refuses if you try to add such classes, this means any part of Apache POI which uses java.awt.* stuff will currently fail this way.

I did some workaround with shading for java.awt.Color before, you can try to do the same for Dimension, see https://github.com/centic9/poi-on-android/blob/master/poishadow/build.gradle#L39 and https://github.com/centic9/poi-on-android/tree/master/poishadow/src/main/java/org/apache/poi/java/awt

[LePat]

Here is an example how I added some java.awt classes for my personal use: LePat@d38372b

It can be done for any java.awt classes, I just needed to get cell size depending on text size (Rectagle2D.getWidth with comment in french...).

[centic9]

Changes in #110 added some more classes from java.awt. This should now provide at least java.awt.Dimension and a few others.

Please consider sending PRs if you add other classes and think they "good enough" for including here.