A Method for Automation of Data Processing in XLSX Spreadsheet Files Without Loss of Compatibility With Microsoft Office
Abstract
For automating document workflows, having cross-platform tools that can generate or edit electronic spread-sheets in the Office Open XML format is essential. While there are several free libraries and software packages available with such capabilities, they do not always ensure full compatibility with Microsoft Office. In this article we explore the feasibility of automating the processing of electronic spreadsheets without sacrificing any attrib-utes or internal elements. The authors have developed a program for editing the contents of electronic tables by converting data into plain text and back into the Office Open XML format, thereby enabling their accurate and efficient processing.
About the Authors
A. B. Betelin
ФГУ ФНЦ НИИСИ РАН
Russian Federation
Russian Federation
G. A. Prilipko
ФГУ ФНЦ НИИСИ РАН
Russian Federation
Russian Federation
A. G. Prilipko
ФГУ ФНЦ НИИСИ РАН
Russian Federation
Russian Federation
S. G. Romanyuk
ФГУ ФНЦ НИИСИ РАН
Russian Federation
Russian Federation
D. V. Samborskiy
ФГУ ФНЦ НИИСИ РАН
Russian Federation
Russian Federation
References
1. Международный стандарт ECMA-376, Office Open XML file formats, 5th edition, December 2021, https://ecma-international.org/publications-and-standards/standards/ecma-376 (дата обращения 02.07.2024).
2. Международный стандарт ISO/IEC 29500-1:2016. Information technology. Document description and processing languages. Office Open XML File Formats, https://www.iso.org/standard/71691.html (дата обращения 02.07.2024).
3. Сайт документации Open XML SDK, https://learn.microsoft.com/en-us/office/open-xml/open-xmlsdk (дата обращения 02.07.2024).
4. Сайт документации Apache OpenOffice, https://www.openoffice.org (дата обращения 02.07.2024).
5. Сайт документации LibreOffice, https://www.libreoffice.org (дата обращения 02.07.2024).
6. Сайт документации OpenPyXL, https://pypi.org/project/openpyxl (дата обращения 02.07.2024).
7. Сайт документации Spreadsheet::ParseXLSX, https://metacpan.org/pod/Spreadsheet::ParseXLSX (дата обращения 02.07.2024).
8. Сайт документации Excel::Writer::XLSX, https://metacpan.org/pod/Excel::Writer::XLSX (дата обращения 02.07.2024).
9. Сайт документации Apache POI - the Java API for Microsoft Documents, https://poi.apache.org (дата обращения 02.07.2024).
10. Сайт документации OpenDocument Format, https://opendocumentformat.org (дата обращения 02.07.2024).
11. Programming Excel with VBA and .NET by Jeff Webb, Steve Saunders. O'Reilly Media, Inc. 2006. ISBN: 9780596007669.
Review
For citations:
Betelin A.B., Prilipko G.A., Prilipko A.G., Romanyuk S.G., Samborskiy D.V. A Method for Automation of Data Processing in XLSX Spreadsheet Files Without Loss of Compatibility With Microsoft Office. SRISA Proceedings. 2024;14(3):4-8. (In Russ.)
Views:
24
Email this article 