Tony Firshman wrote, On 27/02/10 22:32:
Dilwyn Jones wrote, On 22/02/10 19:08:
Thankyou Geoff - that is great - could you add a link to your website
please as a reminder.
It is a shame not to see you adding your valued input to this list
--
Rich Mellor
RWAP Services
Oops, forgot that link in my first email. It is:
http://members.multimania.co.uk/geoffwicks/advice.htm
Choose option 1 from the menu for the Spreadsheet transfer.
You are then invited to download a zipped plain text file of an
article by Geoff.
I have read Geoff's document and it makes no mention of QL Abacus (
and Xchange) issues with exporting.
I need to export by column, as then Excel (importing by row and no way
of changing that) will preserve the spreadsheet layout.
However the QL 'archive/abacus' export only outputs data if the first
column cell is non blank.
This looks like a bug to me. Is it cured in any versions of Xchange -
mine is 3.90J?
All is OK if I put a blank row and fill it with any data.
If I then import from row 2 in Excel, then all looks fine.
Is there a way around this?
I have hundreds of files to export so this is a real pain.
Incidentally there is no need at all to modify the files to give an
extension. Simply leave the _exp there, and load files in Excel as
type *.* .
I suspect the only sure way will be to write a utility to read the
abacus file and process.
That way I could batch process which might compensate for the
programming time!
Is the file format documented anywhere?
The very last thing I expected was an Abacus export bug (8-(#
It seems odd that this has not occurred before, as surely almost all
spreadsheets must have blank row one entries?
Tony
--
QBBS (QL fido BBS 2:257/67) +44(0)1442-828255
[email protected] http://firshman.co.uk
Voice: +44(0)1442-828254 Fax: +44(0)1442-828255 Skype: tonyfirshman
TF Services, 29 Longfield Road, TRING, Herts, HP23 4DG
_______________________________________________
QL-Users Mailing List
http://www.q-v-d.demon.co.uk/smsqe.htm
