Getting data out of Excel
Michael Julian Lew
michaell at unimelb.edu.au
Tue Jul 23 23:09:13 EDT 2013
I'm trying to paste data from MS Excel into a table in my Livecode stack without success. I suspect that either OSX or Excel have added unwelcome complications.
I used to be able to just paste, but nowadays (Excel 2011 Mac OSX 10.7.4) the data come in as a long string, with six spaces where a return should be and three where a tab should be. Putting the clipboardData["text"] makes no difference, and the clipboardData["RTF"] is not what I want.
I can make it work by copying cells in Excel, then Paste Text Only in Nisus Writer Pro, then copying and pasting the text from there.
I can write a function to clean up the clipboardData, but it seems silly to need to do so. Does anyone have a quick solution?
Regards,
Michael Lew
More information about the use-livecode
mailing list