Fred Sanford

HI all. I'm looking for a way to open an excel file that contains a test profile. I created the code to do it with the report generation tools and it worked great on my development machine. Then I tried to impliment and realized that Excel wasn't installed on the test stands. So, I either have to buy excel for each of the 7 test stands. Change the user spreadsheet to save in .csv or .txt or get LV to open a .xls file in its native format. The 2nd option sounds easiest but the 3rd sounds like a fun challenge. Problem is that I don't know where to start. Any suggestions? Thanks, Fred Sanford

Download File:post-2745-1124273429.viDownload File:post-2745-1124273455.vi I found two solutions. The first uses the loop interator to keep track of how many points have been written to the chart. The Iteration +1 is multiplied by the XScale.Multiplier and added to the XScale.Offset to get the current position of the plot on the graph with respect to the X Axis. This works great for an instant position update with out changing the appearance of the graph. But if you don't write to the graph with every iteration of the loop then you have to keep count of non written loops and subtract them out. The 2nd is good if you want the Plot location with respect to the X-Axis when exiting the code. This method adjusts the appearance of the graph. Write a 1 to the property node XScale.ScaleFit. This will adjust the X axis to have a min and max value matching the 1st and last values of the chart history. Then Read the XScale.Maximum property to get the position of the plot with respect to the x-axis. I'll then save this value to file and recall it the next time the user opens the software to resume the test and write it to the XScale.Minimum property. Fred

You are correct. The llb I attached was written that way. So what happens when the data stops in the middle of the chart? You pull off the last value on the X axis scale and you'll start your chart on the next itteration at the wrong point. There is a chart property Called Plot x.Scale Index. The help on this says "The index of X-scale with which this plot is associated." This sounds to me like it should give you the point on the x axis associated with the last point plotted on the chart for the active plot. It Always returns zero though. So I'm still lost and Tech support has no idea either. Fred

I've got an application where the user can stop the test. The chart X-axis shows the time since the test started. If the user exits the application completely the chart loses the test time. When they try to resume the test the X-axis of the chart starts plotting at zero. I can make the chart start the X-axis at a time I specify but I can't seem to get the X axis position of the last plotted point. See the attached code snippet. Thanks, Download File:post-2745-1123788403.llb