Hello , Please How can I transfer a cluster(formed of numeric tables) in labview to excel

So where is ExcelTable, the VI that you (apparently) are using to write your data into Excel? I have a suggestion that should help you a lot with your LabVIEW code -- try to make your Block Diagrams a lot smaller (make them fit onto a single screen). To do this, you will have to start "modularizing" your code, making sub-VIs that do common tasks and sprinkling them wherever they are needed. This gets rid of a lot of clutter, a lot of wires, and help you "see the Forest for the Trees". Don't be afraid to extend this hierarchy to the data -- instead of having 10 or 11 Ecart Type xxx, make a single Cluster (and always make a TypeDef for your Clusters, and use the TypeDef for cluster initialization, bundling, etc). So in your earlier Indexation, I thought you were creating a single Cluster that had, as its elements, the Columns of your Excel Worksheet, with each element being an array that would constitute the Rows of the Worksheet. Is that the same thing you are using in current version of Indexation? [It doesn't seem to be -- you seem to be calling the mysterious ExcelTable with each Array, suggesting you are trying to write a column at a time, instead of an entire Worksheet]. Again, without seeing your code, it is difficult to provide helpful advice. I presume that ExcelTable has defined Inputs and Outputs, and is considerably smaller than Indexation (how do you manage to find all of the Code and Controls with such a huge VI? Do you have 4 large monitors driven by a single Video Controller?). A question would be what do you want to do? I would suggest that it makes sense to gather all of the data to be written to Excel at one time, perhaps as the Cluster of Arrays that I thought you were using in your earlier code, and pass this to a sub-VI, perhaps with the path and filename for the Excel file you want to create. Is that what you have done with ExcelTable? If not, why don't you modify the input to this VI to use something like this, and post what you've tried to do so that I can help you solve your coding problem. Bob Schor

LabVIEW

labview

Solved!

Here is the help page on typedefs

http://zone.ni.com/reference/en-XX/help/371361H-01/lvhowto/creating_type_defs/

Message 51 of 51

(376 Views)

LabVIEW

labview

Re: labview