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,898 Views)

Example_VI_BD.png

aputman
Message 2 of 7
(2,859 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,843 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,813 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,793 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,777 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,750 Views)