Hi guys, 

I want to write data to an xlsx file on a USB stick connected to my TP900 using a VB script.

I managed to do it on a Runtime but It doesn't work on my TP900 Comfort. My script is :

I found this page that explain few things but I didn't understand 3 things :

https://support.industry.siemens.com/cs/fr/en/view/59604194

1) What's the difference between CreateObject (Excel.Application) and (FileCtl.File) ? I found (FileCtl.Application) too.

2) What should I put on delimiter and gap ? It says that it depends on country but nothing more is explained .. is there a documentation somewhere ?

3) How can I choose which line/column to write values ? I did it with a "count" variable but if my syntax is wrong, I must changed it.

For now I can't test on the physical HMI so i'll try to simulate it or something, if it's possible.

Thanks for your help,

BR

 Hi rdoliveira, 

Thanks, I understand that things are different on Windows CE on HMI. And I see now that Excel.application couldn't work because there is no Excel on HMI. I think .csv file is the best option for me now.

Do you have answers for my last question aswell ? 

3) How can I choose which line/column to write values ? I did it with a "count" variable but if my syntax is wrong, I must changed it.

I would like to write 11 variables on a single line on 11 column but before writing I need to check which line is empty (I can check colomn 1 only).

rdoliveira

Hello, the objects used in runtime or simulating are different from those used in the physical HMI device, so exactly the same code will not work in both.

This link you mentioned will work, with .txt or .csv on the physical HMI only.

good luck.

 rdoliveira,

I did something like that but then, after writing all these variable on my first line, I save the csv and close it. And for next cycle I'll open it and write again. Is the line feed done automatically ? Doesn't it just rewrite on line 1 every time ? 

Sorry I can't try it right now maybe question would be quickly answered by testing ..

rdoliveira

Hello, yes an example.

f.LinePrint(SmartTags("YourTag") & ";"_

& SmartTags("YourTag") & ";"_

& SmartTags("YourTag") & ";"_

& SmartTags("YourTag") & ";"_

& SmartTags("YourTag") & ";"_

& SmartTags("YourTag") & ";"_

& SmartTags("YourTag") & ";")

up to 11 in your case

good luck

Thanks, I'll try as soon as possible. 
Have a nice day ! 

BR

rdoliveira

Hello, use append, it will write on the next available line.

'Open file - 8 == Open a file and write to the end of the file.

f.openpath, 8

good luck.