pycel | compiling excel spreadsheets to python code

by dgorissen Python Version: Current License: GPL-3.0

X-Ray Key Features Code Snippets Community Discussions(4)Vulnerabilities Install Support

kandi X-RAY | pycel Summary

pycel is a Python library. pycel has no vulnerabilities, it has build file available, it has a Strong Copyleft License and it has high support. However pycel has 9 bugs. You can install using 'pip install pycel' or download it from GitHub, PyPI.

A library for compiling excel spreadsheets to python code & visualizing them as a graph

Support

Quality

Security

License

Reuse

Support

pycel has a highly active ecosystem.

It has 510 star(s) with 141 fork(s). There are 25 watchers for this library.

It had no major release in the last 6 months.

There are 12 open issues and 56 have been closed. On average issues are closed in 126 days. There are 6 open pull requests and 0 closed requests.

It has a negative sentiment in the developer community.

The latest version of pycel is current.

Quality

pycel has 9 bugs (3 blocker, 0 critical, 6 major, 0 minor) and 101 code smells.

Security

pycel has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

pycel code analysis shows 0 unresolved vulnerabilities.

There are 1 security hotspots that need review.

License

pycel is licensed under the GPL-3.0 License. This license is Strong Copyleft.

Strong Copyleft licenses enforce sharing, and you can use them when creating open source projects.

Reuse

pycel releases are not available. You will need to build from source code and install.

Deployable package is available in PyPI.

Build file is available. You can build the component from source.

pycel saves you 4631 person hours of effort in developing the same functionality from scratch.

It has 9784 lines of code, 730 functions and 34 files.

It has high code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed pycel and discovered the below as its top functions. This is intended to give you an instant insight into pycel implemented functionality, and help decide if they suit your requirements.

Tokenize format string
Find AM_P
Creates a Tokenized from a list of tokens
Get the matching codes from the stream
Build an evaluation context
Build a function to fix the operator operand
Create a new ExcelCmp instance
Format the date with the given format_str
Validate the formulas
This method trim the graph based on input addresses
Save data to file
Scrape function list
Return a list of tokens
Set the value for an address
Fits result to target range
Decorator to mark excel
Emits the token
Return a new serial number
Get a RangeRange from an address range
Evaluate the iteration
Compiles selection menu
Save the model to a file
Returns compiled expression
A list of list of all needed cells
Convert a time value to a time value
Emit the value of the token
Returns the SUBTOTAL function

Get all kandi verified functions for this library.

pycel Key Features

No Key Features are available at this moment for pycel.

pycel Examples and Code Snippets

No Code Snippets are available at this moment for pycel.

Community Discussions

Trending Discussions on pycel

How to compose classes in pyo3?

Compiling a multiple sheet Excel Spreadsheet into pycel

How do you compile variables and still use them individually?

Is it possible to copy the Excel formula of a cell instead of the value using python?

QUESTION

How to compose classes in pyo3?

Asked 2021-May-28 at 13:33

I'm using the latest version of pyo3 (main branch) and it's not clear how I can store an instance of a class, say Store in the below example, on another class. For example, the following code composes two classes, Store and MyClass and will work to a degree.

...

ANSWER

Answered 2021-May-26 at 22:12

If you want to have the same objects inside MyClass and Python, you'll have to wrap store in Py, i.e.:

Source https://stackoverflow.com/questions/67711215

QUESTION

Compiling a multiple sheet Excel Spreadsheet into pycel

Asked 2020-May-05 at 09:06

TL;DR - trying to compile this multi-sheet Pycel tests/fixture spreadsheet (I'm particularly interested in capturing inter-sheet dependencies) using into Python code using Pycel

The Problem

The helpful Pycel example in the example/example.py in the Pycel repository runs perfectly and produces a handy .gexf graph, however, I can't work out how to compile a multi-sheet Spreadsheet (in my use case there is terrifying inter-sheet dependencies!) using Pycel.

@Stephen Rauch mentioned that "Pycel does really deal with sheets. It works with cells. Those cells can come from any sheet in the workbook" in this Stackoverflow discussion, however, I couldn't find any detail on this in the Pycel repo or in prior questions.

What I tried

I tried compiling the spreadsheet included in tests/fixtures/excelcompiler.xlsx as this is multi-sheet and it only seems to compile for Sheet1 as the resulting plot is empty (Sheet1 is empty).

...

ANSWER

Answered 2020-May-05 at 09:06

TL;DR

Pycel compiles multi-sheet Excel spreadsheets easily. Pycel's function pycel.ExcelCompiler is lazy and so doesn't actually compile Excel into Python until explicitly asked to do so via excel.evaluate('Result!E16')} (i.e. evaluate some cell)

In detail

I tried:

Source https://stackoverflow.com/questions/61501295

QUESTION

How do you compile variables and still use them individually?

Asked 2020-Apr-08 at 02:14

TL;DR - trying to clean this up but unsure of the best practice for compiling a list of variables and still separating them on individual lines on the .txt file they're being copied to.

This is my first post here.

I've recently created a script to automate an extremely tedious process at work that involves modifying an excel document, copying and pasting outputs from specifics cells depending on the type of configuration we are generating and pasting into 3 separate .txt files to send out via email.

I've got the script functioning, but I hate how my code looks and to be honest, it is quite the pain to try to make additions to.

I'm using openpyxl & pycel for this, as the cells I copy are outputs from a formula that I couldn't seem to get anything except for #N/A when strictly using openpyxl so I integrated pycel for that piece.

I've referenced my code below, & I appreciate any input.

...

ANSWER

Answered 2020-Apr-08 at 02:14

I don't think you need to name every single variable. You can use f-strings and list comprehensions to keep your code flexible.

Source https://stackoverflow.com/questions/61092212

QUESTION

Is it possible to copy the Excel formula of a cell instead of the value using python?

Asked 2019-May-05 at 17:18

Right now I'm working on combining Excel sheets into 1 new sheet, using pandas which is working. The only problem is that the value inside the new Excel sheet are plain numbers instead of the Formulas and I would like the Formulas.

Loading file

...

ANSWER

Answered 2017-Sep-13 at 13:51

You can use OpenPyXL. Read here

Following is the test excel file testexl.xlsx

Source https://stackoverflow.com/questions/46199076

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install pycel

You can install using 'pip install pycel' or download it from GitHub, PyPI.
You can use pycel like any standard Python library. You will need to make sure that you have a development environment consisting of a Python distribution including header files, a compiler, pip, and git installed. Make sure that your pip, setuptools, and wheel are up to date. When using pip it is generally recommended to install packages in a virtual environment to avoid changes to the system.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: