Excel Easy Table - Elliminating Borders

[mschaf]

Whenever I try to write data to an Excel report using Excel Easy Table from the Report Genertaion Toolkit (LabVIEW 8.0), it automatically puts borders around all of the cells. I have a "no formatting" contstant (xlRangeAutoFormateNone) wired to the autoformat terminal of that vi and it doesn't seem to be affecting it.

How do I get it to export without the cell borders?

Thanks!

[reikira · Accepted solution]

Hi mschaf,

you can follow these steps:

1) select your table control in LabVIEW, right click and choose "Properties": in the Appearance Tab you can uncheck "Show vertical lines" and "Show horizontal lines";

2) Wire a control to "Auto Format" input in Excel Easy Table.vi: there are different standard table styles of Excel that don't have borders around the cells. See for example xlRangeAutoFormatPTNone.

When you have chosen the style you prefere, you can substitute the control with a constant.

I hope this can help.

Best regards,

Serena M.

[mschaf]

Thanks Serena. I actually figured out I could accomplish what I needed with the "Append Table to Report" VI which has a deticated "show grid lines" terminal.

[vickykld]

Hi Serena,

can you further explain how to do this:

" 1) select your table control in LabVIEW, right click and choose "Properties": in the Appearance Tab you can uncheck "Show vertical lines" and "Show horizontal lines";"

Thanks,

Victor