Need to read XLS without DAO, BDE, OLE' or any DLL, OCX

Normand Peladeau

unread,

Feb 18, 2002, 3:51:22 PM2/18/02

to

I am looking for a delphi component to read Excel files. I have a strong
preference for a pure VCL solution (or maybe small DLL files).

Any suggestion?

Normand Peladeau

P.S. I have tried TXLSReadWrite, but, unless its author can fix existing
problems and limitations, this component is not good enough for me.

Normand Peladeau

unread,

Feb 18, 2002, 5:32:57 PM2/18/02

to

Unfortunately, it is only compatible with D5 or D6 and the application in
which I want to add this was written in D3 (can't move it now to D6).

Any other suggestion?

Normand

"Eddie Shipman" <eshi...@austindot.rrdot.com> wrote in message
news:MPG.16db2d7df...@forums.borland.com...
> In article <3c716946$1_1@dnews>, pela...@nospam.simstat.com says...

> TmxNativeExcel By Lajos Farkas.
> "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
> Fully functional
> Source: On request
>
> Download: http://www.torry.net/db/direct/msexcel/mxnaticeexcel.exe
>
>

Franz-Leo Chomse

unread,

Feb 18, 2002, 7:09:31 PM2/18/02

to

On Mon, 18 Feb 2002 15:51:22 -0500, "Normand Peladeau"
<pela...@nospam.simstat.com> wrote:

>I am looking for a delphi component to read Excel files. I have a strong
>preference for a pure VCL solution (or maybe small DLL files).
>
>Any suggestion?

Just impossible. The internal structure of an Excel file is never
published by MS. The new versions do not use a plain file format
anymore, but OLE structured storage. So you need OLE to get
to the single blocks which build the Excel file.

The last single file solution was the BIFF format, but each version
which supports VBA uses structured storage.

Regards from Germany

Franz-Leo

kangelos

unread,

Feb 18, 2002, 9:11:34 PM2/18/02

to

You shouldn't bother, Excel is now so highly ole driven that you need a good
ocx/vcl to read/write. Use the
components from Scalabium (http://www.scalabium.com/) SMExport and SMImport.
they are bullet-proof.
HTH
kangelos
"Normand Peladeau" <pela...@nospam.simstat.com> wrote in message
news:3c716946$1_1@dnews...

Edwin Walker

unread,

Feb 18, 2002, 9:21:43 PM2/18/02

to

http://www.scalabium.com/

Is one, there are also some on www.torry.net and www.delphipages.com

I seen, but never got a chance to do it, you can read from an excel file
using ADO.

I know of a VB programmer who has done this with VB, so I assume that you
can do it with Delphi.

Edwin

"Normand Peladeau" <pela...@nospam.simstat.com> wrote in message
news:3c716946$1_1@dnews...

Eddie Shipman

unread,

Feb 18, 2002, 4:26:31 PM2/18/02

to

In article <3c716946$1_1@dnews>, pela...@nospam.simstat.com says...

TmxNativeExcel By Lajos Farkas.

Mike Shkolnik

unread,

Feb 19, 2002, 8:49:35 AM2/19/02

to

Check my SMImport suite. There you'll find TSMImportFromXLS component which
allow to read xls-workbook without installed MS Excel application

There published component for data loading into Dataset but internal engine
allow to load a data into any control (TStringGrid, for example)

--
With best regards, Mike Shkolnik
E-Mail: mshk...@scalabium.com
mshk...@yahoo.com
WEB: http://www.scalabium.com

Normand Peladeau <pela...@nospam.simstat.com> пишет в
сообщении:3c716946$1_1@dnews...

Mike Shkolnik

unread,

Feb 19, 2002, 8:47:43 AM2/19/02

to

This is only a part of thruth. Format of Excel 97 is published in MSDN a few
years ago but later these topics were extracted from MSDN...

But rest is a truth - Excel workbook (and Word dcoument) is a set of blocks
in OLE storage (starting from MS Excel 4).

--
With best regards, Mike Shkolnik
E-Mail: mshk...@scalabium.com
mshk...@yahoo.com
WEB: http://www.scalabium.com

Franz-Leo Chomse <franz-le...@samac.de> пишет в
сообщении:cm537uskme8d8r7g2...@4ax.com...