12-12-2018 03:19 AM - edited 12-12-2018 03:19 AM
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?
12-12-2018 09:08 AM
12-12-2018 07:51 PM
Thanks for your reply, I try to follow your step but can not read out A1 color...
12-13-2018 09:43 AM
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.
12-13-2018 01:22 PM
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.
12-13-2018 08:14 PM
I just try your solution, I found start = 0 will get error's value have to 1 start like this
Thanks Aputman
Is possible get single font color value?
Like 1=Red,2=Black,3=Green
12-17-2018 08:52 AM
@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?