Flower Posted January 20, 2010 Report Share Posted January 20, 2010 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 Quote Link to comment
ShaunR Posted January 22, 2010 Report Share Posted January 22, 2010 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 Append your data to a file with the date as the file name (e.g 2010-01-10.csv). Then when the new day starts, a new file will be created. Quote Link to comment
Flower Posted January 24, 2010 Author Report Share Posted January 24, 2010 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 Hello, can you please guide me how I can Append my data to a file with the date as the file name (e.g 2010-01-10.csv)? Thanks Quote Link to comment
ShaunR Posted January 24, 2010 Report Share Posted January 24, 2010 Hello, can you please guide me how I can Append my data to a file with the date as the file name (e.g 2010-01-10.csv)? Thanks Quote Link to comment
Flower Posted January 24, 2010 Author Report Share Posted January 24, 2010 Hello, can you please guide me how I can Append my data to a file with the date as the file name (e.g 2010-01-10.csv)? Thanks Quote Link to comment
Flower Posted January 24, 2010 Author Report Share Posted January 24, 2010 r3.vir3.viHello, Thanks for your fantastic Solution but still I have one problem: I have used create data string.vi inorder to display the recorded data with its corrsponding date and time into the Excel file however it displays the recorded data with its corrsponding date and time in one cell of the Excel file; can you please guide me how I can make them(recorded data,corresponding data and corrsponding time) in different cells of the Excel? <I have attached my program > Looking forward to recieving from You Quote Link to comment
Cat Posted January 27, 2010 Report Share Posted January 27, 2010 Trying to interact with Excel is not necessarily the easiest thing to do in LabVIEW. You might want to just use the "Write to Text File" in LV to save your data in a CSV (comma separated value) file, so it would look like: time1, data1 time2, data2 time3, data3 etc... This type of file can still be read by Excel, and you don't have all the problems of trying to format in Excel. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.