Jump to content

Recording into an Excel file day by day


Recommended Posts

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

Link to comment

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.

Link to comment

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

Link to comment

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

Link to comment

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.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.