title: ÐÐµÐ½ÐµÑÐ°ÑÐ¸Ñ xlsx Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾Ð² Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð»ÑÐ½ÑÑ ÑÐ°Ð±Ð»Ð¾Ð½Ð¾Ð² Ð¸ Ð´Ð°Ð½Ð½ÑÑ
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Generation xlsx documents based on templates and data
Creators: name: ÐÑÐºÑÑÐ½Ð¾Ð²Ð¸Ñ, ÐÐ»ÐµÐºÑÐ°Ð½Ð´Ñ
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2021
Subjects: Golang (Go)
ÑÐµÑÐ²Ð¸Ñ
xlsx
ÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ Ð¾ÑÑÑÑÐ¾Ð²
service
generating reports

description: Ð Ð´Ð°Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÐµ ÑÐµÑÐ°ÐµÑÑÑ Ð·Ð°Ð´Ð°ÑÐ° ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ¸ Ð¸ ÑÐµÑÐ²Ð¸ÑÐ° Ð´Ð»Ñ ÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ xlsx Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾Ð² Ð½Ð° Ð¾ÑÐ½Ð¾Ð²Ðµ ÑÐ°Ð±Ð»Ð¾Ð½Ð°, Ð² ÐºÐ¾ÑÐ¾ÑÑÐ¹ Ð¿Ð¾Ð´ÑÑÐ°Ð²Ð»ÑÑÑÑÑ Ð´Ð°Ð½Ð½ÑÐµ Ð¸ ÑÑÐ¸Ð»Ð¸ Ð² ÑÐ¾Ð¾ÑÐ²ÐµÑÑÑÐ²Ð¸Ð¸ Ñ Ð¾Ð¿Ð¸ÑÐ°Ð½Ð¸ÐµÐ¼ Ð¿Ð¾Ð»ÐµÐ¹ Ð² ÑÐ°Ð±Ð»Ð¾Ð½Ðµ. Ð ÑÐ°Ð±Ð¾ÑÐµ Ð¿ÑÐ¾Ð°Ð½Ð°Ð»Ð¸Ð·Ð¸ÑÐ¾Ð²Ð°Ð½Ñ Ð½ÐµÐºÐ¾ÑÐ¾ÑÑÐµ ÑÑÑÐµÑÑÐ²ÑÑÑÐ¸Ðµ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ¸, ÑÐµÐ°Ð»Ð¸Ð·ÑÑÑÐ¸Ðµ ÑÑÐ¾Ð¶Ð¸Ð¹ ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð». Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ñ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐ° Ð¸ ÑÐµÑÐ²Ð¸Ñ, ÑÐµÑÐ°ÑÑÐ¸Ðµ Ð¿Ð¾ÑÑÐ°Ð²Ð»ÐµÐ½Ð½ÑÑ Ð·Ð°Ð´Ð°ÑÑ. Ð ÑÐ¾Ð´Ðµ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ¸ ÑÐµÑÐ²Ð¸ÑÐ° Ð±ÑÐ»Ð¸ ÑÐ¾Ð²ÐµÑÑÐµÐ½Ñ Ð´Ð¾ÑÐ°Ð±Ð¾ÑÐºÐ¸, ÐºÐ¾ÑÐ¾ÑÑÐµ ÑÑÑÐµÑÑÐ²ÐµÐ½Ð½Ð¾ Ð¿Ð¾Ð´Ð½Ð¸Ð¼Ð°ÑÑ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÑ Ð³ÐµÐ½ÐµÑÐ°ÑÐ¸Ð¸ Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾Ð². ÐÐ¾ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ°Ð¼ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ¸ Ð¿ÑÐ¾Ð¸Ð·Ð²ÐµÐ´ÐµÐ½Ð¾ ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ, ÐºÐ¾ÑÐ¾ÑÐ¾Ðµ Ð½Ðµ Ð²ÑÑÐ²Ð¸Ð»Ð¾ Ð¾ÑÐ¸Ð±Ð¾Ðº Ð² ÑÐµÑÐ²Ð¸ÑÐµ Ð¸Ð»Ð¸ Ð±Ð¸Ð±Ð»Ð¸Ð¾ÑÐµÐºÐµ. ÐÐ°Ð½Ð½ÑÐ¹ ÑÐµÑÐ²Ð¸Ñ Ð²Ð²ÐµÐ´ÑÐ½ Ð² ÑÐºÑÐ¿Ð»ÑÐ°ÑÐ°ÑÐ¸Ñ Ð² Ð½Ð°ÑÐµÐ¹ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸ Ð¸ Ð¿Ð¾ÐºÐ°Ð·Ð°Ð» ÑÐµÐ±Ñ Ñ ÑÐ¾ÑÐ¾ÑÐµÐ¹ ÑÑÐ¾ÑÐ¾Ð½Ñ Ð² Ð¿Ð»Ð°Ð½Ðµ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸. Ð¡ÑÐµÐ´Ð½ÐµÐµ Ð²ÑÐµÐ¼Ñ Ð³ÐµÐ½ÐµÑÐ°ÑÐ¸Ð¸ Ð¾ÑÑÑÑÐ¾Ð² ÑÐ¾ÐºÑÐ°ÑÐ¸Ð»Ð¾ÑÑ Ð½Ð° 70%. ÐÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð´Ð°Ð½Ð½Ð¾Ð³Ð¾ ÑÐµÑÐ²Ð¸ÑÐ° ÑÐ°ÐºÐ¶Ðµ ÑÐ½Ð¸Ð¶Ð°ÐµÑ Ð²ÑÐµÐ¼Ñ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ¸ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¾Ð½Ð½ÑÑ ÑÐ¸ÑÑÐµÐ¼, ÐºÐ¾ÑÐ¾ÑÑÐ¼ ÑÑÐµÐ±ÑÐµÑÑÑ ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð» ÑÐ¾ÑÐ¼Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ xlsx Ð´Ð¾ÐºÑÐ¼ÐµÐ½ÑÐ¾Ð². ÐÐ¾ÑÐ°Ð±Ð¾ÑÐºÐ¸ Ð¿Ð¾ ÑÑÐ½ÐºÑÐ¸Ð¾Ð½Ð°Ð»Ñ ÑÐµÑÐ²Ð¸ÑÐ° Ð±ÑÐ´ÑÑ Ð¾ÑÑÑÐµÑÑÐ²Ð»ÑÑÑÑÑ Ð¿Ð¾ Ð¼ÐµÑÐµ Ð¿Ð¾ÑÑÑÐ¿Ð»ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð¾Ñ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÐµÐ¹.
description: This thesis discusses solving the problem of creating a library and a service for generating xlsx documents based on a template, into which data and styles are substituted in accordance with the description of the fields in the template. We analysed some existing libraries that implement similar functionality. A library and a service have been developed to solve the problem. Improvements were made that significantly increase the productivity of document generation. Testing was carried out, which did not reveal errors in the service or library. This service was put into operation in our company and has shown itself to be on the good side in terms of productivity. The average report generation time was reduced by 70%. The use of this service also reduces the development time of information systems that require the functionality of generating xlsx documents. Improvements to the functionality of the service will be carried out as requests from users are received.