XLSReadWriteII 5.20.00

In category

DB-Aware Components > Direct DB Access > MS Excel

Description

XLSReadWriteII is a component for reading and writing Excel files. XLSReadWriteII is a native Delphi component; you don't need any other files or software in order to use it. Not even Excel. XLSReadWriteII works as an invisible grid component. All cells are always accessible, and can also be moved, deleted or copied.

One of the major goals was to create a product that don't corrupts the Excel files and don't alter any data in the file. With XLSReadWriteII, you can always be sure that your Excel files can be read by Excel after you have edited them, and no data has been unexpected removed.

Here are some of the advantages that you will have with XLSReadWriteII:

• Read, write and modify any Excel file.
• Read and write any cell values. Cells with multiple fonts formatting (Rich text) can be read and written directly to/from RTF files.
• 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 and whole worksheets can be calculated and the calculation engine will calculate dependent cells, if there are any.
• Easy cell formatting, where the format properties are accessible trough the cell object. Whole ranges of cells can also be formatted, so it is easy to put a border around an area of cells.
• XLSReadWriteII has full support for Unicode. As all strings are WideString, you will not have any problems with non-English characters.
• Cell notes and text boxes are supported.
• All printing options are accessible.
• Control objects, such as list boxes, combo boxes, buttons etc. can used.
• Support for all kinds of drawing objects.
• Charts can be created with the same options as in Excel.
• Named cells and areas can be used. When a named cell is created, it can easily be accessed trough it's name.
• All types of hyperlinks are supported.
• Password protected (encrypted) files can be read and written.
• Read and write VBA macros. Macros can also be assigned to controls, pictures etc.
• Autofilters.
• You can also use: Cell validations, Conditional formats, Merged cells and more...

Several sample projects are included.

XLSReadWriteII is fast. Write 1,000,000 cells in less than a second.

The XLSReadWriteII package also include import methods for:

• Any TDataset database.
• Open Office Calc documents.
• CSV and other text files. Characters for field separator, decimal separator and text quote character are detected automatic.
• HTML tables (TABLE tag).

Data can be exported to:

• CSV text files.
• HTML files.

Informations

• Status: With Nag-Screen
• Source: SW
• Price: $433
• Exe demo: included
• Size: 7079223 - 18212654kB

Platforms:

• C++ Builder 2006
• Delphi 2006 (Win32)
• C++ Builder 2007
• Delphi 2007 (VCL)
• CBuilder 2009
• Delphi 2009
• C++ Builder 2010
• Delphi 2010
• Delphi 5
• Delphi 6
• Delphi 7
• C++ Builder XE
• Delphi XE
• C++ Builder XE2
• Delphi XE 2
• C++ Builder XE3
• Delphi XE3
• C++ Builder XE4
• Delphi XE4
• C++ Builder XE5
• Delphi XE5
• C++ Builder XE6
• Delphi XE6
• C++ Builder XE7
• Delphi XE7
• C++ Builder XE8
• Delphi XE8

Downloads

• C++ Builder 2006 , Delphi 2006 (Win32)
• C++ Builder 2007 , Delphi 2007 (VCL)
• CBuilder 2009 , Delphi 2009
• C++ Builder 2010 , Delphi 2010
• Delphi 5
• Delphi 6
• Delphi 7
• C++ Builder XE , Delphi XE
• C++ Builder XE2 , Delphi XE 2
• C++ Builder XE3 , Delphi XE3
• C++ Builder XE4 , Delphi XE4
• C++ Builder XE5 , Delphi XE5
• C++ Builder XE6 , Delphi XE6
• C++ Builder XE7 , Delphi XE7
• C++ Builder XE8 , Delphi XE8