appmsw-sql2xlsx
Module for exporting IRIS queries to an excel file using the python openpyxl
library.
To demonstrate the possibilities, I used the fileserver and csvgen projects
Requirements
IRIS for UNIX (Ubuntu Server LTS for x86-64 Containers) 2021.2 (Build 649U) Thu Jan 20 2022 08:53:15 EST
Installation with ZPM
If ZPM the current instance is not installed, then in one line you can install the latest version of ZPM.
zn "%SYS" d ##class(Security.SSLConfigs).Create("z") s r=##class(%Net.HttpRequest).%New(),r.Server="pm.community.intersystems.com",r.SSLConfiguration="z" d r.Get("/packages/zpm/latest/installer"),$system.OBJ.LoadStream(r.HttpResponse.Data,"c")
If ZPM is installed, then exchange-rate-cbrf-ui
can be set with the command
zpm:USER>install appmsw-sql2xlsx
Installation with Docker
Prerequisites
Make sure you have git and Docker desktop installed.
Installation
Clone/git pull the repo into any local directory
$ git clone https://github.com/SergeyMi37/appmsw-sql2xlsx.git
Open the terminal in this directory and run:
$ docker-compose build
- Run the IRIS container with your project:
$ docker-compose up -d
How to Test it
Open link: http://localhost:52663/apptoolsrest/a/xlsx&class=appmsw.python.demo