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
DC_WorkArea2Excel
DC_WorkArea2Excel
- Attachments
-
- ExcelTest.Zip
- (26.47 KiB) Downloaded 812 times
Re: DC_WorkArea2Excel
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:
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
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] )
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.
Re: DC_WorkArea2Excel
Hi Roger,
That did it.
Works great now - Thank You.
That did it.
Works great now - Thank You.