Excel is refusing to open some of the files I programmaticaly create. I think what is happening is that it pukes because a particular column has very long strings (up to 1850 chars), but for the purposes of troubleshooting when I make the strings shorter (900 chars), it opens.
Question #1 : What is the longest string I can fit in a cell? Some google results say 1024 or 7,000ish but I have found 1000 to be too long.
Question #2 : I've tried writing my files in both XML and XLS format, but both have this same string-length-problem. Is there a format that Excel will read that will allow me to fit my 1850 length strings?