Printing And Exporting Features
FlexCel includes a state of the art rendering engine, for printing, previewing and exporting to PDF.
You can use the rendering engine to render any xls file, not only those generated by FlexCel.
<#image>
Resolution independent printing
Different from Excel, FlexCel uses GDI+ to render the files, and this means that it will print virtually the same on any printer. As Excel prints different things depending on the printer type and resolution, FlexCel was calibrated to bring the same result you would get when printing to a 600dpi laser printer. You can also alter this zoom factor in the code, if you want to emulate other printer.
<#image>
Export of Conditional Formatting
FlexCel will automatically calculate any conditional formula or expression when exporting or printing, and format the cell as needed. All conditional formats in xls or xlsx files are supported, including icons, databars and color scales.
<#image>
Autoshapes
The rendering engine can export and print more than 60 types of autoshapes, including all most used ones. A spreadsheet is included in the documentation detailing which shapes are supported and which are not.
<#image>
Partial Text Art support
While not all TextArt effects are rendered, and in particular text paths are not yet supported, text art is printed and exported.
<#image>
Almost any other thing you can think of
Header/footer, repeating rows and headers, heading rows, gridlines, margins, cell patterns, rotated text, subscripts, superscripts, rich format on a cell and more. Shadows, brightness/contrast adjustments on images, transparency, semi-transparency, rotated images. Gradient and pattern textures. Everything for both xls and xlsx files.
<#image>
Support for bookmarks on PDF
You can automatically add a bookmark per sheet, or add them on your own event as you like.
<#image>
Charts
2d charts are rendered with lots of attention to the detail (xls files only, not xlsx). 3d charts are currently rendered as 2d.
<#image>
Full Winforms preview component included.
With support for thumbnails, zoom and more. There is a demo included with full source, “CustomPreview”, where you can learn how to add a preview form to your application.
<#image>
Export an xls file to multipage tiff, png, jpg, gif, fax, etc.
There is an included component that allows you to export any xls file to an image, with the same level of detail provided by the rendering engine.
<#image>
Signed PDFs
FlexCel allows you to sign the PDFs it creates with your own certificates. Both visible and invisible signatures are supported.
And more…
As always, it is impossible to detail everything here, but we hope we included the most important points.