Page 1 of 1

Read an excel file from RAM version?

Posted: Mon Oct 17, 2016 7:52 pm
by dunbarx
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

Re: Read an excel file from RAM version?

Posted: Tue Oct 18, 2016 5:57 pm
by jacque
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.

Re: Read an excel file from RAM version?

Posted: Tue Oct 18, 2016 9:23 pm
by dunbarx
Jacque.

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

Craig

Re: Read an excel file from RAM version?

Posted: Tue Oct 18, 2016 11:54 pm
by jacque
Unfortunately I don't know AppleScript. But there are whole websites devoted to sample scripts, maybe you could find something on one of those.

Re: Read an excel file from RAM version?

Posted: Wed Oct 19, 2016 12:26 am
by [-hh]
I don't have/use Excel so I can't look into the AS dictionary.
But this MacTech article may be a good start.