I¹m currently working on a project where we¹re exporting data from a DB to an Excel file. Some of the data is SVG drawing data in XML format.
There are no problems creating the xlsx file but when I try to open it, Excel crashes. I can¹t find any information about escaping XML for cell content, but that¹s what I¹ve had to do. I know that the file format is OOXML but I thought but I thought that Excel/POI would handle any escaping and un-escaping of cell data internally. I guess what I want to know, is this expected behaviour or is it a bug? Z.
