I am trying to write a JSL script that will import data from Excel. One column of the worksheet I want to import has a "vlookup" function, that looks up a date from another sheet. For some reason, when I import this worksheet, the date column (which contains the vlookup in Excel) comes up blank in JMP.
I tried copying the worksheet and doing "paste special values" into a new Excel file, and in that case the new sheet (with just values and no formulae) imports fine, and shows the dates I want.
Is there any way to get JSL to import the date values instead of just leaving the column totally blank?