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

Example_VI_BD.png

aputman
------------------
Heads up! NI has moved LabVIEW to a mandatory SaaS subscription policy, along with a big price increase. Make your voice heard.
Message 2 of 7
(2,461 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,445 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,415 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
------------------
Heads up! NI has moved LabVIEW to a mandatory SaaS subscription policy, along with a big price increase. Make your voice heard.
Message 5 of 7
(2,395 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,379 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
------------------
Heads up! NI has moved LabVIEW to a mandatory SaaS subscription policy, along with a big price increase. Make your voice heard.
0 Kudos
Message 7 of 7
(2,352 Views)