In detail, the use of the
xlrd / xlwt module to export data directly into an MSExcel file.
On the one hand, we attach great importance to being able to perform tasks by the server without calling on the capacity of a client.
On the other hand, we always try to create simple routine to do a job and not train all our programmers in the techniques used.
In this example, we have defined a 'script template' in python, an SB process that receives documented parameters and AM / VM / SVM data.
Any application programmer can therefore on the one hand prepare the data and simply request an XLS format, and on the other hand, he can develop the python script without compromising the default one.
Here are the calling program parameters :
* PARAM <1>: FILE.DEST: name of the destination file
* PARAM <2>: directory: local! sbc remote
* PARAM <3>: open immediately _yes / _no
* PARAM <4>: FILE_OF_PYSCRIPT_CANVAS; optional default INDEFN
* PARAM <5>: RECORDID_OF_PYSCRIPT_CANVAS; optional default PY.DTA.TO.XLS
* PARAM <6, mv>: TITLE: title of the array tag # TITLE #
* PARAM <7>: orientation of the header / data tables: (1 = default) VM, AM (the rows in VM; the columns in AM) (2) AM, VM (the rows in am; the columns in vm)
* PARAM <8, mv, sv>: COL.HEADER: column header; oriented according to <5>
* PARAM <9, mv, sv>: COMMENT: comment added at the bottom of the sheet
* PARAM <10, mv>: SHEET.NAME: title of the page tag # SHEET # if empty then we take title
* PARAM <11 +, y>: COL.DATA: column data in the format: am = row; vm = column or the reverse: am = column; vm = line;
* ------------------------------------------------- -------------------------------
linked I share our py script and SBprocess py.dta.to.xls and our py default p.xls.out.py
enjoy
------------------------------
Manu Fernandes
------------------------------
Original Message:
Sent: 07-25-2020 11:33
From: Manu Fernandes
Subject: What Python modules are you integrating with your U2 application?
hi,
We use python from years, before u2 implement it dwith uniBasic.
our main modules are :
- xlwt, xlrd, xlutils and/or openpyxl to prepare Excel files
- qrcode to encode text to QRcode binary values, used into postscript form
- gdata to interact with Google services
- jwt for some json manipulation,
- cryptography for certificate encoding/decoding
- oauth2client for oauth interfaces encryption, decryption
regards.
------------------------------
Manu Fernandes
Original Message:
Sent: 07-24-2020 12:47
From: Michael Rajkowski
Subject: What Python modules are you integrating with your U2 application?
With close to 250 thousand projects on https://pypi.org/, it is not likely any of us will have a chance to try them all.
Please reply to this discussion with a short comment on any python module/package you feel would be of interest to the group.
For example:
Recently, Louis Tur and I published blog posts on using Twilio to send SMS Text Messages.
How to Send SMS Text Messages from U2 with Python
WHY SEND SMS TEXT MESSAGES FROM U2 WITH PYTHON
------------------------------
Michael Rajkowski
Rocket Software
------------------------------