DC_WorkArea2Excel

This forum is for eXpress++ general support.
Post Reply
Message
Author
User avatar
RDalzell
Posts: 205
Joined: Thu Jan 28, 2010 6:57 am
Location: Alsip, Illinois USA

DC_WorkArea2Excel

#1 Post by RDalzell »

Hello Everybody,

While using the function DC_WorkArea2Excel(), the numeric content of the database field appears only as an "8" when exported to excel.

Sample attached.

Thanks,

Rick
Attachments
ExcelTest.Zip
(26.47 KiB) Downloaded 813 times

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

Re: DC_WorkArea2Excel

#2 Post by rdonnay »

Rick -

I think you must be running an older version of DC_WorkArea2Excel() for the following reasons:

1. When I run your sample it causes an error because your aExport array does not conform to specs.
It should be a single-dimensional array of only character strings (field names).
Make the following change:

Code: Select all

Was:
AAdd( aExport, aStruct[nFound] )

Is:
AAdd( aExport, aStruct[nFound,1] )
2. The Excel file I created looked fine to me.

http://bb.donnay-software.com:8080/supp ... eltest.xls

Please try the most current version of DC_WorkArea2Excel().

http://bb.donnay-software.com:8080/support/_dcfunct.prg

Copy it to your \exp19\source\dclipx directory and run build19.bat or build19_sl1.bat to rebuild dclipx.dll
The eXpress train is coming - and it has more cars.

User avatar
RDalzell
Posts: 205
Joined: Thu Jan 28, 2010 6:57 am
Location: Alsip, Illinois USA

Re: DC_WorkArea2Excel

#3 Post by RDalzell »

Hi Roger,

That did it.

Works great now - Thank You.

Post Reply