PIX Robotics and MISIS: Table Editor Handler

2024: Table Editor Handler View

Kirill Pronin, a 1st-year master's student at computer MISIS the Institute of Technology at NUST, wrote a code that can work with all files Linux analogs Excel for import substitution a table editor handler. The solution was created for the company project. The PIX Robotics university announced this on September 12, 2024.

Thanks to technical progress and import substitution programs, many analogues of Microsoft Office appear. At the same time, the solutions included in the office suite are implemented on different operating systems of the Linux family. Kirill Pronin, a student at NITU MISIS, created a table editor handler that works for any of them and processes all internal document data.

It is important to understand that each document or table is a node-based data type called XML. Since the introduction of the C # programming language, there has been a type of management of these nodes - XmlDocument. Due to widespread use, developers have long considered it the best. But this is no longer the case. Starting with the.Net framework 3.5, XDocument appeared - a data type for XML management. He updated every version of C#, accumulated huge potential for work. However, due to the small number of articles and examples of use, the developers do not dare to switch to it, "explained Kirill Pronin, PIX RPA developer, master's student at the Institute of Computer Technology, NUST MISIS.

To develop a solution, Kirill first compared the functionality of a new data type with the old one. When processing office suite files, XDocument turned out to be 1.4 times faster and used 38% less memory.

According to the student, the most difficult thing was to unify the solution - to "teach" the application to process documents of the most popular and popular office packages on Linux: MyOffice, P7-Office, LibreOffice, etc. To do this, Kirill analyzed the development history of the Open Document Format (ODF) format for open xml documents. It turned out that all Linux analogues of Excel have one common ancestor, the language of which is suitable for writing universal code. The result is a table data processor that quickly extracts only the necessary information from the file. The use of XDocument made it possible to speed up work and does not require the installation of additional programs or office packages.

The transition to the use of domestic office packages is one of the most pressing tasks for organizations within the framework. import substitution If it is easy to create new documents, then transferring the entire volume of old documentation to a different format is sometimes an overwhelming task, which not everyone is ready to take on. Kirill's solution allows you to perform the transition in automated mode, here and now. Separately, it should be noted that the solution allows you to automate work with open format documents in full - just like Microsoft with Office format documents. This work has already contributed and will continue to contribute to the economy and digital sovereignty not only of individual companies or universities, but of the entire country. Our company cooperates with NITU MISIS as part of the PIX Education program, which means that we can expect important new developments in the field of RPA from university students, "said Valentin Drazdov, PIX RPA Product Manager, PIX Robotics.