![]() ![]() It would be fairly convoluted to get this to run in Linux (it might require a virtual machine testimonials for Excel under Wine have been mixed at best). I don't know what you're using now.įinally, if the UNO-based methods are really too unstable, and you do have access to Excel, then you could try xlwings. Note that there are a few different Python interfaces to UNO, such as PyOO and UnoTools. Data is at the core of your workflows, and Excel is one of the most common tools for analyzing data and making decisions. If you need the formulas and you need to run it in Linux, then using UNO in some form (to control a running instance of LibreOffice) is probably still your best bet. Introducing Excel Organization data types from Power BI. So if you want to use OpenPyXL or pyexcel-ods "interactively", you would have to not use Excel/LibreOffice formulas but instead do all the calculations with Python. Likewise, the only practical way to evaluate LibreOffice formulas is with a running instance of LibreOffice. ![]() The only practical way to evaluate Excel formulas is with a running instance of Excel. OpenPyXL doesn't need and cannot use a running instance of Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |