Better Method of Exporting Data to Excel?

Patrick

unread,

Mar 15, 2007, 5:19:46 PM3/15/07

to

I'm looking for a better method of exporting data to Excel. I export to
Excel using ReportBuilder (10.04), and the TextraDevices Addon. I also have
the latest tools from DevExpress (but I'm unfamiliar with all of
DevExpress's many components).

Here's what I do:
- The end-user queries/filters the data
- I show the data in a DevExpress TcxGrid
- The end-user then gets choice of reporting to PDF or Excel
- The PDF or Excel output (report) is created from a ReportBuilder
TppReport, and TExtraDevice.

Everything works, BUT the Excel document is version 4.00, and the document
needs additional column realignment.

Is there a better &/or cleaner way of getting the data to Excel?

ReportBuilder is FANTASTIC, but I'm not a fan of its Excel export options.

Delphi2006 Pro

thx--patrick

Franz-Leo Chomse

unread,

Mar 15, 2007, 5:31:23 PM3/15/07

to

On Thu, 15 Mar 2007 15:19:46 -0600, "Patrick"
<pdoh...@majorcustomcable.com> wrote:

>I'm looking for a better method of exporting data to Excel. I export to
>Excel using ReportBuilder (10.04), and the TextraDevices Addon. I also have
>the latest tools from DevExpress (but I'm unfamiliar with all of
>DevExpress's many components).
>
>Here's what I do:
>- The end-user queries/filters the data
>- I show the data in a DevExpress TcxGrid

Why don't you use the DevExpress Export Tools to create an Excel Sheet
from the Grid directly.

Regards from Germany

Franz-Leo

Patrick

unread,

Mar 15, 2007, 6:44:34 PM3/15/07

to

"Franz-Leo Chomse" <franz-le...@samac.de> wrote in message
news:rmejv21dau4blqbbf...@4ax.com...

DevExpress Export Tools? What tool palette is this in? Or is DevExpress
Export Tools it's own tool palette?
--patrick

Trevor Keegan

unread,

Mar 15, 2007, 6:22:56 PM3/15/07

to

Hello Patrick,

Take a look at SmExport www.scalabium.com/sme/index.htm

Regards
Trevor Keegan

Mike Shkolnik

unread,

Mar 15, 2007, 6:28:07 PM3/15/07

to

Patrick,

> DevExpress Export Tools? What tool palette is this in? Or is DevExpress
> Export Tools it's own tool palette?

There is the export package with published function (ExportGrid4ToExcel)
There are no published components, there are functions in export package
--
With best regards, Mike Shkolnik
Scalabium Software
http://www.scalabium.com
mshk...@scalabium.com

Raymond Schappe

unread,

Mar 15, 2007, 10:55:23 PM3/15/07

to

I purchased this solution and so far I am very happy with it!!!

They are very quick with support and very active with changes and
improvements.

http://www.nika-soft.com/

HTH,
-Raymond

John McTaggart

unread,

Mar 16, 2007, 1:01:17 AM3/16/07

to

> > Why don't you use the DevExpress Export Tools to create an Excel Sheet
> > from the Grid directly.
> >
> > Regards from Germany
> >
> > Franz-Leo
>
> DevExpress Export Tools? What tool palette is this in? Or is DevExpress
> Export Tools it's own tool palette?

It's not on the palette. Look for it in the..

DeveloperExpress.VCL\ExpressExport Library

..folder and in the help files..

ExpressQuantumTreeList4 | Base Concepts | Export

John McTaggart

Alan

unread,

Mar 16, 2007, 4:36:17 AM3/16/07

to

>
> DevExpress Export Tools? What tool palette is this in? Or is DevExpress
> Export Tools it's own tool palette?
> --patrick
>

Look at the post on the 5/12/06 in devexpress quantumgridv6 group. There
are a couple more.

Keith Blows

unread,

Mar 16, 2007, 5:54:26 AM3/16/07

to

Patrick wrote:

> I'm looking for a better method of exporting data to Excel.

List from least control, to maximum control over every cell:

- DevExpress's own Excel export functionality
- SMExport- http://www.scalabium.com/sme/index.htm
- XLSReadWriteII V3- http://www.axolot.com/components/xlsrwii20.htm

I have regularly used no. 1 & 2 with great success. Scalabium is also
an excellent company and regularly enhances their great product line.

Regards,
Keith Blows

--

Shane Stump

unread,

Mar 16, 2007, 8:47:19 AM3/16/07

to

Have a look @ Mike's SMExport component set:

http://www.scalabium.com/sme/index.htm

You will find it and it's companion component set (SMImport) to be quite
a bargain and EXCELLENT value to any developer's tool kit if you need to
import / export data.

Best regards,

Shane

Matthew Jones

unread,

Mar 16, 2007, 10:05:00 AM3/16/07

to

To complete the set, TMS have a good Excel reporting solution too.

/Matthew Jones/

Patrick

unread,

Mar 16, 2007, 3:42:42 PM3/16/07

to

Thx for all your posts. Using DevExpress, here's the code:
ExportGrid4ToExcel('C:\ExcelFile.xls', cxGrid1);