Search Results for "python excel"

VisiData is an interactive multitool for tabular data. It combines the clarity of a spreadsheet, the efficiency of the terminal, and the power of Python, into a lightweight utility that can handle millions of rows with ease. A terminal interface for exploring and arranging tabular data. VisiData supports tsv, CSV, SQLite, JSON, xlsx (Excel), hdf5, and many other formats. Requires Linux, OS/X, or Windows (with WSL). Hundreds of other commands and options are also available; see the documentation. ...

...Our goal is to build a spreadsheet that enables you to pull your data from its source (SaaS, Database, CSV, API, etc) and then work with that data using the most popular data science tools today (Python, Pandas, SQL, JS, Excel Formulas, etc). Quadratic has no environment to configure. The grid runs entirely in the browser with no backend service. This makes our grids completely portable and very easy to share. Quadratic has Python library support built-in. Bring the latest open-source tools directly to your spreadsheet. Quickly write code and see the output in full detail. ...

Fully written in python which is one of the most used programming languages due to its simplified syntax and shallow learning curve. It is the first time in history that users, regardless of their background, can so easily add features to an investment research platform. The MIT Open Source license allows any user to fork the project to either add features to the broader community or create their own customized terminal version.

Alpha Vantage delivers a free API for real time financial data and most used finance indicators in a simple json or pandas format. This module implements a python interface to the free API provided by Alpha Vantage. You can have a look at all the API calls available in their API documentation. For code-less access to the APIs, you may also consider the official Google Sheet Add-on or the Microsoft Excel Add-on by Alpha Vantage. To get data from the API, simply import the library and call the object with your API key. ...

US Tax Forms (1040 Schedule D and 8949 supplemental forms) require that every capital gains sale is listed by line, even if no cost basis or even a 1099-B has been provided to the IRS. Entering this data into tax software like TurboTax is tedious and error prone. Some institutions provide limited export capabilities such as CSV or excel export but this is not easy to translate into tax preparation software. These python scripts convert two simple to generate input files BuyLots.csv and Sales.csv into a .TXF file that can be imported into tax prep software and a second RemainingLots.csv that can be used for next year. The scripts automatically calculate the First In First Out lots for every sale and properly tag them in the TXF format ( https://turbotax.intuit.com/txf/TXF042.jsp ). ...

Pyspread is a non-traditional spreadsheet application that is based on and written in the programming language Python. The goal of pyspread is to be the most pythonic spreadsheet. Pyspread expects Python expressions in its grid cells, which makes a spreadsheet specific language obsolete. Each cell returns a Python object that can be accessed from other cells. These objects can represent anything including lists or matrices. Dependencies + Python (>=2.7, <3.0) + numpy (>=1.1.0) + wxPython (>=2.8.10.1, Unicode version required) + matplotlib (>=1.1.1) + pycairo (>=1.8.8) Optional dependencies + python-gnupg (>=0.3.0, for opening own files without approval) + xlrd (>=0.9.2, for loading Excel® files) + xlwt (>=0.9.2, for saving Excel files, pyspread >=v0.3.0 required) + jedi (>=0.8.0, for tab completion and context help in the entry line, pyspread >=v0.3.0 required) + basemap (>=1.0.7, for the weather example pys file)

An Excel addin and server framework for implementing remote excel user-defined functions (UDFs). This framework is designed to provide a centralised warehouse of functions for Excel users (eg. within an organisation).

Generating Excel 97+ files with Python 2.4+ (need decorators), importing Excel 95+ files, support for UNICODE in Excel files, using variety of formatting features and printing options, Excel files and OLE2 compound files dumper. No need in Windows/COM

PythonOffice is a Python API for the Ms XML (Excel) Spreadsheet format. It allows you to read and write Excel XML documents from within the Python programming language. In future, support for other formats is planned, including OOo, Ms Open Xml.

pyXLWriter is a Python library for generating Excel compatible spreadsheets. It's a port of John McNamara's Perl Spreadsheet::WriteExcel 1.0 module (see http://www.cpan.org) to Python. Requires Python 2.1+. [Project was stopped]

The main purpose of "python2xlw" is to create an Excel-compatible file which can be sent to users via the web as an excel application. The motivation is mainly to support the display of XY Scatter plots and tabular numerical data(eg engineering data)