I have an xlsx file which serves as a template for TMS Flexcel. I populate it with data, it renders it in nice table. All is fine so far. Problem is when I want to add a graph.
The generated xlsx file appears to be damaged, and Excel tries to recover it when I open it. Unfortunately it fails, so the resulting file is without the graph.
Has anyone encountered it? How to work around it?
The error message I got is this
Excel completed file level validation and repair.
Some parts of this workbook may have been repaired or discarded.
Removed Part: Drawing shape.
Link to Flexcel site: http://www.tmssoftware.com/site/default.asp
What we do with some success is: 1. Add some dummy-data to the table where your actual data will be stored. 1. Create a graph from the dummy data and format it the way you want.
When the data gets exported to Excel, it will replace the dummy-data and appear in the graph.
TMS also has very limited support for xlsx files. Try using an xls file instead.