Page 1 of 1

Names fields in the XLS-table created DC_WorkArea2Excel

Posted: Sat Sep 20, 2014 12:45 pm
by 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.

Re: Names fields in the XLS-table created DC_WorkArea2Excel

Posted: Sun Sep 21, 2014 10:13 am
by 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.

Re: Names fields in the XLS-table created DC_WorkArea2Excel

Posted: Sun Sep 21, 2014 1:25 pm
by 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