Lazarus
Programming => General => Topic started by: bigeno on April 07, 2018, 06:57:30 pm
-
Can someone help me with information about Office 365 ?
I'm using OLE to transfer data from my app to Excel/Word, all works ok but I get some information that my app don't work in Office 365.
I can't test now (don't have 365), the app can't start GetActiveOleObject('Excel.Application').
Does Office 365 have full working OLE automation ?
-
Can someone help me with information about Office 365 ?
I'm using OLE to transfer data from my app to Excel/Word, all works ok but I get some information that my app don't work in Office 365.
I can't test now (don't have 365), the app can't start GetActiveOleObject('Excel.Application').
Does Office 365 have full working OLE automation ?
Office 365 is just the subscription. You still run the same Office apps.
Your app may have a problem with an Office app, but I don't think it has anything to do with the subscription.
You need to test it yourself.
I do know that Office apps on Mac are completely scriptable.
-
Yup, one month subscription not big deal, just testing and all works good here...
-
Yup, one month subscription not big deal, just testing and all works good here...
Sounds good.
In case you're interested in supporting Mac with Office apps someday:
https://macpgmr.github.io/ObjP/MacAutomationWithPascal.html
I've scripted Excel from a Mac app to do charting - works good.
-
Sounds good.
In case you're interested in supporting Mac with Office apps someday:
https://macpgmr.github.io/ObjP/MacAutomationWithPascal.html
I've scripted Excel from a Mac app to do charting - works good.
oops, I write app as shortcut application :(, Im on Windows
-
Hi all,
Since I have similar problem I am refreshing the thread.
My app is working in hundreds of places, and it uses automation to make reports in MS Excel.
My client decided to use Office 365, and automation does not work anymore.
As I understood, they use online version of Excel.
Is there any way to make it work ?
-
As I understood, they use online version of Excel.
For the online version you'll have to use their Web API (if they provide any). We do at least have some (https://svn.freepascal.org/cgi-bin/viewvc.cgi?view=revision&revision=34097) support in the direction of Office 365, though you'll probably have to implement the Excel specific stuff yourself.
-
Hi!
Just for your information:
In germany Office 365 is forbidden for the use in govermental bureaus due to
data privacy protection.
Winni
-
I guess lesson learned.
Don't depend on optional software that is not yours to make yours work.
I learned that years ago after getting a pdf creator package only to find it required ms office to use it.
I don't have that in most of my pc's
-
Hi all,
Since I have similar problem I am refreshing the thread.
My app is working in hundreds of places, and it uses automation to make reports in MS Excel.
My client decided to use Office 365, and automation does not work anymore.
As I understood, they use online version of Excel.
Is there any way to make it work ?
Tell them to use LibreOffice Calc.
And to give you the money they saved.
Winni
-
Does Office 365 have full working OLE automation ?
No
-
It's strange. Office 365 is not a separate program. It's just licensing --- subscription.
I did some test (just a small amount), and OLE works fine. I'm using Office 365.
Also I tried OpenOffice.org. It's good. I can make a text document within Pascal program.
-
It's strange. Office 365 is not a separate program. It's just licensing --- subscription.
I did some test (just a small amount), and OLE works fine. I'm using Office 365.
The question is about the cloud based variant of Office.
-
Indeed. That is how I interpreted it.