I encountered an interesting happening. I am using ClosedXML to read a text file and magically create an excel spreadsheet. Most values are strings that get added to cells. Consider this code:
cell = worksheet.Cell("A1");
cell.Value = firstName;
The variable firstName holds a string that gets assigned to cell.Value. I stumbled upon a First Name of "Infinity". It seems that Excel tries to do something special. I believe "Infinity" is a reserved word for Excel?
I was able to fix this by adding this code directly beneath:
if (firstName == "Infinity")
Are there other special Excel words/commands that I should account for? Thanks in advance!