Export DBGrid

FLX TMS FlexCel for VCL & FMX
1

Hi,
I know that for AdvGrids there exists components/libraries to export grid to Excel,
how about nativeTDbGrid?

2

Hi,
We don't have a component for a TDBGrid, but that's because a TDBGrid doesn't have a lot of formatting, so instead of exporting the grid, you can export directly the db where the DBGrid gets the data.

You can export the db in 2 ways:

  1. With the API. Take a look at Dumping a Dataset into Excel | FlexCel Studio for VCL and FireMonkey documentation
  2. Via Reports. This is if you want more formatting in the results. For a simple export via reports, see Generic reports (Delphi) | FlexCel Studio for VCL and FireMonkey documentation
3

Hi Andrian,
thanks for reply.
Even tough grid has a little bit formatting it has couple things which prevents direct DB dump:

  1. Hiding columns
  2. set titles
  3. column order.
    But I can write method for this.