How To Write A Single Number To A Single Excel Cell

[Kilo_Watts]

I'm using Labview 2013 SP1 with the Microsoft Report Generator and I can't figure out how to write one DP number to one specific cell on an Excel spreadsheet. I have no problem writing arrays of numbers to specific ranges of cells, formatting cells, writing titles, using templates, everything I need except being able to write one number to one specific cell. All the vi's that write numbers seem to demand 2D arrays for inputs. I must be missing something, but I think I've gone through every vi in the MRG pallette and found nothing.

Any help/examples greatly appreciated.

[mikeporter]

Can you specify a 2D array with just one row and one column?

Alternatively you can use the ActiveX interface to excel.

Mike...

[ben64]

I agree with Mike, if you use the Report Generation Toolkit convert the single value to a one row one column 2D array.

Ben64

[Bob_Schor · Accepted solution]

... and you probably know that the easiest way to do this is with Build Array, twice.

Note the lines getting "thicker" going left to right.

Bob Schor

[Kilo_Watts]

Thanks to all who responded.

A "bogus" array seems to be the way to go. Odd that with all the power of MRG such a simple task requires a workaround. Oh well, the important thing is that it works an I'm sure this will. The double Build Array is clever, I probably would have gone for the Initialize Array, but the double is easier.

Thanks again....

[Bob_Schor]

It will help other readers of the Forum who might have the same question to ask if you would mark the Solution.

BS

[Kilo_Watts]

Done, thanks.....