Hi,
Whenever I open my data table using JSL, the first row (except for the first cell) is deleted and replaced with dots. I was just wondering why as when I open it manually it seems to work fine. Any suggestions would be appreciated.
You really need to provide the data table, and the script you are using.......there are just so many items that can be in the data table, it is impossible to even guess at what is going on.
So, the above is an example of the excel file which I open in JMP using JSL. When I open it using my script, it turns the second row (all cells after date) to dots. I think it may be to do with how it's imported. Do I need to specify how to open the table in my script, e.g. using best guess etc.? Also, in my script I specified that the data starts on row 2, I'm thinking that might have something to do with it? As a sidenote, this isn't the excel file I originally tested on, but an example of it. The columns would otherwise be filled with data.
Your data starts on row 3, not row 2. So you need to change that, and your data should read in correctly.
