0
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?
0 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?
0
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.
0 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. 0 What do you mean by shoring? Are you trying to sort them or filter them by color?