Get rid of bottom border Excel

[cassidee21]

Hello,

I am using the Report Generation Toolkit to make an excel file display a table. I want the cell borders in the table, except for one cell. With this particular cell I want to get rid of the top border. The border function in the toolkit only lets you get rid of the inside and outside borders. Is there a way to get rid of only the top?

Thanks in advance,

Cassidee

[K_Joy]

Cassidee,

There’s no direct way to do what you’re looking for in the Report Generation Toolkit.

However, what you can do is use multiple copies of “Excel Set Color and Border.vi” to first hide the borders for a range of cells in Excel and then add back the borders of the blocks around it.

For example, the code snippet below removes the borders for all cells in the third column and then re-draws the border for cells 1 through 9 (zero-indexed), which results in just the top border of the first cell in that column being hidden.

 

I tested this code with the built-in LabVIEW example “Conditionally Formatted Spreadsheet.vi” and the resulting Excel spreadsheet looks like this:

Regards,

Kelsey Johnson

Applications Engineer

National Instruments

http://www.ni.com/support

(866) 275-6964