report generation insert name

[ajh]

I need to insert a name for a cell or range of cells. Can I do this with the Report Generation toolkit?

[ajh]

I modified an existing VI to add a name to a cell. Anyone have any better ideas or comments?

[LaRisa_M]

Hi,

Are you wanting to just insert text into a specific cell in Excel? What do you expect the Excel sheet to look like? Can you give us a before and after picture to show what your VI is meant to do?

[ajh]

I needed to define a name using Labview for a cell or range of cells so that I can use the name in formulas and a summary worksheet. Using Report Generation VI's, I was able to place data in cells using names, but did not see a VI to define a name. My Excel spreadsheet will have 16 worksheets with data in rows. The amount of data will vary, so I find the last row in each worksheet and place my sum and / or averages after the last row of data. I then wanted to assign a name such as "Range1_NT" to the cell. A summary worksheet will reference to and display the values of "Range1_NT", ......  instead of a cell designator "$B$123".

[LaRisa_M]

Ok. I have a much better understanding of what you're doing now. I've got to say I think your method here is the best way. Report Generation toolkit doesn't have any specific VI's for doing this, so your best option is ActiveX. The only error I saw with your code is that you shouldn't have a "=" in the "Range" input, since you are adding the "=" again in the block diagram.