LabVIEW Idea Exchange

cancel
Showing results for 
Search instead for 
Did you mean: 
Bob_Schor

Provide Excel "Get" functions for Formats and Graphs

Status: New

The Report Generation Toolkit provides functions to set various Format aspects of Excel "areas", and Excel Graphs, but doesn't provide the complementary "Get" functions to return the current values.  For example, I wrote a LabVIEW function that will set the Font Color of a row of a WorkSheet to Red (using Excel Set Cell Font), but if I want to find the row with the Red font, there is no "Excel Get Cell Font" that can return the property to me.  Of course, I could cobble something together using ActiveX calls, perhaps, but these are poorly documented, and since NI is already doing the "heavy lifting" to provide the Set functions, it would seem "relatively simple" for them to also add the corresponding Get functions, as well.

 

Bob Schor  (using Excel as a "controller" for some experiments controlled by a LabVIEW Real-Time system)

1 Comment
DrK.Jimenez-Marquez
Member

I agree completely. I miss the equivalent "Excel get format" functions for these Excel set functions in the image. 

Excel_Format_Functions.PNG

The worst thing is that the excel class is locked and we can't complete this functionality with new VIs, we can only add taht functionality to the exicting VIs and the result is not the best...


PhD. K.Jimenez-Marquez
Let's make it simple!