5

I have a Delphi 2007 DBGrid that I'd like to allow the user to save in the newer Excel format (OOXML), but my criteria is that the user does not need to have Excel installed. Is anyone aware of any components that already do this? And yes, I did search already, but I have not found anything.

RRUZ
  • 134,889
  • 20
  • 356
  • 483
Mick
  • 13,248
  • 9
  • 69
  • 119

2 Answers2

2

Of the top of my head was TMS FlexCel Studio for VCL, but I was wrong. The current VCL version doesn't support xslx. Their .NET edition does support xslx, though...

So a quick google search pointed me to an EDN discussion that refers to these sites:

I have no knowledge about these products, but it might be worth a look...

Jørn E. Angeltveit
  • 3,029
  • 3
  • 22
  • 53
  • I tried the last free and open-source version of FlexCel, v2.5.3, and it did not support creating OOXML compliant files. I downloaded it here: ftp://shamir.crysys.hit.bme.hu/pub/dsp/ftp/d50free/flexcel.zip – Mick Apr 23 '11 at 17:26
  • Ok, my mistake. It's their .NET edition that supports xslx: http://www.tmssoftware.com/site/flexcelnet.asp – Jørn E. Angeltveit Apr 23 '11 at 17:34
  • 2
    I'd be very interested in any native Delphi component that could output OOXML formats – David Heffernan Apr 23 '11 at 18:21
  • @David: I agree, hence the up-voting of the question. I could swear that TMS supported ooxml, but I was obviously wrong... NikaSoft's NativeExcel and Scalabium's TSMExportToXLSX seems to support this, so I'm going to have a closer look at these some day. – Jørn E. Angeltveit Apr 23 '11 at 18:40
0

Look at NativeExcel v3 from NikaSoft. It claims to support XLSX format.

I have v2 which only supports XLS format. It provides classes that mimic the Excel object model (sufficient for my needs) and includes components that export TDBGrid and TDataset. I have used it with D7, D2007, and DXE.

crefird
  • 1,590
  • 11
  • 17