I recently encountered an annoying 'bug' in excel. While I can enter 32K
characters in a single cell, if I use oledb to write to and Excel
spreadsheet, the limit on character size is 255. This problem has been
reported in many different places.
Regardless, I still needed to write more than 255 characters
programmatically. I decided to use XML. Some preliminary testing
demonstrated that writing the constructed cell contents to an XML file, then
importing it to excel successfully brought in all the data.
But then the typical 'gotcha' reared
its most unattractive head.
Importing the XML file into Excel had the side-effect of sorting the XML
elements by Element name ?!?!!?
This is not acceptable.
How can I import an XML file into Excel XP and
NOT have the columns sorted
on element name?