Excel

This forum is for eXpress++ general support.
Post Reply
Message
Author
omni
Posts: 531
Joined: Thu Jan 28, 2010 9:34 am

Excel

#1 Post by 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

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Excel

#2 Post by rdonnay »

I don't know how to do that.
The eXpress train is coming - and it has more cars.

k-insis
Posts: 94
Joined: Fri Jan 28, 2011 4:07 am

Re: Excel

#3 Post by 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
Posts: 94
Joined: Fri Jan 28, 2011 4:07 am

Re: Excel

#4 Post by 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
Posts: 42
Joined: Mon Dec 23, 2013 2:10 pm
Contact:

Re: Excel

#5 Post by 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

User avatar
slobodan1949
Posts: 80
Joined: Mon Apr 25, 2011 8:57 am
Location: SERBIA
Contact:

Re: Excel

#6 Post by 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.
Attachments
popis_KD_kartica_EXCEL.zip
(6.18 KiB) Downloaded 495 times
EXCEL-DBF-TABLE.png
EXCEL-DBF-TABLE.png (48.68 KiB) Viewed 7981 times

Post Reply