Question
· 2 hr ago

Object Script - Phyton -> Excel Import Error - Date Format in Excel File

Hello, 

I am using Object Script with Phyton to import an Excel File. 

Please see the below code. Its works fine for all text and numeric Columns. But by importing a DATE formated column in Excel (birthdate) , Iam facing the below issue as result:

22@%SYS.Python

 

 

My question: How can i import date formated Excel Data in Object Script?

 

Thanks a lot in advance

 

Maikel

       Set tSC = $$$OK
        Set tData = ##class(%SYS.Python).Import("openpyxl")         Try 
        {
            /// Pfad zur Excel-Datei
            Set filePath = pInput.Filename
            $$$TRACE(filePath)
           
            Set pyWorkbook = tData."load_workbook"(pInput.Filename)
            Set pySheet = pyWorkbook.active
            Set maxRow = pySheet."max_row"
            ........

            Set MolDatum = pySheet.cell(i,y) m

Product version: IRIS 2025.3
Discussion (0)1
Log in or sign up to continue