Description

CyExcel is Multi-Page Excel component.

Informations

• Status: Fully functional
• Source: Included
• Size: 308kB

Platforms: D6

Description

This component allows send data from Dataset to Excel sheet and formatting it.

Allows to create formula references data in Excel sheet. Allows to create charts references data in Excel sheet.

And more...

Informations

• Status: With Nag-Screen
• Source: N/A
• Size: 698kB

Platforms: D5

Description

NativeExcel is a high-performance solution for Delphi Developers that allows writing of new Excel spreadsheets and reading of existing ones. NativeExcel does not require installed Microsoft Office, it writes and reads excel files directly. NativeExcel can be used as the replacement of standard Excel components, it has the same object model, properties and methods.

With NativeExcel you can open and modify an existing spreadsheet.

Advantages:

• High performance (30000-40000 values per second)
• Convenient object model
• Support for all Excel formatting options
• Microsoft Office is not required
• Compatibility with standard Delphi's Excel components
• TDataset2Excel component. Populates a spreadsheet from TDataset descendants
• TDBGrid2Excel component. Populates a spreadsheet from TDBGrid descendants

Features:

• Open an existing excel file
• Access any cell values (number, string, date, formula)
• Calculation engine to perform computation on the cells
• Cell attributes (alignment, orientation, comments, borders, background attributes, and so on)
• Font attributes (font name, font size, color, decoration, and so on)
• Merged cells
• Images
• It preserves existing charts
• Unicode characters support
• Copy/Move/Delete/Insert range of cells
• Group/Ungroup rows and columns
• Worksheet attributes (name, protection, selection, and so on)
• Printing attributes (page size, orientation, margins, footer, header, page breaks, and so on)
• Exporting workbooks and worksheets to HTML, RTF, CSV, TSV files.

Informations

• Status: Trial (work while IDE is running)
• Source: On purchase/registration
• price: $80
• Size: 11 247kB

Platforms: D2005, D2006, D2007, D2009, D2010, D4, D5, D6, D7, DXE, DXE2, DXE3, DXE4

Description

T(Adv)Excel is the Excel 4/5/7/8 DDE driver + data transfer component. Orders of magnitude faster than OLE automation or any other known mechanism.

Online help and code for extremely high data transfer rates (1000+ items in less than 25 milli seconds on a PII) are available.

Informations

• Status: Fully functional
• Source: Included
• Size: 303kB

Platforms: CB1, CB3, D1, D2, D3, D4

Description

TExcel is a component to produce output tables directly into MS Excel, including formatting, commands, macro calls, etc. Demo project is attached to show how easy to drive it.

Informations

• Status: Fully functional
• Source: Included
• Size: 21kB

Platforms: D1, D2, D3

Description

This Delphi component can be used to add/ remove/ configure Microsoft Excel Datasource Names (DSNs) on the fly, using just one line of code.

Informations

• Status: With Nag-Screen
• Source: On purchase/registration
• price: $29.99
• Source price: $49.99
• Size: 120kB

Platforms: D4, D5, D6

Description

This is a very fast component to "live" send export data from TDataSource or TDBGrid or TDataSet to MsExcel. 39000 rows x 43 fields abot 10sec. Possible export selected fields, constans, renamed fields, save to file. MsExcel required. Very fast and usefull. Full source code.

Simple checker (demo) of component added.

Informations

• Status: Fully functional
• Source: Included
• Size: 33kB

Platforms: D6, D7

Description

You can create Excel BIFF files ( v2.1, v3, v4, v5 ). Its code 100% Native, so you do not need to have installed Office, OCX or other tools.

This component supports:

• Fonts
• Headers and Footers
• Label, Integer, Double, Boolean, BoolErr fields
• Alignment settings
• Borders
• Shading
• Sheet and cell protection.

Informations

• Status: Fully functional
• Source: Included
• Size: 289kB

Platforms: D2005, D2006, D2007, D2009, D5, D6, D7

Description

TXlsFile component produces a very old Excel file format (2.0) so any Excel version can open it.

Demo exe shows most of its features (put data into cells with alignment, set colums width, create XLS file, open Excel).

Informations

• Status: Fully functional
• Source: Included
• Size: 351kB

Platforms: D2005, D2006, D6, D7

Description

TXLSFile is a Delphi library for reading and writing of Microsoft Excel XLS files.

It is based on direct reading and writing of files, and works without OLE Automation with Microsoft Excel.

• Reading and writing speed is about 75 000 cells per second.
• TXLSFile supports MS Excel 97, 2000, XP, 2003 format (BIFF8).
• XLS files produced by TXLSFile may be opened in OpenOffice.
• TXLSFile is distributed as Borland Delphi source code which is compatible with Borland Delphi 3-2007.
• Contains functions for export of Excel data to HTML, TXT.
• Contains XLSExport components for quick export of TDBGrid, TDataSource, TStringGrid components to Excel file.

Informations

• Status: Trial (work while IDE is running)
• Source: On purchase/registration
• price: $85
• Size: 633kB

Platforms: D2009, D2010, DXE, DXE2, DXE3, DXE5, D2005, D2006, D2007, D3, D4, D5, D6, D7

Description

Write directly to simple XLS file format (BIFF5). It fast because it doesn't need OLE, DDE, or event MS-Excel. XLSfile can be used for write raw data, and OLE/DDE to format it.

Informations

• Status: Fully functional
• Source: Included
• Exe demo: included
• Size: 127kB

Platforms: D3

Description

XLSMini is a mini version of XLSReadWriteII. With XLSMini you can read and write cell values, including formulas. The basic concept is the same as in XLSReadWriteII, but access is limited to cell values. When you edit an Excel file with XLSMini, all other data remains unchanged, except changed cells.

Informations

• Status: With Nag-Screen
• Source: On purchase/registration
• price: $99
• Size: 1 039kB

Platforms: C2k6, D2006, CB5, CB6, C2k7, D2007, D2005, D5, D6, D7

Description

High performance component for easy access to Excel XLS and XLSX files.<

Native access to Excel files. The user does not need to have Excel, or any other software installed.

XLSReadWriteII uses it's own memory manager that is optimized for storing cell values. This means that you can work with larger files. If your files still not will fit in memory, there is a Direct Read and Direct Write modes that let you process files on disc.

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. The engine that handles XLSX files is automatically built directly from the file format specifications with our special developed tool. This will ensure maximum compatibility.

No runtime fees for the component.

Full source code included.

Key features:

Read and write any cell value... Numeric, string, boolean and error cells. 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 and 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.

Calculation: Fast calculation engine with support for all standard Excel formulas. The calculation engine will calculate dependent cells, if there are any.

You can also work with: Charts, Pivot tables, Encrypt, Import, Export and much more.

Informations

• Status: With Nag-Screen
• Source: Included
• price: $315
• Size: 7 488kB

Platforms: C2k6, D2006, C2k7, D2007, C2k9, D2009, C2k10, D2010, D6, D7, C10, D10, C10.1, D10.1, C10.2, D10.2, CBXE, DXE, CBXE2, DXE64, CBXE3, DXE3, CBXE4, DXE4, CBXE5, DXE5, CBXE6, DXE6, CBXE7, DXE7, CBXE8, DXE8

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: On purchase/registration
• price: $433
• Exe demo: included
• Size: 6 913kB

Platforms: C2k6, D2006, C2k7, D2007, C2k9, D2009, C2k10, D2010, D5, D6, D7, CBXE, DXE, CBXE2, DXE2, CBXE3, DXE3, CBXE4, DXE4, CBXE5, DXE5, CBXE6, DXE6, CBXE7, DXE7, CBXE8, DXE8

Description

XLSSpreadSheet is a native Delphi component for viewing Microsoft Excel files. With XLSSpreadSheet, you can see Excel files just as they looks in Excel itself. The component don't need any other software or libraries to be installed.

XLSSpreadSheet works togheter with XLSReadWriteII, wich also is included. XLSSpreadSheet is easy to use. If you are familiar with XLSReadWriteII, you allready have the knowledge that's needed, as all control of the Excel data is trough the XLSReadWriteII object of XLSSpreadSheet.

The latest version of XLSReadWriteII is included when you purchase XLSSpreadSheet. XLSSpreadSheet also comes with components for printing and print preview.

You should have XLSReadWriteII installed to try this component.

Informations

• Status: Trial (work while IDE is running)
• Source: On purchase/registration
• price: $640
• Size: 5 176kB

Platforms: C2k6, D2006, C2k7, D2007, C2k9, D2009, C2k10, D2010, D7, CBXE, DXE, CBXE2, DXE2, CBXE3, DXE3, CBXE4, DXE4, CBXE5, DXE5, CBXE6, DXE6, CBXE7, DXE7, CBXE8, DXE8