TagUI icon indicating copy to clipboard operation
TagUI copied to clipboard

Microsoft Word Add-in v3 Release, do RPA using Microsoft Word as IDE - done

Open kensoh opened this issue 4 years ago • 9 comments

My team-mate @ruthtxh has created an add-in that lets anyone do RPA with Microsoft Word.

Try it out and let us know! - https://github.com/kelaberetiv/TagUI/tree/master/src/office

word_addin


v3 ideas to review for implementation

  • [x] text area in task pane for run output
  • [x] browse for datatable file & sheet
  • [x] take image snapshot as identifiers
  • [x] consider adding snapshot button
  • [x] discuss how to handle subflows?
  • [x] rename setup.exe --> Setup.exe
  • [x] toolbar for steps and functions
  • [x] popup tooltip to show purpose
  • [x] placeholder title to elaborate
  • [x] metadata to store run options

kensoh avatar Feb 22 '21 07:02 kensoh

Adding sub-flows support for discussion before I forget

kensoh avatar Mar 24 '21 06:03 kensoh

Consider snippets - feedback from Kevin https://code.visualstudio.com/docs/editor/userdefinedsnippets

kensoh avatar Apr 10 '21 07:04 kensoh

Preview of MS Word plug-in v3 (now still in internal testing phase) - TagUIWordAddInSetup v3.zip

Below items found and being worked on by Ruth now, and more to come as I test more usage scenarios.

  • move snapshot to left of basic section
  • placeholder font size to follow main text
  • add tooltips for if condition and for loop
  • clean any dead processes before run
  • optimise performance on clicking run
  • explore adding stop button during run

kensoh avatar May 10 '21 03:05 kensoh

PS - @ruthtxh I added above post and attachment so that NUS IT folks can test drive

kensoh avatar May 10 '21 03:05 kensoh

This is v3.0.4, Ruth will be doing the finishing touches before we publish later this week - TagUIWordAddInSetupV3.04.zip

kensoh avatar Jun 14 '21 01:06 kensoh

Implemented and available from https://github.com/kelaberetiv/TagUI/blob/master/src/office/README.md

kensoh avatar Jun 21 '21 02:06 kensoh

Improvements for next release (v3.11):

  • [x] Auto check for indentation and convert to tabs
  • [x] Improve error handling for following scenarios by having custom error output with details -Related Word/Excel files are opened -Subflows calling on files that do not exist -Word/Excel popup that hinders app from closing in the background
  • [x] Force quit secondary word and excel applications after run
  • [x] TagUI Settings button on ribbon for user to specify where TagUI is installed
  • [x] Set path before running command for Run/Deploy/Update TagUI buttons
  • [x] Disable multiple popup windows for Snapshot/Settings/Update TagUI buttons
  • [x] Live mode to try out TagUI steps interactively (live button on ribbon, and live step in workflow)
  • [ ] Remove Microsoft security warning before running the word plugin

Also for consideration/future release:

  • [ ] installation setup for guest user account
  • [ ] if chrome window is accidentally closed by the user, time out and stop
  • [ ] improve snapshot tool for common select tag

ruthtxh avatar Aug 19 '21 06:08 ruthtxh

Source: telegram chat

Datatable selection for .xlsx sheet not saved in taskpane upon closing/reopening of word document. To check metadata.

ruthtxh avatar Mar 31 '22 04:03 ruthtxh

Hi @ruthtxh I'm closing some issues on features / bugs which have already made their way into the packaged release.

For this issue I didn't close because I'm not sure if you still have outstanding action to complete before closing.

kensoh avatar Jul 15 '22 21:07 kensoh