Hello All,
Apologies if this has been discussed on the list before, but I am a
newcomer to this list and could find nothing like this in the list
archive.
Essentially I would like to submit an enhancement to the Excel exporter.
At the moment the values exported are interpreted (by Excel 2000 at
least) as text values. This makes using Excel to analyse that data
difficult. If the 'if then' statement is replaced by a select case
statement that:
a) formats the cell for the data type
b) inserts the data using the cells 'FormulaR1C1' property, which seems
to lead to more reliable reading of the format by Excel.
Attached is a version of Exporter module with just such a structure for
handling some of the more common data types
Regards
David Horwitz
--
****************************************************
David Horwitz University of Cape Town
IT Officer Private Bag
Multimedia Education Group Rondebosch
7701
dhorwitz@ched.uct.ac.za SOUTH AFRICA
Tel:+27 21 650 3841 Fax:+27 21 650 5045
http://www.meg.uct.ac.za
PGP key: http://www.meg.uct.ac.za/dhorwitz/david_horwitz.acs
*************************************************