setting excel cell dimension problem

[fgowash]

Using the provided report generation vi's I am having a heck of a time trying to format an Excel worksheet the way I want it.

Basically, I would like control the width dimension on cell ranges so that the report "fits" the desired look.

For example a table might need headers that span 2 columns of the following table. I thought that I might be able to adjust a row of cells so that they have a 2x width relative to the table cells it sits on top of. This has become frustrating since the cell resizing affects the whole work space not just the cells I want. I cannot fine any examples or details on what to watch out for or if this is really a problem.

Any ideas on this can only help at this point.

Thanks, Fran

[Joe_H]

I would suggest making a template in excel and calling the template in LV and populating the correct cells. This would be a lot easier than having to format the spreadsheet every time you wrote to it.

For more information and some sample VI's and tool kits, you can go to the excel board

[fgowash]

Although I'm somewhat mystified about the cell resizing thing I have resolved the issue with what I was trying to do!

Mainly, it is difficult to use LabView with Excel if one is weak with Excel knowledge on the specifics of what one is trying to do. In this case merging cells and populating them needed some study on my part.

I already had a template so yes it is the way to go. But staring at one's code and not seeing the missing named field did not help either.

Maybe I'm working too hard or retirement beckons.......whatever.. thanks for the response it was all that was needed to refuel and solve things.

The forum works!  Thanks MUCH!

Fran