4/7/2020 8:45 AM | |
Joined: 7/5/2013 Last visit: 6/5/2024 Posts: 3095 Rating: (506) |
Hello RedouanR21,
please see the following FAQ: How do you open a Word, Excel or PDF document with a Comfort Panel? Regards, Frink |
Pi is exactly three! |
|
4/7/2020 9:36 AM | |
Joined: 11/5/2019 Last visit: 6/4/2024 Posts: 19 Rating: (0) |
Dear, Maybe I wasn't clear enough, but I don't want to open an excel/word on my HMI but I want to read the data of the excel file to my PLC. I followed the following link: https://support.industry.siemens.com/cs/ww/en/view/59604194 And now I'm able to read all the columns of the first row of my excel file. But now I want to go to the next row. Do you have any idea? I think I need to change the "data = fo.lineInputString " line. Kind regards!
|
Last edited by: Jen_Moderator at: 04/07/2020 10:46:09Optimized link. |
|
4/8/2020 2:11 AM | |
Joined: 7/5/2013 Last visit: 6/5/2024 Posts: 3095 Rating: (506) |
Hello RedouanR21,
with the while-wend-loop the script reads all lines until end of file (EOF) is reached. Are you using exactly the same script as in the link? - If not, you may share it here. Is any error coming up when executing the script? - You can copy the "If Err.Number <> 0"-query to the end of the script and then check the system alarm entries after executing the script. Regards, Frink |
Pi is exactly three! |
|
Follow us on