Search Results for "software relational database"

PipeDream 4 can be used for word processing: to create letters, reports, invitations, film scripts and books. You can also use PipeDream 4 as a spreadsheet: to create ledgers, simple shopping lists, complex scientific models and cash flow forecasts. You can even use PipeDream 4 as a database for storing parts lists, names and addresses, details of personal collections and mark sheets. PipeDream 4 requires RISC OS 3.1 or later to run. If you only have RISC OS 2.0 or 2.01, PipeDream 3 is...

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 most common office suite packages. ...

https://sourceforge.net/projects/in2sql Video for best usage https://rb.gy/tvl8lk This Excel Addin helps SQL analytic create an Excel report based on ODBC relational data. *Creates table base on data from a relational database *Generate a pivot report using the same external connection (1) *Some ad-hoc tools are available - like "keep only" and "remove only" *you can use the row limit option for exploring the largest dataset *The ODBC connection manager is available *auto-build query tool can create SQL select statement by using different database tables with matching them by column name * creating connections for PowerQuery news and updates -- change list -- v05 beta export tables and SQL to CSV files treat CSV like relational tables -- add Cloud ClickHouse Source resolve the problem with an untrusted source changed Sql Editor fixed behavior for "update rows"

The PalOOCa Project offers a fast, flexible and intuitive Office-based Business Intelligence solution based on Jedox. It provides an extension for OpenOffice.org Calc which allows both, read and write, access to data from within the Jedox OLAP Server via Calc. If used together with the Open Source Jedox/Palo OLAP Server it completes the Open Source MOLAP-Stack for Business Intelligence. Additionally to Jedox OLAP it is also (read-only) compatible to (almost) all OLAP servers supporting...

Technical analysis library with indicators like ADX, MACD, RSI, Stochastic, TRIX... includes also candlestick pattern recognition. Useful for trading application developpers using either Excel, .NET, Mono, Java, Perl or C/C++.

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.

The Oracle ExcelDocumentType project provides an open source Oracle PL/SQL user defined type and utilities designed to generate fully functional Microsoft Excel spreadsheets from within the database. The code generates Excel XML data.

A tool to query arrays in memory using SQL. It groups the arrays in tables and returns arrays as result set. It can be used in spreadsheets, as a script language library and everywhere is needed an interactive tool to query data in memory.

This program converts, compares, merges, normalizes, and refactors data to and from disparate sources (CSV, Excel, and any JDBC/ODBC database) for use in a Java program.

ErgoTabcalc is a general calculation and report system. Calculation sequences are stored in the database. These sequences are made from simple operations on data, eg, add two table columns, or sort a table. This is similar to relational algebra.

The FastForward framework allows fast development of 3-tier spreadsheet applications. The spreadsheet is used as a browser, which can send and receive data. The project implements a spreadsheet add-on and data manipulation library for the web server.

Framework for development of MS Excel add-ins that allow user defined functions that return more than a single value (e.g. to return table data with a single function call)

GenerateXLS is an ASP script that generates a comma delimited (CSV) file (that you can then open in Excel or some similar spreadsheet software) from a database.

Append hundreds of different XML files into one large data document, validate, and attach a stylesheet. Stitcher is a porwerful summary reporting tool. Allows for complex file storage locations of xml data. UBL, HR-ML, LandXML ... visit stitcher.org.

Excel Quick Reports is a set of tools intended for quick WYSWIG prototiping and publishing of quality Excel reports (in Excel XML format). Reports are rendered using automatically generated XSLT and XML data extracted from database.