I'm importing an Excel file and I need to validate all the cells an then import the result in our database.
When I have and error I change the Cell color. For small file I don't fell a performance issue. But on big file it's not possible. It take about half a second to change the color.
I turn off the History mode on the Woorkbook. wb.History.IsEnabled = false;
This is my code with cellSelection.SetFill(SolidErrorFill); commented to have better speed. How can I achieve a better speed ?