Hi Mirco, POI 3.0.2 is very old. I would very much recommend that you update to either POI 3.7 or 3.8 beta 1.
Also look into the recent thread "Reading superscript from data-cell" to understand how to read the RichText and appreciate the difficulty of your task. Also take a look at the list archives, others have worked on similar transformations. > Thanks, > > i'll try your suggestion. > > I would renderer my Excel in PDF using FOP. I must know the width of a > column and the height of a row in centimeter respect to A4-sized sheet. > I noticed that it's possible get information width in pixels of a column or > height of a row in pixels, but the number of pixels varies depending on > screen resolution and its size in inches and then render a table on a PC is > different from another.... I need a unique reference to the measures of A4 > sheet . To say nothing of Mac vs. Windows. > > How do i get width ahd heigth of a cell in centimeter respect A4 using POI > 3.0.2? Given what you want to do, have you looked into Open Office or Libre Office? Regards, Dave > > >> From: [email protected] >> Subject: Re: getHeightInPoints() >> Date: Sat, 12 Mar 2011 13:28:16 -0800 >> To: [email protected] >> >> Hi Mirco, >>> in a for like this >>> >>> >>> >>> >>> for (int i = startRow; i <= endRow; i++) { >>> >>> HSSFRow r = sheet.getRow(i); >>> >>> System.out.println(r. getHeightInPoints()); >>> >>> } >>> >>> >>> >>> I’ve printed the heights of my rows as multiple of DefaultRowHeightInPoints >>> (15) NOT what I view on the xls file. Why? >>> >>> I attach a example of table. I use poi-3.0.2. >>> >>> >> >> The rows in your sheet are set to the default row height. The actual height >> is expanded because columns A and D have Text Wrap turned on and some cells >> have text that need to wrap. >> >> HSSFRow will return the value that the Excel file is set to, yours is set to >> the default. It is not measuring and guessing the layout with wrapping. To >> do so is difficult and might not be consistent across different versions of >> Excel like between Mac and Windows or OpenOffice. >> >> If knowing the "Auto-sized" height is important then you could follow the >> pattern of autosizing columns in the worksheet class. >> >> Regards, >> Dave >> >>> >>> >>> Thanks a lot for the help >>> >>> Bye Mirco >>> >>> >>> >>> <example.xls> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [email protected] >>> For additional commands, e-mail: [email protected] >> > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
