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

Question

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

PJ Martins · Answer

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 Tripathy · Answer

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 Martins · Answer

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 Tripathy · Answer

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 Martins · Answer

What do you mean by shoring? Are you trying to sort them or filter them by color?