excel export

[snuk]

How can I export in excel the date and time from the following blocks

 

[parthabe]

You need to have the Report Generation toolkit for MS Office or you need to use the ActiveX functions [Properties & Methods] for Excel.

See the Excel thread in the Breakpoint forums.

[snuk]

I don;t have that toolkit but...when I was looking for it I found some guys saying that .txt files can be used... For me txt will be also very good because there are some people that are going to use my application that might not have office... so... how about .txt files? What do I need for that?

[MikeS81]

Hi snuk,

you can use the "Write to spreadsheet file" function. Before using this, you can transform your data time to string. Use the "Format Date/Time String" function for it.

Mike

[snuk]

ok but...it just ask me every time for a new file... I have a motion sensor connected to that True wire so... I want the notepad file to continuously update!

like a STATUS LOG FILE.

[MikeS81]

Hi snuk,

you have to select a path in your path control. It should be a path to a file. Connect a true to the "append to file" input.

Mike

[muks]

Just a try. I tried to create a excel file and write this timestamp data using "write to text file". And it is creating.

[muks]

[muks]

---

I don;t have that toolkit but...when I was looking for it I found some guys saying that .txt files can be used... For me txt will be also very good because there are some people that are going to use my application that might not have office... so... how about .txt files? What do I need for that?

---

Just replace the .xls to .txt. But remember each time the loop executes a file will be created. You have been warned.

Use a append function to write the data instead.

[snuk]

I've created my own exemple and then your exemple as you've done it... isn't there a posibility to make it get to the next row in the SAME FILE? 😄 just a question... it's good as it is but...just wondering!