GitHub - tcs-ulli/fpspreadsheet

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 3,816 Commits
examples		examples
images		images
reference		reference
tests		tests
fpolebasic.pas		fpolebasic.pas
fpolestorage.pas		fpolestorage.pas
fps.inc		fps.inc
fpsactions.pas		fpsactions.pas
fpsallformats.pas		fpsallformats.pas
fpscell.pas		fpscell.pas
fpsclasses.pas		fpsclasses.pas
fpscsv.pas		fpscsv.pas
fpscsvdocument.pas		fpscsvdocument.pas
fpscurrency.pas		fpscurrency.pas
fpsexport.pas		fpsexport.pas
fpsexportreg.pas		fpsexportreg.pas
fpsexprparser.pas		fpsexprparser.pas
fpsfunc.pas		fpsfunc.pas
fpsheaderfooterparser.pas		fpsheaderfooterparser.pas
fpsnumformat.pas		fpsnumformat.pas
fpsnumformatparser.pas		fpsnumformatparser.pas
fpsopendocument.pas		fpsopendocument.pas
fpspalette.pas		fpspalette.pas
fpspatches.pas		fpspatches.pas
fpspreadsheet.pas		fpspreadsheet.pas
fpspreadsheetchart.pas		fpspreadsheetchart.pas
fpspreadsheetctrls.lrs		fpspreadsheetctrls.lrs
fpspreadsheetctrls.pas		fpspreadsheetctrls.pas
fpspreadsheetgrid.pas		fpspreadsheetgrid.pas
fpsreaderwriter.pas		fpsreaderwriter.pas
fpsrpn.pas		fpsrpn.pas
fpsstreams.pas		fpsstreams.pas
fpsstrings.pas		fpsstrings.pas
fpstypes.pas		fpstypes.pas
fpsutils.pas		fpsutils.pas
fpsvisualutils.pas		fpsvisualutils.pas
fpsxmlcommon.pas		fpsxmlcommon.pas
fpszipper.pp		fpszipper.pp
laz_fpspreadsheet.lpk		laz_fpspreadsheet.lpk
laz_fpspreadsheet.pas		laz_fpspreadsheet.pas
laz_fpspreadsheet_visual.lpk		laz_fpspreadsheet_visual.lpk
laz_fpspreadsheet_visual.pas		laz_fpspreadsheet_visual.pas
laz_fpspreadsheetexport_visual.lpk		laz_fpspreadsheetexport_visual.lpk
laz_fpspreadsheetexport_visual.pas		laz_fpspreadsheetexport_visual.pas
readme.txt		readme.txt
uvirtuallayer.pas		uvirtuallayer.pas
uvirtuallayer_ole.pas		uvirtuallayer_ole.pas
uvirtuallayer_ole_helpers.pas		uvirtuallayer_ole_helpers.pas
uvirtuallayer_ole_types.pas		uvirtuallayer_ole_types.pas
uvirtuallayer_stream.pas		uvirtuallayer_stream.pas
uvirtuallayer_types.pas		uvirtuallayer_types.pas
wikitable.pas		wikitable.pas
xlsbiff2.pas		xlsbiff2.pas
xlsbiff5.pas		xlsbiff5.pas
xlsbiff8.pas		xlsbiff8.pas
xlscommon.pas		xlscommon.pas
xlsconst.pas		xlsconst.pas
xlsescher.pas		xlsescher.pas
xlsxooxml.pas		xlsxooxml.pas

Repository files navigation

fpspreadsheet
=============
The fpSpreadsheet library offers a convenient way to generate and read 
spreadsheet documents in various formats:
- Excel 2.x .xls
- Excel 5.0/Excel 95 .xls
- Excel 8.0 (Excel 97-XP) .xls
- Microsoft OOXML .xlsx
- LibreOffice/OpenOffice OpenDocument .ods
- wikimedia wikitable formats

The library is written in a very flexible manner, capable of being extended to 
support any number of formats easily.

Installation
============
If you only need non-GUI components: in Lazarus: 
- Package/Open Package File 
- select laz_fpspreadsheet.lpk
- click Compile. 
Now the package is known to Lazarus (and should e.g. show up in Package/Package Links). 
Add it to your project like you add other packages.

If you also want GUI components (grid and chart): 
- Package/Open Package File
- seleect laz_fpspreadsheet_visual.lpk
- click Compile
- then click Use, Install and follow the prompts to rebuild Lazarus with the new package.
Drop needed grid/chart components on your forms as usual
		
License
=======
LGPL with static linking exception. This is the same license as is used in the Lazarus Component Library. 

More information
================
FPSpreadsheet documentation in fpspreadsheet.chm (open e.g. with Lazarus lhelp)

The fpspreadsheet article on the Lazarus wiki with lots of example:
http://wiki.lazarus.freepascal.org/FPSpreadsheet

The demo programs in the examples folder