Shoting 1 Excel sheet on basis of row color (Font) using C# .

Rajendra Tripathy

I have to Shoting 1 Excel sheet on basis of row color (Font) using C# .

Let say I have used two colors , some rows are in Blue & Some in Green. So how to Short them using C# Code.

1      rrr      ooo
1      rrr      ooo
1      rrr      ooo
1      rrr      ooo
1      rrr      ooo
1      rrr      ooo
1      rrr      ooo
1      rrr      ooo

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

PJ Martins16y ago
Not quite sure what you mean by Hard coded, even if there's a set number of columns, excel does not limit you to adding another column, you could possibly store the values in a column far to the right, eg. "AA1" or similar. If you cant' do that, is it possible to copy the cells to another sheet that you can manipulate?
Rajendra Tripathy16y ago
Nice Idea, But sorry to say I can't add any extra column because column number was hard coded, So i cant change all the code for sorting. So is there any other logic or code snippet?
PJ Martins16y ago
You could loop through each row in the spreadsheet and add an additional column which contains the color's name, then call the sort method on this column. Once it's sorted just remove the column afterwards.
Rajendra Tripathy16y ago
Thanks for the response.
I have to Sort an Excel sheet (Sort On Font Color). Lets say there is Some rows in an excel sheet, Some of them are in blue and some rows are in Green. So I need Green rows to be in top and blue rows in button. For that I think I have to Sort that Excel sheet (Sort On Font Color). Hope you can understand. So please let me know how to do in C# Code.
PJ Martins16y ago
What do you mean by shoring? Are you trying to sort them or filter them by color?