In other words the third column has time values and when read without my
code are numeric cell types are not date formatted but after running
through my code they seem to only be numeric cell types and not date
formatted.
On Wed, Feb 12, 2025 at 9:24 AM Dan S wrote:
> PJ,
> I realize it handle
Oops sorry for the typo it should read
In other words the third column has time values and when read without my
code are numeric cell types AND ARE date formatted but after running
through my code they seem to only be numeric cell types and NOT date
formatted.
On Wed, Feb 12, 2025 at 10:06 AM Dan
PJ,
I realize it handles formatted dates. My question is that it appears my
changes only handle one of the columns with dates but not the other. I
understood from you the changes I made should have handled both. Please
advise.
On Wed, Feb 12, 2025 at 6:36 AM PJ Fanning wrote:
> I have some tes
I have some tests that appear to show that that test class I
referenced earlier does handle formatted dates. I added an extra one
today.
https://github.com/pjfanning/excel-streaming-reader/commit/d26bdb3be3aac829a77ec6912bb63811c4812e06
On Wed, 12 Feb 2025 at 05:27, Dan S wrote:
>
> Thank you ve
With some System.out statements this is what the resulting sheet in the
workbook looks like. I would have thought all cell 2 columns except for row
1
should have had a value which is a date. Instead I see a negative -1 value.
row 0 cell 0 cell type STRING value transaction_id
row 0 cell 1 cell typ
PJ,
I think I found the issue and I believe this would constitute a bug but I
would like your confirmation. I narrowed down the problem to lines 237-239
in CellUtil
if (DateUtil.isCellDateFormatted(srcCell)) {
destCell.setCellValue(srcCell.getDateCellValue());
}
where in my case destCell
I logged https://bz.apache.org/bugzilla/show_bug.cgi?id=69583
On Wed, 12 Feb 2025 at 21:00, Dan S wrote:
>
> PJ,
> I think I found the issue and I believe this would constitute a bug but I
> would like your confirmation. I narrowed down the problem to lines 237-239
> in CellUtil
>
> if (DateUtil
