Date and time on graph ( read from Excel)

[mintonemin]

Hi everone, i m new to this forum.
I am stuck with one of my project. 
The program is that, READ the excel file and plot it on the graph.  
its a recorded Solar power output data sheets, basically i m trying to see the graph of outputs and readings at different time.
I have problem reading the time colum, i want to show as time stated on the excel on the graph.  
and it will take like 4-5 mins to plot the graph as it has 9000+ points.  any suggestion to cut down the points?
I am new to labview.

[mintonemin]

Why cant i upload my Excel file to forum 😞

[altenbach]

Certain file extensions are not allowed. It is possible that your excel file matches a pattern. You can always zip it up and attach a zip file of it.

That said, you seem to be reading a csv file which has nothing to do with excel.

Your Vi contains way too much code. It is overly complicated for such a simple task. Why do you create 3D arrays of strings?? Why do you read the eintire file over and over again just to look at a single row each time? Reading once is enough! No wonder this is slow!

[mintonemin]

I followed some ppl example from the forum.
i have no idea how to make it simple>
yahh. the file type is .csv    its like excel with lots of rolls and colums . i will try to convert it and upload once i reach home

[mintonemin]

This is the file we are trying to read.

[altenbach · Accepted solution]

Here's a very quick draft on what you could do.

Of course you could also extract the headers and place them in rings for a more natural selection. Only the parts with the controls belongs in a loop if the users should be able to select the columns dynamically. You also need to parse the time column differently. Modify as needed.

[mintonemin]

WOW ! THanks for the HELP !
It Really Cut down the time !!
Is there anyway that we could show the time  reading as it shown in the excel.
like Collum B. start from 55
Example 08/11/2012 6:50

[altenbach]

Try something like this....

[mintonemin]

LabVIEW: An input parameter is invalid. For example if the input is a path, the path might contain a character not allowed by the OS such as ? or @.
=========================
NI-488: Command requires GPIB Controller to be Controller-In-Charge.

Error 1 occurred at Scan From String (arg 1) in Step 1MOD2.vi

I got error. 😞

[altenbach]

Did ou use the same file you attached earler ( 121113-200002_UG_REP28.csv) as input. Works fine in LabVIEW 2012.

Maybe you are using a file with a different time format in that colum?

Did you modify my VI in any way, e.g. pick a different column for X?