LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Report generation: Using only bottom border cell in Excel

I'm trying to write a report to Excel. for each 2 rows I want the cells to have a bottom border.

With the VI " Excel set Cell Color and Border VI" I have 2 options, using inside border and outside border.

Outside border seems to be the top and bottom border. However , I can only put them both on and off, I can't use them seperatly.

 

Is there a way of telling this VI that I only want to have a bottom border?

 

Idealy I would like to select a cellstyle like one can do in Excel:

celstyles.png

0 Kudos
Message 1 of 3
(2,913 Views)

Hello kev91,

 

Can you give me some more information about the software versions you're using?

Is this LabVIEW 2012?

Which version of Excel are you using?

 

Can you share an example of how the final Excel-file should look like?

It would also be useful to see what you already have written in LabVIEW so that we can just change/modify that code.

 

Kind Regards,
Thierry C - CLA, CTA - Senior R&D Engineer (Former Support Engineer) - National Instruments
If someone helped you, let them know. Mark as solved and/or give a kudo. 😉
0 Kudos
Message 2 of 3
(2,867 Views)

hello kev91,

 

Any update from your side?

Kind Regards,
Thierry C - CLA, CTA - Senior R&D Engineer (Former Support Engineer) - National Instruments
If someone helped you, let them know. Mark as solved and/or give a kudo. 😉
0 Kudos
Message 3 of 3
(2,809 Views)