topic Re: Ilogic Get date from excel to Custom Property in Inventor Programming Forum

Ilogic Get date from excel to Custom Property

j.romo — Thu, 05 Jul 2018 07:56:59 GMT

We have a Project Excel sheet that goves us the delivery time to finish a Project that our PM fills with some dates for each Project we are currently developing.

I have the next code but the date on the spreadsheet comes back as numbers in the custom Iproperty,

the custom iprop does not get any value if I set it as Date, and gives me random numbers if I set it up as Text.

We search the row by Project name

SyntaxEditor Code Snippet

Dim oPROJ As String
Dim oDATE As String

oPROJ = iProperties.Value("Project", "Project")
'oDATE = iProperties.Value("Custom", "DEADLINE")

GoExcel.Open("X:\ILOGIC\PROJECT_TEST.xlsx", "CURRENT")

For rowPR = 3 To 100

If (GoExcel.CellValue("A" & rowPR) = oPROJ) Then

 oDATE =  GoExcel.CellValue("B" & rowPR)

iProperties.Value("Custom", "DEADLINE")= oDATE


Exit For

End If

Next
GoExcel.Save
GoExcel.Close

Re: Ilogic Get date from excel to Custom Property

dgreatice — Thu, 05 Jul 2018 08:19:07 GMT

Change this line :

iProperties.Value("Custom", "DEADLINE")= Date.FromOADate(oDATE)

Re: Ilogic Get date from excel to Custom Property

j.romo — Thu, 05 Jul 2018 08:49:07 GMT

Hello dgreatice

Didnt work, even changing the custom property to date or text.

found a work around , In the Spreadsheet the cells have to be as text for the code to work.

Thanks a lot

Re: Ilogic Get date from excel to Custom Property

dgreatice — Thu, 05 Jul 2018 11:42:09 GMT

Hi,

I create that code with date type in data excel, not a text type. and my iProperties is date value, and its work for me.

Re: Ilogic Get date from excel to Custom Property

j.romo — Thu, 05 Jul 2018 12:06:23 GMT

Thats weird

I can Share the IPT file and the XLSX file

if you want to take a look?

Re: Ilogic Get date from excel to Custom Property

dgreatice — Fri, 06 Jul 2018 02:45:08 GMT

Yes, if no confidential.