06-27-2013 01:22 AM
Hi guys,
I've been assigned to a school project that supposingly I have to do data logging.
This project is to log down the data into a Current against Time graph every few intervals form a solar panel.
I'm very very new to labview and I have lots of question and problems that i cant find specific help online.
Basically, I want to transfer data of Current against Time in a XY graph from an excel file
but the problem is
1. I have difficulties with arranging the X and Y coordinates
2. I am only able to read the excel file after saving as a txt file, but i want it in excel format
3. I cant get the time format in labview from excel file.
I've attached what i've done so please guide me along.
The excel file is just a sample reading for me to work on
Thanks in advance!
06-27-2013 02:30 AM
Your files did not make it. Please reattach.
steve
06-27-2013 02:36 AM
wrt to the excel file. You could use a csv (its a comma delimited file) then use read/write spreadsheet vis. This is then viewable in excel and easy to manipulate in labview. You dont get the excel formating though but this isnt normally a problem. working with proper xls files is more problematic.
hope it helps
06-27-2013 03:18 AM
Oh, sorry i didnt notice. here are the files.
Hi akiel, i used to use delimited text file but i dont really understand how it works since its opened in a notepad.
06-27-2013 03:21 AM
you can either open excel then file->open -> change the filter to csv then open your file or right click on your file, select properties and change the opens with to excel.if you have the delimiter right it should open in excel as a spreadsheet where it should make a bit more sense. In notepad you should see you data with a comma between each item.
06-27-2013 10:30 PM
Alright thanks, that much i can do,
but how do I plot the graph?
Why can't I get the correct coordinates on the x and y axis.
also I cant get the time format right.
06-28-2013 03:09 AM
Hi Patrick,
I have attached the modified file. Perhaps you can modify the rest from here?
Hope it helps
Warmest regards,
Lennard.C
06-30-2013 10:53 PM
Thanks lennard,
I greatly appreciate your help, but just so happen that I'm using labview 2011 and I cannot open your attachment.
would you mind saving it in a format whereby im able to open it?
07-01-2013 12:41 AM
Hi Patrick,
Sure thing. Please find the attached file in this reply and use the .txt file which I have attached in my previous reply.
Warmest regards,
Lennard C
07-01-2013 01:12 AM
Oh, it works great! thanks a lot!
now just a tiny problem that is, i attached a notepad because i couldnt attach an excel file
so i guess there's a bit of misunderstanding, my apologies for that,
how do i modify the program so that i can display the data from an excel file?