I would suggest taking a look at python/iPython & pandas data visualization.
Interactive in web browser with iPython & Scriptable
Pivot tables are a single line: e.g.: df.pivot(index='date', columns='variable', values='value')
From this really nice example by Chris Moffitt.
Calculated fields no problem at all - this is Pandas
Can directly read/...
Try OpenOffice or LibreOffice. Open Office is from Apache and it's free for linux. I don't know if it is free for Windows or not. When you go to the page, use the computer for which you want the installation and it should sense your operating system.
Here is a link for OpenOffice: openoffice.org
Text editors SynWrite (Windows) and CudaText (cross platform) can do this.
In these, you have "column selection mode", Alt+mouse drag. which selects rect block.
Note: To select also end of lines (where caret cannot go), turn on option "caret_after_end" in CudaText (and "Allow caret after end of line" in SynWrite).
I would suggest taking a look at ipython specifically with notebooks
Full power and flexibility of python available.
Allows a mix of data, calculations, formatted notes in markdown & html, pictures, much more. So definitely Documentable
You can construct and reuse building blocks and python modules so reuse is high.
Functions have to be written as clear ...
You could always look at Pyspread which reports that while row & col sizes depend on memory size, etc. according to the FAQ: For standard size on GTK platforms, 80 000 000 rows can be displayed. - I would expect similar sizes in columns to be available - as a test for your use case I resized the grid to 100,000x100,000 without problems.
If you must you could give pySpread a go - it can handle up to 80 000 000 rows subject to possible memory limitations.
Alternatively you could look at Python + Pandas - the combination is very good for dealing with large data sets.
All the above are free and cross platform, just not online.
I will list several answers based on what your question entails, feel free to take your pick as your ultimate solution.
My newer computer is a 64 bit Windows 7 (yes, it's an antique :-). The 2007 software will not install on my 64 bit computer.
Excel 32-bit should absolutely install on your 64-bit operating system, because it is backwards-compatible with ...
You can use Delimit:
offline and non-free (50 USD)
64-bit Windows 8.1, 8, or 7
Open data files up to 2 billion rows and 2 million columns large
Open large delimited data files; 100's of MBs or GBs in size
Quickly open any delimited data file.
Edit any cell.
Easily convert files from one delimiter to another like
CSV to TAB.
If I understand you correctly you want to manually gather information from a lot of files. The files are primarily Perl files, and you are looking for SELECT statements, and possibly other stuff.
The way I see it you have three options to organise the gathered information:
Using a spreadsheet – Today you have a rowspan for each file, and then separate ...
A second python based option if you like the spreadsheet look is PySpread - it looks like a traditional spreadsheet but each "cell" can contain anything up to a complete python program, it is Free & GPL3 but you do have to meet the dependencies and it will run under Windows, OS-X & Linux at least.
CSV import and export
Chart creation ...
These are the three best spreadsheet programs that I've found for Android:
I would definitely recommend installing all three of them to determine which one works best for your individual needs. They all have every feature you mentioned. I'm not sure if Microsoft Excel is free (I can't tell because I'm already ...
Google Sheets would seem to meet a lot of your needs:
Reasonably Full Spreadsheet Functionality
Multiple APIs available including REST, XML & JSON based IRL Fetch
Bindings such as the python google-api-python-client library
Push API Yes
Styling, Sorting, Filtering, etc.
Populate data including Add, Remove, etc.
Authorisation with OAUTH/OAUTH2
The Vaadin framework is a way to create interactive web-apps with the quality and style of desktop apps using pure Java on the server-side that are rendered automatically on the client-side using standard web technology transparently to the programmer.
Your Vaadin web app actually lives on the server though appears to the user in their web browser. ...
Here is a chart I made with Highcharts:
In this example I took the ...
This is not embedding Excel, but a Spreadsheet component that tries to provide functionality similar to Excel. Syncfusion Spreadsheet for WPF or Spreadsheet for Windows Forms support embedding Excel files in windows applications.
Windows Forms sample
Note that Essential Studio is required to be installed for the samples to compile.
Indeed, combining worksheets and databases, simple scripts are more suitable than Power Query. But easy-to-learn and easy-to-use processing scripts are rare. You can try esProc. I have a small example of this, and you can refer to:
A2=DB.query("select ORDERID,SELLERID,AMOUNT from sales")
A form in LibreOffice Base can ensure data consistency. However, doing everything you described in Base requires careful design and likely some macro programming.
As stated in the comments, Calc can do most or all of these things. Consider the following.
The small red arrow shows that there is more text that cannot be seen. Double-click on the line in ...
While Libreoffice like everyone suggested is a very rounded solution indeed for sake of completeness and more options I am also adding another opensource project here:
They offer self hosted option which is completely free and also a desktop version which is free and an effective replacement for MS Word, MS ...
Are you try to use GoogleSheets?
It's free and more useful for me. It's very similar with MS Exel: all scripts and formulas from Exel are working; you can import from Exel and export to Exel; you can share if it needs; you can use it online or offline.
ethercalc is available as a docker package you can self-host but you can also install it normally on GNU/Linux, FreeBSD, Mac OS X and Windows, using node.js. It runs with Redis, if available, or fall back on file-storage. And even better, it is a free software.
You could try out "kintone".
It has features to create multiple databases (which they call "Apps") via GUI, and you don't have to be an IT expert to create/edit these.
It also has a feature called "Spaces", which is like a forum for teams to share information. You can have club A creating and using their own "Space", and club B creating and using their ...
There is a python based spreadsheet pyspread that is able to use python code directly in each cell, in fact each cell can contain a complete python program, that you might like to take a look at.
But I would also strongly suggest taking a look at Jupyter notebooks. They will let you obtain, store, manipulate, evaluate and present your data in a lot of ways. ...
XML is the Extensible Markup Language. Are you sure you're not referring to .xls or .xlm files?
The best option IMHO is LibreOffice. LibreOffice Calc uses the ODS format by default, but it can read and write many others. Plus, it's free and open source.
I believe there a couple fo ways you can tackle you question, however it is important to keep in mind as to "what do you want to do with this data?". Basically if it is just for storage and edit, or maybe you would like to make some analysis? Below are a couple of possible solutions, since you were not precise on your use (how you wish to structure your data,...
You can do this with the Wolfram Alpha Data Drop service.
You could configure this to receive your data in a number of formats including emailing or tweeting into the database, imports from various source.
Similarly, you can read from it in a number of formats and create your own reports or analyses.
There is a Wolfram Alpha mobile app but, at present, it ...
You can use tables in Microsoft Word or Libreoffice Writer. You can easily set a column width and pasted text don flow to rows bellow. I managed to make a cell span for 15 pages without problem.
If you have problems with the page boundaries for the table, you can set the editor in web view mode.
For large file support, sorting, filtering, ect., you will be very hard pushed to beat Pandas.
Can read & write numerous formats including CSV, Excel & HDF.
Free, Gratis & Open Source
Cross Platform including Linux, Windows & OS-X
Fast & Powerful
Worth a look: There is also PyTables which uses HDF5 for managing hierarchical data sets ...