Hello Community!
I am trying to do a script to automatically import an Excel file and create some graphs. I have a file with a column of date (dd Mon yyyy) which is important as it will be my X axis (Excel file attached).
If I go directly from the Excel file to JMP using the add-on button, it’s working perfectly well, I get my datatable with my Date column properly formatted.
But I want to script it using the Workflow (I'm using JMP17 on Windows), so I'd like to go from JMP, Open the wizard and open my file. But then, my dates are imported as Numbers (44937), and if I change the attributes to get a date, I only have 1904 ...
How could I script the data treatment of this column?
