Posted: 30 Oct 2018 10:10 EDT Last activity: 15 Nov 2018 9:23 EST
How to format specific excel row/column?
I have to change the color of a row based on the particular cell value in that row.
I could get excel range following the steps provided in the post Excel-How to .I tried as guided in Formatting text . But this is resulting with coloring the entire sheet because the range is entire excel used range.
Is there any way to change the color/ font of particular cell or row or column. Could anyone please help on this.
In build 8.0 SP1 2010 which will be released shortly you will have a method called RangeSetBackgroundColor. In conjunction with WorksheetGetRange you should be able to do what you want. Here is an example:
In this release there are over 40 new methods on the Excel connector.