Export query results to flat file or CSV?
Export query results to flat file or CSV?
Hi,
I was wondering if there is a (generic) easy way of exporting all column + rows in a MyQuery to a CSV (or even excel..) file?
Thanks in advance,
Sean
I was wondering if there is a (generic) easy way of exporting all column + rows in a MyQuery to a CSV (or even excel..) file?
Thanks in advance,
Sean
hi sean, you can use EMS QuickExport / Quickimport components...
or this one (more powerfull) , it is free for non commercial apps :
http://www.scip.be/index.php?Page=Compo ... anguage=EN
or this one (more powerfull) , it is free for non commercial apps :
http://www.scip.be/index.php?Page=Compo ... anguage=EN
On a similar vein, is there a way of accessing TCRDBGrid cell values, as opposed to the underlying dataset? I've spent hours looking through the various properaties and see many options for setting column specific things like filed names, titles etc, but not for iterating through each row and column.
If rows are selected, "SelectedRows" would seem to allow access to all values, but what about all rows?
i.e. I'd like to use something like
CRDBGrid.Row.Column[j].AsString
Thanks in advance..
If rows are selected, "SelectedRows" would seem to allow access to all values, but what about all rows?
i.e. I'd like to use something like
CRDBGrid.Row.Column[j].AsString
Thanks in advance..
As regards EMS QuickExport noted above, it does look quite interesting, and even the commercial version is not expensive. But I can also do this (granted with more effort) with Excel Server components.
I use Grid method GetCellParams to change the values & colours of some celles as displayed in the grid, and also set title etc. of course I could do this all over again using Excel and the Dataset, but I'm coming across the situation often now where I make a Grid and would like to export exactly to Excel.
I use Grid method GetCellParams to change the values & colours of some celles as displayed in the grid, and also set title etc. of course I could do this all over again using Excel and the Dataset, but I'm coming across the situation often now where I make a Grid and would like to export exactly to Excel.
Hi,
I'm back to this problem, for another project, almost a year later: how to dump the contents currentl shown in a Gid, so that I can for example export it to excel.
I've never worked with 'copy and paste', and was there a way to perhaps highlight several rows, right click and do "copy" or something?
==> Could you have any same code on how to access the rows and columns of several rows that have been highlighted?
Thanks.
I'm back to this problem, for another project, almost a year later: how to dump the contents currentl shown in a Gid, so that I can for example export it to excel.
I've never worked with 'copy and paste', and was there a way to perhaps highlight several rows, right click and do "copy" or something?
==> Could you have any same code on how to access the rows and columns of several rows that have been highlighted?
Thanks.