![]() Step-by-step instructions on how fpsctrls is made can be found in the FSpreadsheet tutorial. fpsctrls and fpsctrls_no_install create a GUI spreadsheet application with a minimum amount of written code the latter demo is good for testing because it does not require installation of the FPSpreadsheet packages.fpschart shows the application of the TsWorksheetChartSource and TsWorkbookChartSource and the interaction with the TAChart plotting package.Have a look at readme.txt for more details. other: simple commandline programs showing various aspects of the fpspreadsheet package.Note that the write example currently writes a format that the read example cannot understand. wikitabledemo, like excel2demo, but for wiki table files.opendocdemo, like excel2demo, but for OpenOffice/LibreOffice ods files.ooxmldemo, like excel2demo, but for the new Excel xlsx files.htmldemo, like excel2demo, but for HTML file (currently writing only).csvdemo, like excel2demo, but for CSV files.excel8demo, like excel2demo, but for Excel 97-2003 xls files.excel5demo, like excel2demo, but for Excel 5 xls files.Please run the write demo before the read demo so the required spreadsheet file is generated. excel2demo contains command-line programs for writing and reading Excel 2.x xls files.Again, please run the write test first which create the test files used for the read test. fpsspeedtest compares the effect of file format and various reading/writing parameters on the speed of writing and reading very large spreadsheet files.It also shows importing the spreadsheet into a database using virtual mode. db_import_export is an example showing how to export a large database table to a spreadsheet file using virtual mode or TFPSExport.Here is a brief description of these sample projects They can be found in the folder "examples". Sample projects in the fpspreadsheet installation folderĪ bunch of sample projects accompanies the FPSpreadsheet installation. In case of the visual spreadsheet controls, the needed units usually are inserted at design-time automatically. fpsnumformat: collects all utility functions related to number formats.Īll other units are probably not needed at the application level.cell^.BackgroundColor := scYellow) instead of calling the corresponding worksheet method ( MyWorksheet.WriteBackgroundColor(cell, scYellow), in this example). fpscell: this unit is required if you use direct cell formatting (e.g.conversion of col/row indexes to Excel-like cell address string). fpsutils: a collection of utility functions that are occasionally needed (e.g.The next units are required only occasionally: If the application will be able to handle all formats "use" the unit fpsallformats. the unit(s) implementing the reader/writer for a given file format, e.g.Note: in older versions these declarations were contained in fpspreadsheet.pas. fpstypes: declares most of the data types and constants used throughout the package.fpspreadsheet: implements TsWorkbook and TsWorksheet and the basic file reading/writing methods.A spreadsheet application typically "uses" the following units: The entire FPSpreadsheet package consists of several units. ![]() To create a project which uses the fpspreadsheet library, add the fpspreadsheet_pkg package to it's Lazarus project, or add the base directory of fpspreadsheet to you compiler options if using another IDE. Requirements to create an FPSpreadsheet application 3.9 Converting a large database table to a spreadsheet using virtual mode.3.8 Converting a database to a spreadsheet.3.3 Converting between two spreadsheet formats.3.2 Writing a spreadsheet to file based on extension. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |