excel report

[NitzZ]

Hello everyone,

                          I am using Labview 8.0 and I have made a small program using it.. Now i want to save the output values say numeric and alphabetic values into an excel sheet.. I have tried using the MS Report generation VI and also the Excel report generation VIs from the VI library.. What exactly I am not being able to do is , Configure the excel sheet... In the example they have used a well formatted excel template.. Can anyone tell me how to configure and format an excel template in such a manner that i can input an array of 50 values with row headers..

Regards,

Nitzy.. 

[NitzZ]

please anyone drop some solutions for this... I hope this wont be a tough job for the experts here.. Consider the troubles faced by the untrained beginners...

[smercurio_fc]

It's not clear what it is that you're asking. If you're asking about how to make Excel templates, then this is the wrong place for this, as that's an Excel question, and you can find that information in the Excel help or on an Excel forum. If you're asking about how to use templates with the Report Generation VIs, then what is the specific problem that you're having?

[Gak]

hi Nitzy,

See this example. You will get an idea how to write in excel sheet. You can use for loop to add 50 or more elemnts.

You can define column and row as well.

Best luck

[NitzZ]

Hello,

           My doubt is not fully about making an excel template.. What i want to do is to make an excel template and genearte a set of values on it.. I am using the report generation VI for calling the made template but The template is not taking my values as desired.. And also it gives some errors... I saw the examples in the VI Library and was trying to do exactly as they did.. The Library VI works perfect .. But i am not even being to edit that VI to make my report..

Regards,

Nitzy... 

Message Edited by Nitzy on 08-31-2009 12:17 AM

[NitzZ]

Hi gaurav,

               Your VI is in the latest versions of LV i suppose.. Could you please send me something in LV 8.0 format or even an Image of the block diagram will do along with the excel sheet..

regards,

nitzy.. 

[always]

from the output panel in the blockdiagram  take write to LVM.It will ask for a path that is the path of the file where u want to save the data. From the properties you can give different options like how to save the file.After executing the prg, the data will be saved to the above location.Then u can open that particular file using excel sheet.

Hope this will meet ur requirement