3 ms·
This looks like something that I could use right away, but I wonder, since we can write Python, does this mean that we can write back to one of the native backe
by otoburb 3y ago
This looks like something that I could use right away, but I wonder, since we can write Python, does this mean that we can write back to one of the native backends (e.g. Postgres)?
Currently, the only way to do this from Excel (e.g. saving a snapshot of an analyst's current dashboard that they just built) is through a macro, which then starts the (understandable) descent into Excel's External Content and Trust Center permissions hell.
- gamegoblin 3y agoYou can technically use the Python to write back to Postgres if you are comfortable putting your creds into the code window. The downside of this is your creds would be viewable to anyone you share the workbook with. We have gotten a lot of requests for write-back-to-DB (Snowflake, Postgres, etc) so will be adding first-class support for this feature soon that will use the same connection creds which are stored encrypted in KMS and are not viewable to people you share the workbook with. Would love to chat about your use-case if you want to reach out to us at contact[at]rowzero.io
- al_borland 3y agoIt’s worth noting that Excel supports Python now as well. https://techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439 https://techcommunity.microsoft.com/t5/excel-blog/announcing...
- andelink 3y agoLooks like the Row Zero blog does a brief overview of existing Python spreadsheets, mentioning Excel support: https://rowzero.io/blog/top-python-spreadsheets#top-5-python-spreadsheets https://rowzero.io/blog/top-python-spreadsheets#top-5-python... Would like to see a more detailed comparison than the one they've got in their blog, though.