Hi,
I know that for AdvGrids there exists components/libraries to export grid to Excel,
how about nativeTDbGrid?
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:
- With the API. Take a look at Dumping a Dataset into Excel | FlexCel Studio for VCL and FireMonkey documentation
- 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
Hi Andrian,
thanks for reply.
Even tough grid has a little bit formatting it has couple things which prevents direct DB dump:
- Hiding columns
- set titles
- column order.
But I can write method for this.