Wednesday, April 25, 2018

ExcelExport New Enhancements

1.  New property named Automation.  

If you set it up to .T., it will seed excel via pure automation on a cell per cell basis.  This is so we do not need to perform CAST() anymore on memo fields.  It will get its contents including CRLF (paragraphing), if any. 

If you set it up to .F. (default), it will perform the legacy way which is via EXPORT TO.  Here, you have to perform CAST() on memo fields like this:

Select CAST(CHRTRAN(MyMemo,CHR(13),'') as C(240)) as MyMemo

Otherwise memo fields won't be recognized by Excel.  One disadvantage of this legacy approach is the memo fields will be of contiguous nature as CRLF will be forced removed.  Also, Excel truncates the date beyond 255,

2.  Fixed bug on fields of currency format being ignored on decimal places.  Now it will also show the currency symbol.

3.  If it detects that Excel supports xlsx format, then its final output will be of xlsx nature

Here is the output when Automation is set to .T.



Cheers!