1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Donation with Paypal!!!

    Go to your paypal account and send directly donation to en[email protected]

    1 month - 10 $ - Standart VIP

    6 months - 20 $- Standart VIP

    1 year - 30 $- Standart VIP

    2 years - 50 $- Standart VIP

    Gold member for life - 150 $- Standart VIP

    High Vip (Standart VIP include) group please send PM or email to [email protected] for info

    After Donation please send email to [email protected]

  3. Donation Ways 2020


    Paysend
  4. Telegram
Dismiss Notice

Donation with Paypal!!!

Go to your paypal account and send directly donation to [email protected]

1 month - 10 $ - Standart VIP

6 months - 20 $- Standart VIP

1 year - 30 $- Standart VIP

2 years - 50 $- Standart VIP

Gold member for life - 150 $- Standart VIP

High Vip (Standart VIP include) group please send PM or email to [email protected] for info

After Donation please send email to [email protected]

Dismiss Notice
For open hidden message no need write thanks, thank etc. Enough is click to like button on right side of thread.

TSCExcelExport 4.25 (November 2014)

Discussion in 'Delphi Components,Freeware, Open Source' started by AdminDF, Jul 6, 2015.

  1. AdminDF
    Online

    AdminDFAdminDF is a Verified Member Delphifan Staff Member DF Staff

    TSCEXCELEXPORT

    Version 4.25 (November 2014) - freeware for non-commercial use - Delphi VCL

    This TscExcelExport component is an advanced, powerful but easy to use component which enables you to export all records of a dataset from Borland/Codegear/Embarcadero Delphi to Microsoft Excel. Many features are provided to change the layout, use conditional formatting, to add totals, to create groups, to set a filter, ... The component works in Delphi 5, 6, 7, 2006, 2007, 2009, 2010, XE, XE2, XE3, XE4, XE5, XE6 and XE7 (32 and 64 bit) and it supports Excel 97, 2000, XP, 2003, 2007, 2010 and 2013.

    Features

    Properties

    All kinds of settings to modify the layout of the worksheet are provided.
    Name of worksheet and file
    Header and footer texts
    Begin row and column of header, footer, titles (=fieldnames) and data (fieldvalues)
    Width of columns or autofit
    Font of header, footer, titles, summary and data (Alignment, WrapText, Orientation, MergeCells)
    Backgroundcolor and borders of header, footer, titles, summary and data
    Summaries for numeric or given fields (SUM, MIN, MAX, AVG, COUNT)
    AutoFilter for titles
    Create groups with given fields
    Create new worksheets are reuse existing files
    Access to the Excel objects (ExcelApplication, ExcelWorkbook, ExcelWorksheet, …)
    ...
    Events

    To define the background color and font color, size, name and bold style of each cell
    For exporting/writing data without using a TDataset
    Methods

    Export to Excel
    Save worksheet as XLSX (Open XML), XLS, HTML, XML or CSV
    Show print preview
    Component editor

    The component editor can be used to change some settings on an easy way.
    Live templates

    Live templates for all Delphi versions since 2006 (ExcelExportUse and ExcelExportCreate)


    Info

    Type library / COM

    This ExcelExport component uses the Office server components from the Borland/CodeGear/Embarcadero COM type library to implement OLE automation.
    By using compiler directives (in unit scExcelExportConfig.inc) you can override the default type library. The available libraries are Excel97, Excel2000, ExcelXP and Excel2010.
    Microsoft Excel should be installed on the PC when using this component.
    Delphi / Office

    This VCL component was tested in
    Borland Delphi 5 (SP1)
    Borland Delphi 6
    Borland Delphi 7
    Borland Delphi (BDS) 2005
    Borland Delphi (BDS) 2006
    CodeGear Turbo Delphi
    CodeGear Delphi 2007
    CodeGear Delphi 2009
    Embarcadero Delphi 2010
    Embarcadero Delphi XE
    Embarcadero Delphi XE2
    Embarcadero Delphi XE3
    Embarcadero Delphi XE4
    Embarcadero Delphi XE5
    Embarcadero Delphi XE6
    Embarcadero Delphi XE7
    This ExcelExport component works with
    Microsoft Excel 97
    Microsoft Excel 2000
    Microsoft Excel XP
    Microsoft Excel 2003
    Microsoft Excel 2007
    Microsoft Excel 2010
    Microsoft Excel 2013
    It has been tested with Dutch and some English Office versions.
    It will also give you access to the Excel Application, Workbook and Worksheet objects so you can access all VBA properties and methods.

    Hidden Content:
    **Hidden Content: You must click 'Like' before you can see the hidden data contained here.**
    Examples:
    Hidden Content:
    **Hidden Content: You must click 'Like' before you can see the hidden data contained here.**
     
  2. bitsebytes
    Online

    bitsebytes Guest

    RE:

    thanks
     
  3. mahboul
    Offline

    mahboul DF Junior

    RE:

    thanks
     
  4. nabob_09
    Offline

    nabob_09 DF Member

    RE:

    thanks
     
  5. sascha
    Online

    sascha Guest

    thanks
     
     
  6. ivanvillanuevaa
    Offline

    ivanvillanuevaa DF Member

  7. vmoncayo
    Offline

    vmoncayo DF Junior

    thanks
     

Share This Page