Primo.Office.MyOffice 1.0.2.4

About

Primo.Office.MyOffice is a set of ready-to-use activities for Primo RPA Studio designed to automate processing of MyOffice documents and workbooks. It addresses the need to work with MyOffice text and table files within automated processes. Key activities include: connecting to MyOffice documents and workbooks, replacing text in documents, and adding sheets to workbooks. The package can be added to any Primo RPA Studio project via the built-in dependency manager.

How to Use

In Primo RPA studio, create a project that will be executed by Primo RPA robot. Install this package via the ".Dependencies → Manage Dependencies" menu; the "MyOffice - Documents" and "MyOffice - Tables" nodes with package elements will appear in Elements tree.

Documents

The "MyOffice Text" element is a container for all other elements that are children of the "MyOffice - Documents" node. This element is used to connect to MyOffice document.
In pure code projects use the element as follows:

//wf: [LTools.Common.Model.WorkflowData] parent algorithm link
//fileName - File path: [String] Path to a text document file (c:\folder\file.odt)
//bytes - Byte array: [byte[]] Document byte array
//cp - Code page: [Int32] Document code page
LTools.Office.MyOfficeTableApp app = LTools.Office.MyOfficeTableApp.Init(wf, fileName, [cp]);
LTools.Office.MyOfficeTableApp app = LTools.Office.MyOfficeTableApp.Init(wf, bytes, [cp]);

All other child elements of the "MyOffice - Text" node should be placed inside the "MyOffice Text" container to process the document. "Replace text" element in pure code:

//Replaces specified text in a document. 
//Properties
//app - [LTools.Office.MyOfficeTableApp] MyOffice document application
//oldText - Text: [String] Replaced text
//newText - Text: [String] New text
List<int> idxs = app.ReplaceText(oldText, newText);

Workbooks

The "MyOffice Table" element is a container for all other elements that are children of the "MyOffice - Tables" node. This element is used to connect to MyOffice workbook.
In pure code projects use the element as follows:

//wf: [LTools.Common.Model.WorkflowData] parent algorithm link
//fileName - File path: [String] Path to workbook document (c:\folder\file.ods)
//bytes - Byte array: [byte[]] Workbook bytes array
//cp - Code page: [Int32] Document code page
LTools.Office.MyOfficeTableApp app = LTools.Office.MyOfficeTableApp.Init(wf, fileName, [cp]);
LTools.Office.MyOfficeTableApp app = LTools.Office.MyOfficeTableApp.Init(wf, bytes, [cp]);

All other child elements of the "MyOffice - Tables" node should be placed inside the "MyOffice Table" container to process the document.
"Add sheet" element in pure code:

//Element creates a new sheet in a workbook. 
//Properties
//app - [LTools.Office.MyOfficeTableApp] Workbook application
//sheet - Name: [String] Sheet name
//rows - Index: [Int32] Rows on the sheet
//cols - Index: [Int32] Columns on the sheet
//sheetIdx - Index: [Int32] Sheet index
app.SheetAdd(sheet, rows, cols, [sheetIdx]);

Key Features

• A large set of elements for diverse and high-quality processing of documents and workbooks
• High performance
• Supports .NET Framework 4.6.1+

Main Types

• LTools.Office.MyOfficeTableApp
• LTools.Office.MyOfficeTextApp

Feedback

Bug reports and contributions are welcome at Primo RPA chat