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 t
Never mind.
I've investigate this more and found out the row with only 6 columns was
somehow corrupted.
Greg
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Coumn-miscount-tp3425833p3425886.html
Sent from the POI - User mailing list archive at Nabble.com.
-
I have the excel file with well over 4500 rows and just 7 columns.
When I read it at row 3524 the count of columns changes to just 6.
I don't understand why? It's always 7. I've noticed that my third column at
that row
doesn't have anything in there but I'm checking for the blank cells and if
ther
thank you very much now it works
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/ShowInPane-with-rows-locked-tp3423129p3425124.html
Sent from the POI - User mailing list archive at Nabble.com.
--
Hi,
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 DefaultRowHeightInPo
I solved my problem. I created just one jar with a tool called Build Fat Jar.
(It's actually an Eclipse plug-in and it works great.)
FYI for those looking for the same answers as me, here is what I did:
I created a simple local Java project (with Eclipse) that takes an .xlsx
file and reads it into
I think that I may have the problem cracked now and it proved to be a
combination of a few different things. Anyway, take a look at the code, give
it a through test and let me know if it works for you. It performed
successfully against a file containing a few tricky tests - including one
where I su
HSSFRichTextString str =
workbook.getSheetAt(1).getRow(3).getCell(0).getRichStringCellValue();
for(int i = 0; i < str.numFormattingRuns(); i++){
short fontIndex = str.getFontOfFormattingRun(i);
HSSFFont font = wb.getFontAt(fontIndex);
int colorInd
Only if the cell contains text, if it contains a number or a date for
example, then it is not possible to do this using the API. The key is that
you need to recover a rich text string object from the cell - and the api
will throw an exception if you call the relevenat method on a numeric cell
for e
I did some detailed digging around last night and came across and interesting
snippet of information in the javadoc. The format for the first formatting
run will not be applied to the run itself but to the cell - at least that is
the very strong hint given by the javadoc. So we will always see one
10 matches
Mail list logo
