Announcement

Collapse
No announcement yet.

Log data to excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Log data to excel

    Hello

    I would like to log my temp and humidity data to an excel file on a 5 minute interval.

    This data is ued for a web page that is created with excel as well as referance for past performance.

    Any ideas or suggestions as to how I handle this.

    Thanks

    #2
    You can do this by using the Excel Application object. Here's the reference.

    http://msdn.microsoft.com/library/de...tionobject.asp

    You can also write to a delimited file and import it into excel. That would be a bit easier.

    Comment


      #3
      If you want it in native .xls format then Excel vba macro can be used to query the database to add new lines each time the excel file is opened. A similar function could be done with a script that references the Excel COM object and the data file, but this may have a conflict if the web page and script try to use the same file at the same time.

      It is very easy to link Access database to a file so as the file is updated the database sees the update. I'm not an excel wiz, but I do not think you can go the other direction and Excel data can only be imported rather than linked.

      Comment


        #4
        I posted a script to read a value in this thread:

        http://board.homeseer.com/showthread...ighlight=excel
        -Rupp
        sigpic

        Comment


          #5
          what about the db

          Hi again.

          Lots of good info. The learning curve is looking good.

          My question is about the db access. Will I confilct with the hs system if I access the db while it is running and potentialy reading from it while the hs system needs it.

          I know database programs are very picky about access and locking tables and such (lots of bitter experiance).

          Comment

          Working...
          X