Реферат: Spreadsheets are widely used as a means of presenting and analyzing data. This is due to the simplicity and functionality of this tool when processing data. Over the years the functionality of spreadsheets has been constantly expanded and improved. However, interaction with databases remains primitive: you can import data from relational tables or export to a database table. At the same time the data structure in spreadsheets must match the structure of a relational table. This is not a convenient and illustrative way of presenting data for most users who are not professional programmers. This paper proposes experimental software implemented in MS Office environment. Master-form and Template-form are realized through VBA language in Access. Master-form sets the parameters for the application summarizing the data view “Transformation”. The application itself is then automatically created from Template-form. The newly created application loads data into Excel spreadsheets from the database and returns new values to the database after editing. The correctness of the database transformation is ensured by realizing the commutation conditions.

Библиографическая ссылка: Zykin S.V. , Poluyanov A.N. , Zykin V.S.
Tool environment for editing spreadsheet applications
В сборнике International Scientific and Technical Conference "Dynamics of Systems, Mechanisms and Machines" (Dynamics). – IEEE., 2024. – C.1-5. – ISBN 979-8-3315-0901-9. DOI: 10.1109/Dynamics64718.2024.10838693 Scopus OpenAlex

Даты:

Поступила в редакцию:	1 сент. 2024 г.
Принята к публикации:	14 окт. 2024 г.
Опубликована в печати:	16 янв. 2025 г.
Опубликована online:	16 янв. 2025 г.

Идентификаторы БД:

Scopus:	2-s2.0-85217765834
OpenAlex:	W4406459101

Цитирование в БД: Пока нет цитирований

Альметрики: