B4J Question XLReader and PoiCell

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Dec 2, 2022

• #2

peacemaker said:

For getting correct date (time) from a cell

Click to expand...

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

 

Upvote 0

peacemaker

Expert

Licensed User

Longtime User

• Dec 2, 2022

• #3

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

-2209051380000​

How to get it as looks ?

10:37:0​

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Dec 2, 2022

• #4

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.

 

Upvote 0

peacemaker

Expert

Licensed User

Longtime User

• Dec 2, 2022

• #5

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...

 

Upvote 0

peacemaker

Expert

Licensed User

Longtime User

• Dec 2, 2022

• #6

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

 

Upvote 0