1

SUPPORT

• Contact Support

TRIAL DOWNLOADS

• Microsoft Visual Studio .NET 2005 (22.99 MB)
• Microsoft Visual Studio .NET 2008 (23.05 MB)
• Microsoft Visual Studio .NET 2010 (32.82 MB)

Purchase a license

BOOKMARKS

TMS Flexcel Studio for .NET

100% managed code Excel file manipulation engine & Excel & PDF report generation for .NET & .NET Compact Framework

• Feature overview
• What's new
• Screenshots
• Testimonials
• Online tutorial
• FlexCel .NET WebPlanner Exporter
• FlexCel Studio for VCL
• Purchase a license

Feature overview

• Generates Excel files from WinForms, WebForms ASP.NET, PocketPC applications, webservices on the fly and fast with FlexCel Studio for .NET
• Native .NET components (no additional OLE/dlls required) allowing to read, create and modify native Excel .XLS and .XLSX files without needing to have Excel installed.
• Supported Excel 97 .XLS file format and Excel 2007/2010 .XLSX format
• Native PDF file export
• Exceptionally fast and solid hand tuned .XLS & .XLSX engine capable of generating thousands files per minute.
• Able to modify .XLS files and keep almost everything existing on the original file, from macros to activex objects.
• Recalculation of more than 200 Excel functions.
• Ability to read and write encrypted .XLS files.
• Completely written in C# 100% managed code, with NO interop and NO p/invokes!
• Runs on .NET 2.0, .NET 3.0, .NET 3.5, .NET 4.0, Mono and the .NET Compact Framework (xlsx support requires .NET 3.5).
• Templates can be stored inside your executable file, in a database or in any place from where you can access it as a stream.
• Extensive API is available with which you can programmatically write and read files, with formatting info, images comments, etc.
• Export to HTML in HTML 4.01 strict or XTHML 1.1 and fully standards compliant
• Report Engine that allows to create complex reports using Excel as your report designer, so your final users can modify them. You can use images/comments/conditional formats/merged cells/pivot tables/charts and almost anything you can think of on those reports.
  
• Full feature overview
• Whitepaper
  

What's new :

v 5.3.0.0

• New: Support for Recalculation of 49 built in functions new to Excel 2007
• New: Support for Recalculation of 8 built in functions new to Excel 2010
• New: Support for all Excel 2010's "Renamed Functions"
• New: "BALANCED COLUMNS" mode for reports.
• New: FIXEDN ranges for reports
• New: ROWS function for reports
• New: TCopyRangeMode.Formats to copy formats from a block of cells to other
• Improved: Medium trust support
• Many small fixes and enhancement

v 5.2.0.0

• New: Support for .NET 4.0, including new 4.0 security model
• New: Tested against Office 2010 RTM
• New: Full comment support in .XLSX
• New: Full data validation support in .XLSX
• New: Full hyperlink support in .XLSX
• New: Full checkbox support in API and .XLSX
• New: DateFormats parameter supported for opening .CSV files
• New: New "FirstSheetVisible" property in .XLS
• New: "CenteredPreview" property in FlexCelPreview
• New: Added support for new functions in recalculation. Added support for FREQUENCY
• Improved: Speed! Version v5.2 is between 10% to 30% faster than previous versions
• Changed: Database in all demos migrated from Access to SQL Server compact
• Various smaller bug fixes & improvements

v 5.1.0.0

• New: Excel 2010 XLS protected view support
• New: Basic image support in .XLSX
• New: Theme support, support for themes other than the standard Office themes
• New: Added methods to import/export from text files
• New: Copy mode to allow copy of objects marked as "Don't copy"
• New: Method GetUsedNamedRanges added in API
• New: Method CellRangeDimensions added in API
• Improved: Indexed color support
• Improved: Support for autofilters, selections, printer settings, color palette in .XLSX format
• Improved: Full medium-trust support
• Various smaller bug fixes & improvements

v 5.0.1.0

• New: Added support for recalculation for PercentRank function
• Improved: Performance for inserting rows with many images
• Improved: Compatibility with incorrectly generated XLS files by other 3rd party libraries
• Several smaller bug fixes & code improvements

v 5.0.0.5

• New : Excel 2007/2010 support, including support for new features in Excel 2007/2010:
  • Support for reading and writing xlsx file format
  • Expanded the rows to 1048576 and the columns to 16384
  • Support for Excel's 2007 true color and themes
  • Support for gradients in cell backgrounds
  • Support for a different header and footer for the first page and for even pages
  • Support for comments in named ranges
  • Cell indentation can go up to 250 characters instead of the old 15.
  • Methods OptionsMultithreadRecalc, OptionsForceFullRecalc, OptionsAutoCompressPictures, OptionsBackup, OptionsCheckCompatibility in XlsFile class allow to configure the corresponding settings in an Excel file.
  • Please note that xlsx file format support in 5.0 doesn't include objects/charts/images or conditional formats. That will be added along the 5.n series. Except for the bigger number of rows and columns (which can't be retrofitted to xls), all new properties will be saved even to the old xls files. They won't be available when opening the files in Excel 2003, but they will show in Excel 2007. And they will be used by FlexCel when printing or exporting to pdf/html, etc.
• New : What-If table support. Now FlexCel can recalculate What-if tables
• New : RecalcCell, RecalcExpression added to the API
• New : Support for adding multicell formulas with the API
• New : SaveForHashing method added
• New : Ability to read and write shared workbook protection
• Improved : In many places performance was significantly improved
• Improved : Rendering with support for diagonal borders and new linespace property
• Improved : Support for numeric formats
• Improved : Support for Date axis in charts

v 4.9.6.0

• New : Delphi Prism support. All demos have been converted to Delphi Prism, installation now installs into Delphi prism, and APIMate can generate Delphi Prism code.
• New : Ability to modify chart series from the API
• New : Full support for working with named styles from the API
• New : TTC font support when exporting to PDF
• New : SetExpression method in Flexcel Report
• Improved : HTML Rendering
• Improved : Speed of rendering conditional formats
• Improved : Speed in formula recalculation
• Various smaller fixes & improvements

Screenshots

Excel template

XLS file report generated from Excel template through Flexcel

PDF file report generated from Excel template through Flexcel

HTML file report generated from Excel template through Flexcel

Flexcel report generated from Excel template viewed with Flexcel previewer

Flexcel running on Pocket PC

FlexCel designer allows you to visually design your report in Excel

Flexcel ApiMate tool that converts any Excel file to code, in C#, VB.NET and Delphi.NET

Flexcel XLS viewer in browser

Flexcel XLS previewer running on Mono

Testimonials

After looking carefully at all the Competitor products in detail and having worked with one competitor product extensively we decided to move to FlexCel - this was no small decision but we have been rewarded with the most powerful and complete implementation. .Net managed code and a huge set of features. With FlexCel we really push the boundaries and have found it is really up to the task. Most importantly when we needed new business critical functionality the guys on support have really responded and given us and the product features when they were needed. I would strongly recommend FlexCel from both a technical and service response point of view.

Richard White MBus C.E.O.
CargoWise edi
www.cargowise.com

We have built several windows (both .NET and Delphi) solutions using FlexCel and we have experienced the good evolution of the product. We like it mainly for the three following reasons: Value for the money: There is no need for any other component to have a full reporting solution. Performance: From the real experience we have performed, FlexCel is very well engineered and the performance you can obtain with it is impressive! The source code is available, and it's very important if you are involved in the development of competitive solutions and products.

Luis del Ser
CEO Movilok
http://www.movilok.com

I literally stumbled across FlexCel Studio for .NET on the internet. Whenever I searched for similar software, I ran across others that sucked, and the costs for them are outrageous. You guys have one hell of a product. I have been using it for the last two days, and I am very impressed not only by what I can accomplish but also your excellent documentation and examples.

Frank Gennaro
FTD
http://www.ftdi.com

I am really impressed about your know-how around Excel’s under the hood workings. I’ve been kicking the FlexCel API around a bit over the weekend and must say it is the best investment I made in a long time in both time and money! And the speed at which you guys respond is incredible !

Tim Young
by email

Buy online