Article
Sergey Mikhailenko · Feb 22, 2022 2m read

Module for exporting IRIS queries to an Excel file using the python openpyxl library

Hello everyone.
I present this project to the contest. The export module is essential in many of my projects and is often used in all my product servers.

I have implemented various scenarios in the invoke attribute initialization module, both maximalistic with many additional projects to demonstrate in GCR , and minimalistic to install natively in production instance

zpm "install appmsw-sql2xlsx -Dzpm.demo=none"

To demonstrate the possibilities, I used the fileserver and csvgen projects.

To demonstrate the possibility, I propose to perform the following steps: Load a demo and enter the name and password of the superuser \ SYS
In the window that appears, click theSearch button, and then Export

image

Next, select the menu item csvgen

image

In the tab that appears, click the Load button, and then Search button, and Export

image

Next, select the menu item Fileserver
image

We will see a list of excel files that we can Download

image

Excel file generated from a template

Please vote

P.S. And when your PR has not yet been merged, it is quite possible to load your modified fork directly from the repo

1
1 162
Discussion (0)1
Log in or sign up to continue