Home Applications appmsw-sql2xlsx

appmsw-sql2xlsx

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
5
1 reviews
2
Awards
329
Views
33
IPM installs
0
0
Details
Releases
Reviews
Awards
Issues
Pull requests
Articles
Dependencies
This app has a demo View
Module for exporting IRIS queries to an excel file using the python openxl library.

What's new in this version

fixed install for windows

Repo-GitHub

OEX-zapm

Docker-ports

appmsw-sql2xlsx

OEX
GitHub last commit
Demo

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
  1. 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

Link

Demo

Made with
Install
zpm install appmsw-sql2xlsx download archive
Version
1.0.123 Feb, 2022
ObjectScript quality test
Category
Solutions
Works with
InterSystems IRISInterSystems IRIS for Health
First published
08 Feb, 2022
Last checked by moderator
27 Jun, 2023Works