search

microsoft / WinAppDriver

Windows Application Driver
MIT License
3.66k stars 1.4k forks source link

Can WinAppDriver be used to automate online office apps? #1057

Open sramssh opened 4 years ago

sramssh commented 4 years ago

Can WinAppDriver be used to automate online office apps like Excel, word and powerpoint online?

DLightstone commented 4 years ago

Word Yes Excel don't know, but the probably also yes Powerpoint, I don't use Powerpoint

sramssh commented 4 years ago

Thanks for the response! I understand that it can be used for desktop apps excel, word and powerpoint. Did you use it for Word Online?

DLightstone commented 4 years ago

I do not use Office online, never will

naeemakram commented 4 years ago

Office 365 is a web product, it will be automated using browser automation tools like Selenium or Cypress.io WinAppDriver is designed specifically for desktop Windows applications.

DLightstone commented 4 years ago

@naeemakram It is not as simple as that, spend some time, figure out how you might select a single word within the document.

swethakucherlapatiTR commented 4 years ago

@DLightstone do you have any code written for MS Word desktop app using java?

DLightstone commented 4 years ago

@swethakucherlapatiTR

sorry, I do not work in Java I have no Java MS Word code

naeemakram commented 4 years ago

@naeemakram It is not as simple as that, spend some time, figure out how you might select a single word within the document.

I know it must be very hard. You can select the entire text using Ctrl + A, Ctrl + C and then read the contents of clipboard to get all the text. But that's as far as I've gone(in an Excel application)

DLightstone commented 4 years ago

@naeemakram

Not hard, impossible

You need to use Word Automation to manipulate the document.

swethakucherlapatiTR commented 4 years ago

@DLightstone What is Word Automation? I am trying to edit a Microsoft word document and sendKeys() is not helping.

DLightstone commented 4 years ago

@swethakucherlapatiTR

Perhaps you have heard of Google Do you know how to use it also?

https://www.google.com/search?client=firefox-b-1-d&q=word+automation

naeemakram commented 4 years ago

Microsoft Office applications expose an object model which allows you to automate various aspects of the application. Same is leveraged for creating macros. Please see the link below for more information about office automation using VBA. https://docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/automate-word-create-file-using-visual-basic

DLightstone commented 4 years ago

@ naeemakram

Perhaps you are familiar with the expression

Give a man a fish and he eats for a day Show a man how to fish and he eats for the rest of his life

Sometimes answering a question is not a good idea

Pranav-Mahale commented 3 years ago

Office 365 is a web product, it will be automated using browser automation tools like Selenium or Cypress.io WinAppDriver is designed specifically for desktop Windows applications.

How can we automate office 365 apps using cypress? are there any libraries to be added in the project?