CSV Export

steven_healey · February 10, 2014, 9:05am

Is there any way to export the column headings with the data .

I am exporting sales invoices and the data is accurate , the data is rejected when imported into sage account because there are no column headings.

Is there a way to do this ?

Eg

accountnumber ,transactiondate,invoicenumber , amount

A103,15/12/2012,2014001,212.22

tms_Nancy · February 10, 2014, 9:14am

You can control this with properties:

Grid.SaveFixedCells: Boolean;
Grid.SaveFixedRows: Boolean;
Grid.SaveFixedCols: Boolean;

Please see the PDF developers guide in the Import/Export chapter that explains this.

steven_healey · February 10, 2014, 9:23am

Thank you .

How do I set a fixed row ?

tms_Nancy · February 10, 2014, 9:26am

AdvStringGrid1.FixedRows := 1;

steven_healey · February 10, 2014, 9:37am

thank you again , that is exactly what I needed .

Sometimes it is the simple things that are hard to find