#Lazarus free instals how to#
#Lazarus free instals install#

These units are not available automatically, you have to add them to the uses clause explicitly. Note: FPSpreadsheets provides specialized units for reading from and writing to each file format. This property returns a multi-lined string which is displayed best in a memo component if everything was fine it is an empty string. procedure WriteToFile(const AFileName: String const AOverwriteExisting: Boolean = False):ĭitto, but the file format is determined from the file extension provided (in case of Excel's xls the most recent version, sfExcel8, is used).Īfter calling these methods it is advantageous to look at the workbook's property ErrorMsg in which messages due to errors or warnings are collected that might have occured during reading/writing.If the file already exists it is automatically overwritten if AOverwriteExisting is true: Writes the workbook to the given file using the given spreadsheet format.

procedure WriteToFile(const AFileName: string const AFormat: TsSpreadsheetFormat const AOverwriteExisting: Boolean = False):.The following workbook methods can be used for saving to file: Reads the file, but assumes that the file format is as specified by AFormat. procedure ReadFromFile(AFileName: string AFormat: TsSpreadsheetFormat):.Reads the file with the given name and automatically determines the correct file format. procedure ReadFromFile(AFileName: string):.Reading of spreadsheet files is accomplished (among others) by the workbook methods Var MyWorkbook : TsWorkbook begin MyWorkbook := TsWorkbook. When applying fpspreadsheet the first task is to create an instance of the workbook: It is possible, however, to provide your own reading and writing classes to extend the functionality of FPSpreadsheet - see the section below on Adding new file formats There are no plans to implement 'ancient' file formats like Excel3.0/4.0 or Lotus. sfUser is needed to register a user-defined format.sfWikiTable_Pipes and sfWikiTable_WikiMedia is the format used by tables in wiki websites.sfHTML denotes the standard HTML format as used in web browsers.csv) they can be understood by any text editor and all spreadsheet programs, but do not contain formatting information. sfCSV refers to comma-delimited text files (default extension.sfOpenDocument is the spreadsheet format used by OpenOffice/LibreOffice by default, the files have the extension.sfExcelXML is the xml format which was introduced by Microsoft for Office XP and 2003.sfOOXML corresponds to the newer xlsx format introduced by Excel2007.sfExcel2, sfExcel5, sfExcel8 stands for versions of the binary xls format used by Excel ('BIFF' = 'Binary Interchange File Format') with sfExcel8 being the most modern one.Type TsSpreadsheetFormat = ( sfExcel2, sfExcel5, sfExcel8, sfExcelXML, sfOOXML, sfOpenDocument, sfCSV, sfHTML, sfWikiTable_Pipes, sfWikiTable_WikiMedia, sfUser ) The file format is specified by the type TsSpreadsheetFormat defined in the unit fpstypes The versatile structure of the library provides access to various popular file formats, like Excel. It provides methods for reading data from and writing to files. The class TsWorkbook is the main class visible to the user. font list, cell and number format lists, etc.įPSpreadsheet follows this same structure - there is a TCell, a TsWorksheet, and a TsWorkbook. The workbook also stores information that is needed from all worksheets, i.e. Worksheets are bound together to form a workbook which represents the document of the spreadsheet application. Each cell has a unique address given by the row and column index. The cells are arranged in a grid-like structure, called worksheet, or spreadsheet, consisting of rows and columns. font style, background color, text alignment etc. In addition, cells can contain information on formatting, i.e. Cells can hold various data types, like strings, numbers, dates, times, boolean values, or formulas. The smallest entities in a spreadsheet are the cells which contain the data. The second CHM file available in the folder docs, fpspreadsheet-wiki.chm, is a snapshot of the FPSpreadsheet-related wiki pages bundled into a single help file.

#Lazarus free instals install#

If you did not yet install the package follow Please see section Stable releases for documentation on the stable version that you can download.Ī help file in CHM format can be found in the FPSpreadsheet installation folder docs. This wiki page covers the latest development/trunk version of FPSpreadsheet available via subversion.

8.3 Progress of workbook/worksheet user-interface options.

2.4.12.1 Disable printing of specific cells.

2.3.5 Extending FPSpreadsheet by user-defined formulas.

2.3.3 Shared formulas and array formulas.

#Lazarus free instals how to#

2.2.3.2 How to add and read data to/from a cell.