why Excel clear with new data?/ how bundle?

[behzad1]

Hello friends

I have two questions. may u help me?

I write a row data in a row of Excel fle. in the other day, I want run my program and produce new data and save in another row that I can define for block(block get row and column for save). now, when I save new data in a new row, previous data of excel file, be clear! is any problem to do it? may u guide me?

and next question, I have 4 data, and I use bundle(like attached picture), but it doesnt convert to cluster. is any problem to do it? can u help me?

tnx

Best Reagards

[RavensFan]

The first question you already asked here  http://forums.ni.com/t5/LabVIEW/why-24-input-number-doesnt-save/m-p/3035979#M866106.

So continue that conversation there.

The second question, you used Bundle by Name which means you have to wire in a cluster to define the elements and names.  If you just want to bundle stuff together, use Bundle Cluster.

[behzad1]

Hi Ravens Fan

about first question, really both questions are same ? my previous question was about saving sada in one program, but my new question is about saving data in seperate run and saving problem in an Excel file. have u any idea to solve this problem? or how these two problem are same?

second- I used Bundle Cluster too, but problem dose not solve. did test this until now?

tnx

Best regards

[P@Anand]

Are you using the "Write To Spreadsheet.vi" to write to the excel file?

If you know the cluster type then don't use the "Bundle by name" primitive, instead use "Bundle" primitive. From the code what you shown you are using the "Bundle by name". Please attach your code for a better solution (attach in 2011 version please).

[behzad1]

Hi P@Anand

tnx a lot, and Im glad to meet u again.

I attached a picture of my question. I am using Appended table to report and save report to file (both in report generator) to do it. is not suitable?

I have not 2011 version. 2013 is not good for u to attached my code?

 actually, I read an excel file and I find number of last row. I want use of this number as input of my  " Appended table to report" block to write last row to a new excel file. as u can see, Appended table to report block, has an input for input row, called MS office paran (u can detect it as a pink input). but it seems it get cluster as an input(am i wrong?). I am trying to make a cluster with some constant number(at the future I will generate this number in my program) to import that row number to my program. I used bundle, but I couldnt make a cluster. can u help me?

Best Regards.

[P@Anand]

Is there any reason why are you using MS excel format? It would be rather simple if you can just make use of a text file and open it with MS office Excel. I am just trying to make things simple for you.
BTW: I only have 2012 version in my PC so I cannot open VIs in 2013. You can save the VI for previous version by navigating to File>Save for Previous version> Select version.

[behzad1]

I attached it.

actually, I thing excel is more regular but in addition, I have some calculation in my excel. when save new data in excel, some calculation perform(like averaging in all of previous data with new data), and new result add to program again.

Best Reagards

[P@Anand]

If that is the case I would just read all the data in LabVIEW and find the Average or whatever calculation needs to be done. Then I would write the data back to the file along with the average. If you really want to generate a report with formatting and other stuffs then go for the RG toolkit.

Attached is the code shows you how you can bundle the data to the MS office parameter cluster. 

[behzad1]

tnx a lot P@Anand, your responses really help me. but, I coulnd find MS Office parameters block. is ir in cluster box?

do u mean work with excel is very difficult? because may, my data box be very great.

Best Regards.

[P@Anand]

Right click the MS Office Parameters and create a control out of it.
No. Excel is a great tool and RG tool kit makes is a piece of cake, the point is "do you really need it?".
As I said for generating reports I would go for the report generation tool kit without a second opinion, but for storing data I would think.