it is Quick & Dirty but it seems to work this Way
Excellent Mr. Jimmy.Not dirty at all. This is very useful.
This creates ".XLSB" file, if not ".XLSX" file. That is quite good enough where Excel is not installed.
I did not know this before and this is a great learning for me and thank you.
Now.
For this quick test, you have used ACE.
We know ACE is to be installed by the user and is not installed by default.
So, I tried with Jet OLEDB. This created ".XLS" file. That is great too.
We can now try
- Code: Select all Expand view
TRY
use ACE
CATCH
TRY
use Jet
CATCH
? "FAIL"
END
END
Now, even if Excel is not installed, we can create xlsb if ACE is installed or .xls otherwise.
This is very useful.
Now FWH has ExportToExcel functions and methods in XBrowse, RowSet class and direct functions.
All these functions/methods work only if Excel is installed.
We can now extend this export facility even if Excel is not installed.
We will work on this.
Again many thanks.