Export to excel (.xls) format with delphi

With Advanced Data Export VCL we can exporting data data into MS Access, MS Excel, MS Word (RTF), Open XML Format, Open Document Format (ODF), HTML, XML, PDF, TXT, DBF, CSV and more!
in the export of data can be obtained from several sources including:

• datasource
• dbgrid
• listview
• stringgrid
• custom

In this article I will only discuss the export of data using a datasource and db grid only in to xls format.

but for export to other formats are similar, select the components appropriate to stay the desired format.

xls export to the data source
in this discussion I do not discuss how we create the database. here I use the virtual table.

Step by step :
create a new project

• components enter the virtual table can not have use the table and connect to the database you have created.
• pairs datasource
• pairs of components dbgrid
• pairs QExport4XLS from tab EMS Advanced Data Export
• pairs Button and change properties captions "Export"
• pairs savedialog from dialogs tab
  

UNDER CONSTRUCTIONS

Advanced Data Import VCL

Advanced Data Import VCL is a component suite for Borland Delphi and C++ Builder that allows you to import data from files of the most popular data formats to the database. You can import data from MS Excel, MS Access, DBF, XML, TXT, CSV, ODF and HTML. There will be no need to waste your time on tiresome data conversion - Advanced Data Import will do the task quickly, irrespective of the source data format.

Key Features

• Data import from the most popular data formats: MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, OpenDocument format (ODF) and HTML
• Import of Unicode data (UTF-8, UTF-16/UCS-2, UTF-32/UCS-4). Automatic detection and manually preset text encoding for imported data
• Powerful component and property editors, which allow to set many import parameters at the design-time easily
• High productivity even on slow computers
• Adjustable parameters for each type of import
• 100% native Delphi code for MS Excel 97, DBF, TXT, CSV - no additional libraries or programs needed for the components to work. OLE, DDE, BDE etc not required either
• Detailed help system and a demo application for a quicker mastering of the product
• Borland Delphi 5-7, 2005, 2006, CodeGear Delphi 2007, 2009 and Borland C++ Builder 5-6, CodeGear C++ Builder 2007, 2009 support

Screenshots

Download Trial

EMS Advanced Data Export VCL

Advanced Data Export VCL form EMS is a component suite for Borland Delphi and C++ Builder that allows you to save your data in the most popular data formats for the future viewing, modification, printing or web publication. You can export data into MS Access, MS Excel, MS Word (RTF), Open XML Format, Open Document Format (ODF), HTML, XML, PDF, TXT, DBF, CSV and more! There will be no need to waste your time on tiresome data conversion - Advanced Data Export will do the task quickly and will give the result in the desired format.

Key Features

• Data export into 17 most popular formats: MS Access, MS Excel, MS Word, Open XML Format, Open Document Format (ODF), RTF, HTML, XML, PDF, TXT, DBF, CSV, SYLK, DIF, LaTeX, SQL and Windows Clipboard
• Borland Delphi 5-7, 2005, 2006, CodeGear Delphi 2007, 2009 and Borland C++ Builder 5-6, CodeGear C++ Builder 2007, 2009 support
• Export of Unicode data. Manually preset text encoding for exported data (UTF-8, UTF-16/UCS-2, UTF-32/UCS-4, Latin1, Latin2, Latin5, Latin7 and more)
• Saving data for future viewing, modification, printing or web publication
• Easy-to-use wizard allows your end-users to export data quickly
• Powerful export options for each data format
• 100% native Delphi code
• No additional libraries or software required to operate
• Detailed help system and demo application
• Powerful components and properties editors
• Setting the user formats for each field separately
• Multilanguage support

Easy-to-use wizard interface







Download Trial

Delphi 2009

Delphi is the premier development environment for software developers and database application developers who need to rapidly deliver high performance and easy to maintain software applications.

• Increase your productivity with time saving IDE and tools
• Speed development with visual, drag-and-drop tools and powerful component library
• Easily connect with all you data sources and tiers
• Increase performance and productivity with the powerful Delphi language, a fast compiler and full Windows API access

Use the powerful Delphi IDE with its visual design surface, extensive component universe and powerful heterogeneous database framework to visually design and deliver applications in a fraction of the time. The powerful Delphi language and compiler deliver high performance and access to all the power and speed of native Windows development. Delphi also provides a comprehensive set of editing, refactoring, and debugging tools in a complete solution focused on making development faster and easier.

What's New

• Give your user interfaces a fresh, updated look with new and enhanced VCL controls.
• Build applications that handle global data with ease using new Unicode support throughout the IDE and VCL
• Move your code into the future with the addition of generics and anonymous methods to the Delphi language
• Build powerful, efficient and secure database applications by separating data and business logic with new DataSnap
• Get new insight into your database structures with data modeling and visualization in the all new Delphi Architect Edition

Product Editions:

• Delphi 2009 Professional - The high performance Windows visual IDE and framework designed for building packaged, desktop, and workstation applications quickly and easily.
• Delphi 2009 Enterprise - Includes everything in the Professional edition, plus tools for building client/server and multi-tier database and web applications.
• Delphi 2009 Architect - Includes everything in the Enterprise edition, plus powerful database modeling and design capabilities

For more detailed differences between the editions, see the Datasheet and Feature Matrix.

Related Products

• CodeGear™ RAD Studio
  Combines Delphi 2009, C++Builder 2009, and Delphi Prism 2009 to provide a complete solution for native Windows and .NET application development.
• C++Builder®
  Combines the power of the C and C++ languages and libraries with the productivity of visual rapid application development.
• InterBase® SMP
  Highly scalable, powerful, embeddable database.
• Blackfish™ SQL
  Fully managed, SQL-compliant, highly portable, embedded database.
• ER/Studio®
  Data modeling tool for designing and understanding your databases.
• Embarcadero® All-Access™
  Instant access to the languages, tools, and technologies to design, build, and run your software applications and database systems.

Download Trial

About Delphi Programming

Delphi is a powerful development environment used primarily to build client/server applications for Microsoft Windows, with an emphasis on databases. Based on Object Pascal, it is object-oriented and was designed to give developers the ability to build applications easily, with minimal coding required. Delphi Produced by Borland International.
In short, Delphi is a programming language one can use to create Windows (and even Linux ) applications (software programs).

What's the latest Delphi version?

The latest Delphi version is Delphi 2009. If you are to count Delphi versions from Delphi 1 (way back in 1995) up to today - you'll find out that Delphi 2009 is version number 12. Up to Delphi 8, every Delphi had a version number in its name. With Delphi 2005 (that is Delphi 9) the naming has changed.

What is CodeGear RAD Studio 2009?

Latest version. RAD solution for native Windows and .NET. Includes Delphi 2009, C++Builder 2009, and Delphi Prism 2009.