CSV Formatter/Reporter .NET

This project entails development of a [login to view URL] C# application which cleans up CSV files and generates both a CSV and XLS files where for the latter cells are colored according to the specifications. An example of a GUI interface summarizing the features is attached. This project needs to be finished in couple hours today Some specs are as follows: This is a generic CSV reporter so fields/columns are not set The number of fields to display is between 2 to 20 This will be able to generate either a CSV or a XLS file or both Each field might have a filter to filter rows based on values Each field has a color scheme. RBL min 10 max 40 means that: values below 10 will be colored in red, 10 to 40 blue and larger than 40 are going to be colored in black.(LBR is reverse coloring scheme) Excel files will have background cell coloring CVS file will have additional columns of colors added after the last column ie 1,4,5,blue,black,red Sorting will be done upto five fields selected sequentially Special characters entered by the user will be removed from the file Columns will me renamed Each configuration file will be saved and loaded later If cells have multiple values we might be able to average them ie 1;3;5 => 3 If there are more than one row with the same ID (first column) we might be able to average all values if wanted Empty cell will be filled with a value that user selects