LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how to give a name to my table so that when exported to excel automaticaly it wille has the same name in excel

Hello

Please, I use the vi attached to transfer Table 2 D (indicator) of labview to excel but I get as column names (column 1, column2 ..)
how  can i change these column names or just how to name my table way that it has a name automatically in Excel?

0 Kudos
Message 1 of 12
(3,920 Views)

Hi, 

      Get the row and column header value using the property node and build it to obatain the required output format.

Refer to the below snippet and connect the expected array output to your vi and it will work fine .Hope this helps 🙂

 

table data.png

 

Kudos Welcome 🙂

 

Certified-LabVIEW-Associate-Dev_rgb (1).jpg

 

 

Certified LabVIEW Developer
Best LabVIEW Programmer @NIDAYS 2015
Message 2 of 12
(3,910 Views)

Ok but how can i enter the name of columns?

0 Kudos
Message 3 of 12
(3,892 Views)

@Maroua wrote:

Ok but how can i enter the name of columns?


can you share a sample of data that you want. also attach the sub vi so that it will be easy to address the issue.

 

Certified-LabVIEW-Associate-Dev_rgb (1).jpg

Certified LabVIEW Developer
Best LabVIEW Programmer @NIDAYS 2015
0 Kudos
Message 4 of 12
(3,888 Views)

Here is it 🙂 sor example i can name its columns (intensite 1,intensite2...)

0 Kudos
Message 5 of 12
(3,883 Views)

I  just want to give a title to the excel table 

0 Kudos
Message 6 of 12
(3,869 Views)

@Maroua wrote:

I  just want to give a title to the excel table 


oh ok i understood. you want to give the tittle at the top and then followed by the content inside the table in a xl ...

 

is the below image is your required output???

 

excel.png

Certified LabVIEW Developer
Best LabVIEW Programmer @NIDAYS 2015
Message 7 of 12
(3,866 Views)

You didn't attach mm.vi which is the important part. Also attach an example of what is your ecpected results in Excel.

 

Ben64

0 Kudos
Message 8 of 12
(3,854 Views)

C'mon people, are we really doing this (what is clearly a) class assignment for Maroua?  "Show how to write table data in an Excel Worksheet"?  At least the assignment makes it clear we are talking about Windows with Microsoft Excel.

 

Maroua -- there are examples that come with LabVIEW!  There are examples within the Forum!  Show us that you are at least making a token effort to do your own work ...

 

Bob Schor

0 Kudos
Message 9 of 12
(3,844 Views)

Yes Exactly 🙂

0 Kudos
Message 10 of 12
(3,797 Views)