Export xlsx file with charts

FLX TMS FlexCel for VCL & FMX
1

Hello,

When I export a xlsx file with charts, the chart images are empty files.

example file : http://dl.dropbox.com/u/8427168/test.xlsx
 
This is my code:
 

FlexCel.Render.FlexCelHtmlExport exporter = new FlexCel.Render.FlexCelHtmlExport();
exporter.HtmlFileFormat = FlexCel.Core.THtmlFileFormat.Html;
exporter.AllowOverwritingFiles = true;
exporter.SavedImagesFormat = FlexCel.Render.THtmlImageFormat.Png;
exporter.Workbook = new FlexCel.XlsAdapter.XlsFile();
exporter.Workbook.Open(xlsPath);
for (int i = 1; i <= exporter.Workbook.SheetCount; i++)
 {
  exporter.Workbook.ActiveSheet = i;
  sheetNames.Add(exporter.Workbook.SheetName);
  exporter.Workbook.PrintHeadings = true;
  exporter.Workbook.PrintGridLines = true;
  
  string folderToExport = subFolder;
  string currFileName = Path.Combine(subFolder, "Sheet" + i.ToString() + ".html");
  exporter.Export(currFileName, "images", "style" + i.ToString() + ".css");
 }
 
thanks
2

I forgot, i use flexcel 5.6.0.1.

3

Hi,

Charts in xlsx are not yet rendered to html or pdf.  This is planned for FlexCel 6.0 (which should be coming after 5.7 which will add conditional format support for xlsx).

Sadly by the moment the only way to have this working is with xls, not xlsx. Xlsx charts are completely different from xls charts, and we need to rewrite the chart rendering engine for FlexCel to be able to export them.
4

When are you planning to release the version 5.7 and the 6.0?

 
thanks for the information
5

Sadly we can't commit to a public timeline at this moment, since we don't really know how much work is involved in creating a new chart rendering engine. Just to give you an idea, last one we did (the xls chart rendering engine) took us 6 months of very very hard work. This one might take longer or less depending in how it is implemented and how much code we can reuse. Sadly Microsoft made xlsx in a way that little code is reusable and it doesn't seem better with the charts. (Excel itself has a lot of trouble and still many bugs converting between xls and xlsx charts, so they aren't very similar)