Primo.Office.MyOffice 1.0.2.3

About

The Primo RPA robot uses elements of the package to automate the processing of MyOffice document and workbook files.

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