Welcome to the FlexCel Component Suite Demo

Hi. This application intends to be a small demo of the things you can do with FlexCel reports, and at the same time a tutorial to help you learn doing them. It is not intended to show how to write apps, and the examples are not intended to make any sense, or be pretty or useful. Just to show what can be done.

Choose an option at the left, and then press one of the following buttons.

•	Native Adapter: When this button is down, the XLS file generated is completely native, no OLE is used and you don't have to have Excel installed on your machine.

•	OLE Adapter: When this button is down, the file will be created by OLE automation. This is a slower option, and for it to work, you need Excel 97 or older installed.

•	Fast Count: This is the main parameter to change when trying to optimize the speed of a FlexCel Report. When CalcRecordCount is set to cr_none reports will be generated faster, but you have to be sure your dataset correctly implements RecordCount. See the doc on CalcRecordCount for Details.

•	Export to HTML: This is only enabled in OLE mode. When selected, an HTML file will be generated.

•	Protect: This is only enabled in OLE mode. When selected, the workbook and all the sheets generated will be protected with the password 'pass'. This is to show you how you can use the events in FlexCelReport to allow functionality not directly available on it.

•	Template Store: This is only available in Native mode. The template store is a component that allows you to link your templates directly into the exe. If this button is down, the templates will be read from the store, and you can run this exe even if the templates are not present. Also if you modify the templates, the changes will not show, because they are being read directly form the exe.

•	Report/Import: Press this button to run the selected demo.

•	Preview: This is indented to show how you can run excel/explorer inside your application instead of launching an external app. Only works for reports that save the data to disk(currently Native or OLE with HTML). This is experimental, and I haven't played much with it. After trying to use an OLE container and founding lots of problems, I implemented with a TWebBrowser component, and it got better but not perfect. Depending of the excel /explorer versions you have installed, you might see a Zoom and a print preview button or not. Also, dialog asking to open or download might appear.

•	Print !!: This is to show a frequently asked feature… How to directly print the generated report. There is not support for this at FlexCel, but it’s easy… For OLE mode, just add a Wb.PrintOut on the AfterGenerateWorkbook event. For Native, call ShellExcecute with print option (The sheet should have not formulas for this to work, if not a warning will be displayed).

•	Test All: I use this to test the app for memory leaks. It runs all the reports.

•	View Template: This button will open excel to show the template used to generate the report.

•	Edit Template: This will call the in-place report editor, the same that appears when you double-click a TFexCelReport component. This is a sample of how you can embed it into an application.

•	Close: Yep… It closes the app.