XLSReadWriteII Excel component for reading and writing
Download

XLSReadWriteII Ranking & Summary

XLSReadWriteII Tags

development Library Component excel component read Excel excel library

XLSReadWriteII Description

Access Excel Files With Delphi and C++ Builder Features: * Native access to Excel files. The user doesn't need to have Excel, or any other software installed. * XLSReadWriteII works as an invisible Excel workbook. All cell values are always accessible. * Stability. One of the major goals with XLSReadWriteII was to create a product that won't corrupt the Excel files and won't alter any data in the file. * XLSReadWriteII is easy to use. With the formatting interface, you can format cells through a cell object. * Fast and efficient support when you have any questions. * No runtime fees for the component. * Full source code included. Read and write any cell values... * Numeric, string, boolean and error cells. But what about date and time cells? There are no such cells in Excel. Excel store date and time values in the same way as Delphi, i.e. as floating point numbers. What make's it a date or time value, is the formatting. * Full support for formulas. You can use the same functions as in Excel. Formulas with references to external workbooks are supported as well. You can even read the result from an external reference * Cells are accessed in the same way as the TStringGrid that comes with Delphi, or by giving the cell as a string, like: 'D7'. * Read cell values as a string formatted according to the rules of the cell. Performance * XLSReadWriteII is designed with optimal performance in mind. As Excel 2007+ files permits up to 16,000 x 1,000,000 cells, performance is important. * Read and write speed of Excel 2007+ files at least twice as fast as Excel. As these files are compressed XML files both decompressor anb XML parser must be fast. * XLSReadWriteII uses it's own memory manager. Memory usage shall not be more than half of what Excel uses, and most times it's much less than that. * Due to the fact that pre Excel 2007 files are binary file, these files are read and written much faster. Format the cells as you want... * Formatting is easy. By addressing the cell, you can access the formatting properties for it. Example: XLSReadWriteII.Sheet.Cell.FontSize := 12; * XLSReadWriteII has objects for formatting a worksheet in the same way as the Excel Format Cells dialog. You can format cells or areas of cells in the same way as Excel. * Support for all Excel formatting options. * Use merged cells. Access all printing options... * Select paper size, set margins. * Set header and footer, including formatting codes. * Define printing areas. * Set page breaks. XLSReadWriteII has full support for unicode. As all strings are Unicode, you will not have any problems with non-English characters. Direct Read and Direct Write. You can read and write cells directly from the file, without storing them in memory. As an Excel 2007+ file can contain up to 16 billion cells this ca be important if you want to save memory. Drawing objects. Insert all kinds of drawing objects, from simple lines to AutoShapes. Cell notes and text boxes. Create and edit text boxes and cell notes as you want. Charts. Create charts with the same options as in Excel. Copy/Move/Delete * Cells can be copied, moved and deleted with the same behavior as in Excel. * Rows and columns can be copied and moved as well. * Copy/move between sheets are supported. * Entire sheets can be copied. Use named areas/cells. * Names can be used where you want. * Access cells through their name is easy. Example: XLS.NameAsFloat := 202.5; * Support for special, built in names. All types of hyperlinks are supported. * Web and e-mail address. * Local files. * Server files. * Worksheet references Encrypted documents. You can read and write encrypted files. This assumes of course that you know the password for the file you reads. Calculation. * Fast calculation engine with support for all standard Excel furmulas. * The calculation engine will calculate dependent cells, if there are any. * Referrences to external workbooks will be read. This is performed with a special fast seek routine. VBA Macros. Macros in files can be read and written Macros that are created with XLSReadWriteII can be assigned can be assigned to control objects such as buttons, combo boxes etc. .

XLSReadWriteII Related Software