Search Results for "cell"

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. To access spreadsheets via Google Sheets API you need to authenticate and authorize your application. Older versions of...

ImportExcel is a popular PowerShell module that enables reading, writing, and manipulating Excel spreadsheets without requiring Microsoft Excel to be installed on the host. It exposes straightforward cmdlets like Import-Excel and Export-Excel that convert between Excel sheets and PowerShell objects, making it simple to pipeline tabular data into reporting and automation flows. Advanced features include adding and formatting tables, setting number/date formats, creating charts, and applying...

This library represents XLSX files writer for Microsoft Excel 2007 and above. The main feature of this library is that it uses C++ standard file streams. On the one hand it results in almost unnoticeable memory and CPU resources consumption while processing (that may be very useful at saving a large data arrays), but on the other hand it makes unfeasible to edit data that were written. Hence, if using this library the structure of the future report should be known enough. The library...

...Some of the features include undo and redo, paint format, clear format, format, font, font size, font bold, font italic,, underline, strike, text color, fill color, borders, merge cells, align, text wrapping, freeze cell, functions, resize row-height, col-width, copy, cut, paste, autofill, insert row, column, delete row, column, hide row, column, multiple sheets, print, and data validations.

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

Create a roster by copying a list of email addresses from Outlook or consolidate multiple columns into one or two columns. Sheet control allows you to prefix all the sheets with numbers, sort the sheets alphabetically, or delete the desired sheets.

Fiscal Calendar in Excel generates an elegant calendar based on the year you type into cell J1, with July 1 being the first day of the fiscal year. The fiscal month begins on the last Monday of the previous month with a full work week (5 days). For example, the Monday ten days before Thanksgiving will be the first week of fiscal month December (November 13 in 2017). Fiscal Calendar in Excel allows you highlight certain business days each month and it'll highlight holidays every year. ...

Java tool that takes a source and a compare file as input and then generates following files if any differences are encountered: -Source file with differences marked and -Compare file with differences marked -Difference dump file containg all locations of differences, src value, compare value

Perform automatic operations between excel files.

A set of User Defined Functions for Excel to create in-cell charts : Sparklines. Sparklines are the simple, intense, word-sized graphics invented by Edward Tufte. Coded in Visual Basic for Applications.

TinyGraphs is an open source Excel add-in that creates sparklines, mini column graphs, and area graphs from rows of data. It generates beautiful tiny graphics that are as small as a cell and can be placed next to the items that they describe. The tiny gr

Ocular is a spreadsheet written entirely in python. Cell contents are evaluated by python after any standard spreadsheet coordinates are parsed. This allows the full Monty from Python to be implemented in a visual environment.

PHPEditTable is a class which mimics a simple spreadsheet behaviour. It handles cell formatting as well as math expressions based on cells' addresses parsing. Works with complicated formulas, setting properties on cell/row/column/range/sheet level.

...It's a "brick" to improve the spreadsheet Jeks from eTeks http://www.eteks.com. Openjeks can be plugged on a Jtable to format it with somes options (format, police, background, borders) for a cell or a cell set.