Excel Easy Table.vi

[MarkDavid]

In the Excel Easy table the help file tells you to refer to Excel (2007)  for formatting cells.  I can't figure out how to correlate "xlrangeautoformatcolor2" or any other format in the vi to the cell formatting in Excel.

Also, when I open Excel after using the easy table vi, the headers are right justified.  Does anyone know how to programatically center those labels/cells?

[mikeporter · Accepted solution]

The first thing is that you need to be looking at the documentation for Excel's ActiveX interface. The names and the labels should be pretty close. Secondly, while this doesn't explicitly address your question, I have often found it easier to do all the fancy formatting in Excel and just use LV to poke the numbers into the cells.

Mike...

PS: Also be aware that MS is real bad about rewriting the Active interface for Excel, thus breaking any existing programs that use the old interface - just a heads up...

[MarkDavid]

Thanks.. that info would be nice in the Help File too.

[Courtney_L]

Hey Mark,

Thanks for your comment. I will look into this documentation and recommend a change to the helpfile.

Best,