Abstract: 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.

Cite: Zykin S.V. , Poluyanov A.N. , Zykin V.S.
Tool environment for editing spreadsheet applications
In compilation 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

Dates:

Submitted:	Sep 1, 2024
Accepted:	Oct 14, 2024
Published print:	Jan 16, 2025
Published online:	Jan 16, 2025

Identifiers:

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

Citing: Пока нет цитирований

Altmetrics: