Free excel spreadsheets software for linux

CleanSheets is a spreadsheet application for the Java platform.

It features a formula language that closely resembles that of Microsoft Excel, and extensions for aiding end-user programmers in developing correct spreadsheets.

The application is written in Java, and relies on ANTLR for generating the formula compiler and the JFC/Swing JTable component for spreadsheet visualization.

Spreadsheet::Perl is a pure Perl implementation of a spreadsheet engine.
SYNOPSIS
use Spreadsheet::Perl;
use Spreadsheet::Perl::Arithmetic ;
my $ss = tie my %ss, "Spreadsheet::Perl"
$ss->SetNames("TEST_RANGE" => A5:B8) ;
$ss{TEST_RANGE} = 7 ;
DefineSpreadsheetFunction(AddOne, &AddOne) ;
$ss{A3} = PerlFormula($ss->AddOne("A5") + $ss{A5}) ;
print "A3 formula => " . $ss->GetFormulaText(A3) . "n" ;
print "A3 = $ss{A3}n" ;
$ss{ABC1:ABD5} = 10 ;
$ss{A4} = PerlFormula($ss->Sum("A5:B8", "ABC1:ABD5")) ;
print "A4 = $ss{A4}n" ;
...
Main features:
- set and get values from cells or ranges
- handle cell private data
- has fetch/store callback
- has cell attributes access
- has cell/range fillers (auto-fill functionality)
- set formulas (pure perl and common format)
- compute the dependencies between cells
- formulas can fetch data from multiple spreadsheets and the dependencies still work
- checks for circular dependencies
- debugging triggers
- has a simple architecture for expansion
- has a simple architecture for debugging (and some flags are already implemented)
- can read its data from a file
- supports cell naming
- cell and range locking
- input validators
- cell formats (pod, HTML, ...)
- can define spreadsheet functions from the scripts using it or via a new module of your own
- Recalculate() / AUTOCALC
- value caching to speed up formulas and volatile cells
- cell address offsetting functions
- Automatic formula offsetting
- Relative and fixed cell addresses
- slice access
- Perl scalar mapping to a cell
- some debugging tool (dump, dump table, dump to HTML, formula stack trace, ...)

Spreadsheet::WriteExcel module is can be used to create native Excel binary files.

Formatted text and numbers can be written to multiple worksheets in a workbook. Formulas and functions are also supported. It is 100% Perl and doesnt require any Windows libraries or a copy of Excel.

It will also work on the majority of Unix and Macintosh platforms. Generated files are compatible with Excel 97, 2000, 2002, and 2003, and with OpenOffice and Gnumeric. An older version also supports Excel 5/95.

Eprayer is a prayer request script that is easy to install and customize. It requires a MySQL database, but also creates a flat file for exporting into Excel.
Main features:
- Easy to customize
- Sends to multiple recipients
- Sends reply email to requester
- Valid XHTML and CSS
- Records information to a MySQL database as well as a flatfile for excel exporting
- Requires confirmation before sending
- Checks for errors
- Displays random requests on prayer request page
- Ability to set banned email addresses and banned words
- Released under GPL
- Free support via message boards

Yoxel SW provides an agile product management solution.
Yoxel SW is an agile product management solution allowing you to maintain a continuous feedback loop with your customers while collaboratively planning and implementing incremental releases.
WHY YOXEL SW?
To know what your customers expect, to collaboratively create relevant products, to deliver functional incremental releases on time.
- Maintain a continuous feedback loop with your customers while managing their feedback and a flow of new ideas.
- Effectively collaborate to determine which features to include into the next product release.
- Optimally allocate resources and accurately predict required project work.
- Simplify monitoring of the implementation and testing phases to always stay on schedule.
Main features:
- an agile product management solution for software companies/teams:
- Request Tracking System allows your R&D, Product Marketing, Program Management organizations to keep track of outstanding bugs, development requests, product requirements and allows your development team to stay focused.
- RTS is also a helpdesk enabling online customer support to allow direct customer feedback about your products and priorities of customer requests.
- Release Planning/Tracking System extends the RTS service into project management space. This service automates most of the planning, prioritization and resource allocation tasks that many software development teams do manually these days. It also provides you with a very convenient collaboration and release tracking environment.
- Adaptive vs. Predictive: RPS is flexible enough to allow your development teams to choose between waterfall/predictive and agile/adaptive methods of development. It is possible to implement SCRUM methodology by doing one month incremental releases in RPS.
- eXtra Reporting extends the RTS service by allowing you to create customized reports and spreadsheets using information stored in the request database. You can make your internal meetings or meetings with your customers more productive and professional by using these reports.
- Knowledge Base System allows your organization to effectively answer internal and external questions and accumulate product and support knowledge.

Java2Excel is a library that allows the generation of simple excel files using objects of type java.util.Collection.
The current verison of Java2Excel contains a lot of limitations. You can only write the collection in excel files using an xml file as a descriptor of what properties you want in the excel file. In the current state, there is not much error checking.
Example
The following is an example of an xml file used to configure the output to excel.
Please, note that this is a preliminary version and this file may not be compatible with future versions
< ?xml version="1.0" encoding="ISO-8859-1"?>
< !DOCTYPE java2excel PUBLIC
"-//epere4/DTD Java2Excel mapping file//EN"
"http://java2excel.sourceforge.net/dtd/java2excel-mapping.dtd">
< java2excel>
< header>
nothing for now
< /header>
< body>
< properties>
< property name="text">
< description>
This is a text property.
< /description>
< /property>
< property name="integerNumber" />
< property name="date" />
< property name="calendar" />
< property name="boolValue" />
< property name="internal.integerNumber" />
< /properties>
< /body>
< /java2excel>
The name attributes are ognl expressions that are applied to each element in the collection.
For example, integerNumber will be traduced to something like elementInCollection.getIntegerNumber() (with elementInCollection being the name of the variable for each element in the collection, of course). A more complex expresion like internal.integerNumber is equivalent to elementInCollection.getInternal().getIntegerNumber() (watch for NullPointerExceptions, here; there will be some protection for this in future releases)
The following is the code used in ar.com.epere4.java2excel.excelWritter.ExcelWritterTest .
The getMockCollection(5) method, not shown here, will just generate a java.util.Collection with 5 elements that will have all the properties requested by the XML file previously shown.
Parser parser = new Parser();
Java2ExcelDtd java2ExcelDtd = parser.parse(this.getClass()
.getResourceAsStream("/ar/com/epere4/java2excel/excelWritter/ExcelWritterTest.xml"));
ExcelWritter excelWritter = new ExcelWritter();
excelWritter.addReport(getMockCollection(5), java2ExcelDtd);
excelWritter.saveTo(new File("anExcel.xls"));
Enhancements:
- The "Too many different cell formats" error message in Excel was fixed.
- An id was added for properties.
- If not specified, it will continue to be the expression, as before.
- The setIncludeExtraLevel method was added to the BodyDtd interface.
- Maven 2.0 is now used.
- Maven 1.0 support should be considered deprecated.
- It will be maintained only for code dependencies, but the site will be generated using Maven 2.0 from now on.

MillScript-Excel project is a Java library for reading and writing Excel spreadsheets. The goal of the library is primarily to support all versions of Microsoft Excel, but other spreadsheet formats should also be added. The API is geared towards easy integration with other applications.