Names fields in the XLS-table created DC_WorkArea2Excel

[Eugene Lutsenko]

Tell me, please: is it possible to make a Russian column names in the XLS-table created using the DC_WorkArea2Excel(), and, if possible, how to do it? It is necessary that the column names are self-explanatory, XLS-file, ie did not coincide with the names of the fields exported to MS Excel database.

[rdonnay]

Of course, it is possible but not with the DC_WorkArea2Excel() function written as it is.

You have the source code and you can copy it and modify it to your needs.

[Eugene Lutsenko]

You know, Roger, I did myself did not expect this, but added another parameter: aColumnNames your function DC_WorkArea2Excel(): an array with the names of the speakers, and began to take their names not from the array structure (where field names), and from this array, and all immediately received ! Thank you so much!

Just replace the line

Code: Select all

cHeader := aFields[i,2]

on the line

Code: Select all

cHeader := aColumnNames[i]

And no longer does anything!

We must, of course, is to remove the blank line after the name of the field and make the field size on the actual content