Search Results for "python"

gspread is a Python API for Google Sheets. A service account is a special type of Google account intended to represent a non-human user that needs to authenticate and be authorized to access data in Google APIs [sic]. Since it’s a separate account, by default it does not have access to any spreadsheet until you share it with this account. Just like any other Google account.

...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. ...

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. ...

Free alternative for Office productivity tools: Apache OpenOffice - formerly known as OpenOffice.org - is an open-source office productivity software suite containing word processor, spreadsheet, presentation, graphics, formula editor, and database management applications. OpenOffice is available in many languages, works on all common computers, stores data in ODF - the international open standard format - and is able to read and write files in other formats, included the format used by the...

OpenOffice.org Utility Library modules for creating Open Document Format (ODF) documents which can be read by Office Suites including OpenOffice.org, LibreOffice.org, and Microsoft Office. Currently, ooolib-python can create Calc spreadsheet ODS documents. These documents include many features including: - Create multiple table spreadsheets - Cells with text, numbers, dates, formulas - Ability to use built-in styles - Ability to create automatic styles (ie. bold, italics, underline, font size, font color, background color, etc.) - Set column and row attributes including width and height I am currently hosting the new development code at the following URL: https://github.com/josephcolton/ooolib-python I will be posting releases here on SourceForge as well as GitHub, so you can come to either place for the releases. ...

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).

The csvdatamix project aims to randomize CSV input data files in order to conceal the original state of the data. Similar to data masking or data transformation. Also has mapping abilities to translate back to the original state of the data.

Simple pure python spreadsheet class with ods export

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

Addition to payment system Cyberplat (http://cyberplat.com). Provide monitoring by browser, include PDA.

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)

NovaGrid is a light spreadsheet made with Python / Tkinter, based on Tktable. The objective of this project is to have a light spreasheet python object which can be used into larger projects. The code is totaly written in Python (actualy 2.2.2).