01-20-2010 07:07 AM
Hello
I wrote a program to record the output voltage from a solar panal into an Excel file continously; however this will save the data into the Excel file in one column but I want it after finishing one day, it saves the recorded data into another column or another Excel file. Please help me in this manner if possible.
< I used Create data string.vi, write characters to file.vi and multiple time delay match.vi to record the data into Excel file>
Looking forward to hearing from You,
M-H
01-20-2010 07:22 AM
Hi Monireh,
couldn't you just observe the date and then write to a new file if the date changes?
01-20-2010 09:50 AM
If you are using Write Characters to File, you are not creating an Excel file. You are creating a text file. If you want to keep doing this, you would have to read in the old file into a 2D array, modify it by adding a new column to the array, and write it back.
If you truly want to write Excel, then you can use the Report Generation Toolkit or search the forum for Excel. There's thousands of posts on using ActiveX to write to Excel.