Primo.Office.P7.Core 0.0.4

About

Primo.Office.P7.Core is a set of ready-to-use activities for Primo RPA Studio designed to automate interaction with P7 Office. It addresses the need to process documents and workbooks in P7 Office within automated processes. Key activities include: connecting to P7 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 "P7 - Documents" and "P7 - Tables" nodes with package elements will appear in Elements tree.

Documents

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

//wf: [LTools.Common.Model.WorkflowData] parent algorithm link
//fileName - File name: [String] Name of opened text document without path ("Document1.docx"")
Primo.Office.P7.P7Inst.P7Document app = new Primo.Office.P7.P7Inst.P7Document();
app.AttachByFilePath(fileName);

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 - [Primo.Office.P7.P7Inst.P7Document] P7 document application
//oldText - Text: [String] Replaced text
//newText - Text: [String] New text
app.ReplaceText(oldText, newText);

Workbooks

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

//fileName - File name: [String] Name of opened workbook document without path ("Workbook.xlsx"")
Primo.Office.P7.P7Inst.P7Tables app = new Primo.Office.P7.P7Inst.P7Tables();
app.AttachByFilePath(fileName);

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 - [Primo.Office.P7.P7Inst.P7Tables] Workbook application
//name - Name: [String] Sheet name
//index - Index: [Int32] Sheet index
app.SheetsAdd(name, [index])

Key Features

• A large set of elements for diverse and high-quality processing of documents and workbooks with P7 Office
• High performance
• Supports .NET 8+

Main Types

• Primo.Office.P7.P7Inst.P7Document
• Primo.Office.P7.P7Inst.P7Tables

Feedback

Bug reports and contributions are welcome at Primo RPA chat