Subscribe Bookmark RSS Feed

Importing Excel formulae as values (dates)?

markschwab

Community Trekker

Joined:

Apr 15, 2016

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?

1 REPLY
uday_guntupalli

Community Trekker

Joined:

Sep 15, 2014

@markschwab: Can you please provide sample files so people in the community can replicate the issue on their end ?
Best
Uday