TRIAL DOWNLOADS

• Delphi 6 (1.74 MB)
• Delphi 7 (1.76 MB)
• Delphi 2005 (1.85 MB)
• Delphi 2006 (6.33 MB)
• Delphi 2007 (6.33 MB)
• C++Builder 6 (982.72 KB)
• C++Builder 2006 (6.33 MB)
• C++Builder 2007 (6.33 MB)

Purchase a license

TMS FlexCel Studio for VCL

Powerful, extensive & flexible component suite for native Excel report & file generation & manipulation

• Feature overview
• Samples
• What's new
• Comments
• Executable demos
• Demo overview
• FlexCel Studio for .NET
• Purchase a license

Feature overview

• FlexCel Studio for VCL is a suite of Delphi 6,7,2005,2006,2007 + C++Builder 6,2006  components allowing to create Excel files by substituting values from a database or variables into a template. There is also an extensive API allowing to directly read/write Excel files, and a Grid for displaying and editing them. If you need to read or create complex spreadsheets, in linux or windows on machines without Excel installed, Flexcel can do the job.
• Can create completly native (no OLE/dlls) files (biff 8 format: Xls 97-2003-XP), or create them by OLE automation. Your option.
• In native mode, templates can be embedded inside your exe. No additional files to distribute
• Can write images/comments/conditional formats/merged cells/pivot tables/charts and almost the complete Excel 2003 feature set in native or OLE mode (Writing images is not allowed in OLE, but you can include as many as you want in the template)
• Can save to HTML files (only in OLE mode)
• Messages in English, Spanish, French, Italian, Romanian, Russian, Brasilian Portuguese and Simplified Chinese (registered version only)

Samples

Excel template

Report generated from Excel template through Flexcel

Flexcel native XLS viewer

This is a the Excel document used as a "Template" for filling in the data...

...And this is what gets generated.

The Report Designer, where you can drag and drop the fields from your datamodule to the report.

This is the XlsViewer on windows, displaying a generated sheet.

... And this is XlsViewer on linux, displaying another generated sheet.

Here we see the Biff Editor application, showing an excel file.

This is a screen showing barcodes generated by using an special font. Thanks to Aleksey Shervakov for it.

What's new

v2.6.26

• Improved : Several performance improvements were done for reading XLS files
• Fixed : issue with loading nested charts

v2.6.24

• New : Support for displaying Addin functions in cells
• Improved : rendering of numeric formats: Now conditions like [>10] inside a numeric format will be displayed by FlexCelGrid. Localized dates (New in Excel XP) are also displayed now
• Various smaller bug fixes & code improvements.

v2.6.22

• Improved compatibility with Excel 2007: Some complex drawings in an xls file could be loaded wrong by Excel 2007.
• Updated Brazilian Translation: Many thanks to Cicero A Billo for it.
• Bux Fix in AdvGridExcelIO: Fixed error when exporting hidden rows.

v2.6.21

• New : C++Builder 2007 support
• New : 1904 dates support: Added full support for 1904 dates, in the API and the grid
• New : ShowHiddenRows/Cols property to FlexCelGrid
• New : InvalidateFormulas method to FlexCelImport
• New : Support for scrollweel to the FlexCelPreview component
• Updated references to PngImage to the latest version

v2.6.20

• New : Added User defined functions: Now you can define published methods and call them the same way as published properties from the code, including parameters. See the updated PseudoCalculatedFields demo

Comments

Wow ! I just got the TMS FlexCel Studio and it worked right away. After a few tries I had an Excel file. First I thought it didn't work because it was so fast. It took 55 seconds with TExcelApplication, but with the TXLSAdapter it took about 0 seconds. I couldn't click on my stopwatch fast enough !! Great stuff ! Thanks a lot !

Detlef Rattunde, via email

Executable Demos

• FLDemo : main FlexCel features demo
• XLSViewer : application to view XLS files

Demo overview

• Getstarted : Introductory demo
• FlDemo : Main Flexcel features demo
• XlsView : Native Excel file viewer demo
• DBDump : Takes any BDE database and dumps the results of an SQL to an Excel sheet
• DirectOracleAccess : Similar to DBDump, but exports tables from oracle using Direct Oracle Access from Alround Automations. To use this demo, you need to have DOA from Alround Automations. (Registered version only)
• XLSDBTemplateStore : A small app to show how you could load the templates into a database for using with TXlsDBTemplateStore component.
• IBObjects : A demo of how to use the native IBOjects support. To run this demo, you need IBOjects from Jason Wharton. (registered version only)
• Stresstest : Demo for studying the limits of FlexCel. It will create a very big spreadsheet. (65000 rows, this is almost the Excel limit)
• Thread : Shows how you can run reports from a thread, and use the "Cancel" method to cancel them.
• IntraWeb : Web based Excel report generation with IntraWeb

Buy online

This product is also available in TMS VCL Subscription.