I want to export a large amount of data to an excel file (30,000 plus). This is no problem. The problem is that, one of the columns needs to be coloured green according to the data within it.
For example, the colour contains percentages, and when the percentage is over 70%, then the cell needs to be green.
I can do this easily using a Datagrid/Gridview. However, because of the amount of data, my server is crashing with a SystemOutOfMemory exception.
What I would like to do is use a tool to write the data to an excel file, and then transfer the file. Is this possible?
View Complete Post