Khalis Posted March 5, 2009 Share Posted March 5, 2009 Currently, I'm trying to save several data in excel doc (.csv). What I'm trying to do is to log the data in excel for an hour example with specific interval between two data is 10 secs.But what had happened was the time in excel table seemed decreasing starting the time I log until the process stopped..For example if the data1 is logged at 8.41 AM and the data2 should be logged at 8.42 AM but in excel, the time value was wrote at 8.40 AM.Below is the coding that I used to log the data: if (component.hourCom.strContents == "1 Hour") Export.Int10s1.strFileName = FormatDateTime("c:\PP\Auto\pH\1h10s_%y%m%d_%H%M.csv",SysTime()) component.dir.strExpression = "Export.Int10s1.strFileName" Export.Int10s1.Start() delay (3600) butLog = 0 staLog = 0 starLog = 0 Export.Int10s1.Stop() endseq(autolog1) endif Link to comment Share on other sites More sharing options...
AzeoTech Posted March 5, 2009 Share Posted March 5, 2009 Code looks ok, but you don't need to Stop() the export set. It will stop automatically at the end. However, you could have other problems, so I'd need to see the whole .ctl file. Either post or email it to us. Link to comment Share on other sites More sharing options...
Khalis Posted March 7, 2009 Author Share Posted March 7, 2009 Hi, I have included the attachment with this post. It is not the original that I am working on at this moment but the idea is the same. The idea is I want to log the data from the selected channels. So as we knew, some readings that we got need to be converted or calculated first before we can log it into desired file format. Before this, I tried to use logging method to log and it seemed working fine. But the problem when use logging method is it cannot log calculated data (what I seen). So, I tried to use export method because it has a function that allow us to log calculated data. Maybe because I test_log.ctl Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.