LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Why MSDN of excel function is different with Labview?

Hello, Everyone

In recent , I wanna get "font color" from excel to Labview 

I had search MSDN and to use this function "Characters()"

But I found it can not found at property node

Anyone have same problem?Smiley Frustrated

132.png

0 Kudos
Message 1 of 7
(2,900 Views)

Example_VI_BD.png

aputman
Message 2 of 7
(2,861 Views)

Thanks for your reply, I try to follow your step but can not read out A1 color...Smiley Frustrated

未命名.png

 

0 Kudos
Message 3 of 7
(2,845 Views)

One thing you need to keep in mind is that the color is different in Excel than it is in LabVIEW. I made a color converter to go back and forth between the two programs so the colors always match when I am exporting to excel.

Tim
GHSP
0 Kudos
Message 4 of 7
(2,815 Views)

A custom color converter is not needed since there is already one that is part of LabVIEW.  In quick drop, search for Convert OLE Color.

Also characters start at index 1, not 0.  

 

Example_VI_BD.png

aputman
Message 5 of 7
(2,795 Views)

I just try your solution, I found start = 0 will get error's value have to 1 start like this

Thanks AputmanSmiley Wink

Is possible get single font color value?

Like 1=Red,2=Black,3=Green

0.png1.png

0 Kudos
Message 6 of 7
(2,779 Views)

@HOYO wrote:

 

Is possible get single font color value?

Like 1=Red,2=Black,3=Green

 


I'm not sure what you mean by this?  

aputman
0 Kudos
Message 7 of 7
(2,752 Views)