Read an excel file from RAM version?

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller

Post Reply
dunbarx
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 10330
Joined: Wed May 06, 2009 2:28 pm

Read an excel file from RAM version?

Post by dunbarx » Mon Oct 17, 2016 7:52 pm

An adjunct to my other thread here. Thought a fresh topic might gain additional notice.

Can it be done? Can I read the changed contents of an open spreadsheet without having to save it?

In other words, if I open a spreadsheet from the finder, LC can read its contents. If I then make a change in that open spreadsheet, from the keyboard, say, LC does not read those changes until it is saved. I have had no better luck using "read from process", though I hope that I am just missing something. Or is it an OS thing at heart?

Craig Newman

jacque
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 7393
Joined: Sat Apr 08, 2006 8:31 pm
Contact:

Re: Read an excel file from RAM version?

Post by jacque » Tue Oct 18, 2016 5:57 pm

That's what applescript is for. What you describe is inter-app communication and you need AS as a bridge to get information from other apps.
Jacqueline Landman Gay | jacque at hyperactivesw dot com
HyperActive Software | http://www.hyperactivesw.com

dunbarx
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 10330
Joined: Wed May 06, 2009 2:28 pm

Re: Read an excel file from RAM version?

Post by dunbarx » Tue Oct 18, 2016 9:23 pm

Jacque.

Would you write an AS handler for a case of your favorite wine?

Craig

jacque
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 7393
Joined: Sat Apr 08, 2006 8:31 pm
Contact:

Re: Read an excel file from RAM version?

Post by jacque » Tue Oct 18, 2016 11:54 pm

Unfortunately I don't know AppleScript. But there are whole websites devoted to sample scripts, maybe you could find something on one of those.
Jacqueline Landman Gay | jacque at hyperactivesw dot com
HyperActive Software | http://www.hyperactivesw.com

[-hh]
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 2262
Joined: Thu Feb 28, 2013 11:52 pm

Re: Read an excel file from RAM version?

Post by [-hh] » Wed Oct 19, 2016 12:26 am

I don't have/use Excel so I can't look into the AS dictionary.
But this MacTech article may be a good start.
shiftLock happens

Post Reply