User bio
404 bio not found
Member since Jul 25, 2017
Posts:
Replies:
Excel store date values as decimal values (or better, as flotaing poin) as dddd.tttt where ddd is the number of days since a base date (usually 1899-12-30) and tttt is: numberOfSecondsSinceMidnight / 86400, hence the value, you get is an date-object, and you have to format it according to your needs
Class DC.PyExcel Extends %RegisteredObject
{
ClassMethod Test(fn = "/home/kav/test/readtest.xlsx")
{
set exl=##class(%SYS.Python).Import("openpyxl")
set wbk=exl."load_workbook"(fn)
set sht=wbk.active
for row=1,2,3 {
for col=1:1:3 {
set cel=sht.cell(row,col)
set typ=cel."data_type"
set val=cel.value
write ?col-1*15,$case(typ, "s":val, "n":$fn(val,",",2), "d":val.strftime("%a, %d.%m.%Y"), :"")
}
write !
}
}
}
I'm just curious, what do you get, if you type write $view(-1,$job) in the output window of Studio?
See my screenshot, red=my input, yellow=Studio output
Certifications & Credly badges:
Julius has no Certifications & Credly badges yet.
Global Masters badges:







Followers:
Following:
Julius has not followed anybody yet.
Could you please run the following commands in a terminal session:
write $zv set exl=##class(%SYS.Python).Import("openpyxl") set wbk=exl."load_workbook"( "your path_and_filename.xlsx" ) set sht=wbk.active set cel=sht.cell(row,col) // ROW and COL should point to a date-cell write cel."data_type" write cel.value.strftime("%d.%m.%Y")Please post a screenshot here, even if you get some kind of error