Excel

[omni]

Roger,

We have a user that wants a daily report with extensive headers (3 rows) with numeric fields. Do not know a method to do that. The headers we use for xls is just the field name. If we do it to a csv file and use character fields and put the headers at the top of each column the numbers do not line up very readable.
Although guess i could try right justifying all the numbers..

Any help is appreciated.

Fred
Omni

[rdonnay]

I don't know how to do that.

[k-insis]

ActiveX is way to do it.

you have a working example in source/samples/activex/msexcel directory

documentation on methods is on Microsoft , see this as starting point: https://docs.microsoft.com/en-us/office ... excel-home

you will need working install of Excel for it

[k-insis]

To add: it is not fast method to do it, but you can produce almost anything.

Second would be to write a data via ODBC into xlsx file with two sheets, one beeing visual presentsation with formulas linked to second sheet (with data).

[messaoudlazhar]

You must start each header column with character ASCII <'> (27 HEX, 39 DEC) for numeric fields to say that it is a text and not a number

good work

Messaoud Mohamed Lazhar

[slobodan1949]

Here is the EXCEL table
image EXCEL-DBF-TABLE.png
which is made from Alaska Xbase ++ and eXpress ++ programs
using activex controls and from data taken from two DBF tables.

In the file:
popis_KD_kartica_EXCEL.zip
there is the source code with which this EXCEL table was made.
That code was not edited and saved for publication, because I didn't have time for that.
Try to figure it out and decipher that code and adapt it to your needs.