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