Duranthas
Lifetime Supporting Member
I have quite a bit of data in an excel file that I'm wanting to display pieces of throughout various windows in Windowviewer. I know that I can save the .xls to a .csv but the part I'm not understanding at all is when using the script funtion in WW called filereadfields to send that data to a message, I can't get the formatting correct. For instance I used a Window script for Station 1 Tooling window that reads on true
filereadfields "c:\temp\tools.csv", X, "Tool_List_1", 6
X is the part that's confusing me. I understand that the "c:\temp\tools.csv" is where the file to be read is located, the X is where in the file to look, the "Tool_List_1" is the Memory Message tagname to put it into, and the 6 is how many sequential tagnames to continue this.
If I open the CSV in Excel and see that the data I want is in cell B5, how do I know what to enter into X? I played around with the file and the X number, but I'm not really seeing anything obvious. Can anyone shed some light on this for me?
I hope this makes sense because I've got about 6 people in the office talking to me (some at the same time).
filereadfields "c:\temp\tools.csv", X, "Tool_List_1", 6
X is the part that's confusing me. I understand that the "c:\temp\tools.csv" is where the file to be read is located, the X is where in the file to look, the "Tool_List_1" is the Memory Message tagname to put it into, and the 6 is how many sequential tagnames to continue this.
If I open the CSV in Excel and see that the data I want is in cell B5, how do I know what to enter into X? I played around with the file and the X number, but I'm not really seeing anything obvious. Can anyone shed some light on this for me?
I hope this makes sense because I've got about 6 people in the office talking to me (some at the same time).