B4J Question XLReader and PoiCell

[peacemaker]

Hi, All

For getting Hyperlinks the XLReader is required.
For getting correct date (time) from a cell - PoiCell is required for PoiGetFormattedCellValue sub.

How to combine ? Any way to get PoiCell in XLReaderResult like in XLSheetWriter ? (and other PoiXXX objects also)

 

[Erel]

For getting correct date (time) from a cell

I work with date fields often and never needed such code.

 

[peacemaker]

I see the cell with visible "10:37", but it's got as

-2209051380000​

How to get it as looks ?

10:37:0​

 

[Erel]

I see. It is a time field. One option is to convert it to a text field: https://www.b4x.com/android/forum/t...-columns-to-be-stored-as-text.107440/#content

If it isn't possible then use XLSheetWriter.GetCell + the code in that link to access those fields.

 

[peacemaker]

Thanks, Erel, seems, will try to use second variant.
But for future, maybe is there use to make some extra conversion tool-sub in XLReaderResult or XLUtils to get PoiCell\PoiRow objects ?
Maybe via JavaObjects...

 

[peacemaker]

Ha, tried to get this time value via PoiWorkbook, PoiSheet, PoiRow, PoiCell and via this PoiGetFormattedCellValue sub....
and got the same tick number