Free excel 0.1 software for linux

XML::Excel is a Perl extension converting Excel files to XML.

SYNOPSIS

use XML::Excel;
$excel_obj = XML::Excel->new();
$excel_obj = XML::Excel->new(%attr);

$status = $excel_obj->parse_doc(file_name);
$status = $excel_obj->parse_doc(file_name, %attr);

$excel_obj->declare_xml(%attr);
$excel_obj->declare_doctype(%attr);

$excel_obj->print_xml(file_name, %attr);

XML::Excel is a new module which is going to be upgraded very often as my time permits. For the time being it uses Spreadsheet::ParseExcel module object default values to parse the (*.xls) document and then creates a perl data structure with xml tags names and data. At this point it does not allow for a write as you parse interface but is the first upgrade for the next release. I will also allow more access to the data structures and more documentation.

I will also put in more support for XML, since currently it only allows a simple XML structure. Currently you can modify the tag structure to allow for attributes. No DTD support is currently available, but will be implemented in a soon coming release. As the module will provide both: object and event interfaces, it will be used upon individual needs, system resources, and required performance. Ofcourse the DOM implementation takes up more resources and in some instances timing, its the easiest to use.

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.

php_writeexcel is a port of John McNamaras excellent Spreadsheet::WriteExcel Perl package to PHP. It allows you to generate Microsoft Excel documents on your PHP enabled Web server without any other tools.
Ive included six example PHP scripts which are also taken out of the
Spreadsheet::WriteExcel package and ported to PHP:
- example-simple.php
- example-merge2.php
- example-stocks.php
- example-textwrap.php
- example-demo.php
- example-bigfile.php
All you have to do is to tar xzvf the package to a directory accessible via a web server. Then fetch any of the example scripts with your favourite web browser and Excel should come into place and show you a sheet.
Basically all features of Spreadsheet::WriteExcel are supported and thanks to a lot of people (see CHANGELOG) who contributed code and bug fixes, most things seem to work. However, please remember that its still in beta stage, so there are probably some bugs left.
Spreadsheet::WriteExcel uses the Parse::RecDescent package for formula support. Andreas Brodowski has imported and changed the PEAR::Spreadsheet Parser.php file, so formulas are supported since version 0.2.2.
Spreadsheet::WriteExcel uses the OLE::Storage_Lite package for supporting Excel files bigger than approx. 7 MB. I have ported this package already and called it php_ole. But I really dont know how reliable it is, so use it with care!
Enhancements:
- PHP5 compatibility has been added.
- Several bugs have been fixed.

DateTime::Format::Excel is a Perl module that can convert between DateTime and Excel dates.

SYNOPSIS

use DateTime::Format::Excel;

# From Excel via class method:

my $datetime = DateTime::Format::Excel->parse_datetime( 37680 );
print $datetime->ymd(.); # 2003.02.28

# or via an object

my $excel = DateTime::Format::Excel->new();
print $excel->parse_datetime( 25569 )->ymd; # 1970-01-01

# Back to Excel number:

use DateTime;
my $dt = DateTime->new( year => 1979, month => 7, day => 16 );
my $daynum = DateTime::Format::Excel->format_datetime( $dt );
print $daynum; # 29052

# or via an object
my $other_daynum = $excel->format_datetime( $dt );
print $other_daynum; # 29052

Excel uses a different system for its dates than most Unix programs. This module allows you to convert between a few of the Excel raw formats and DateTime objects, which can then be further converted via any of the other DateTime::Format::* modules, or just with DateTimes methods.

If you happen to be dealing with dates between 1 Jan 1900 and 1 Mar 1900 please read the notes on epochs.

If youre wanting to handle actual spreadsheet files, you may find Spreadsheet::WriteExcel and Spreadsheet::ParseExcel of use.

Asterisell project is a Web based application for viewing, rating, and billing Asterisk VoIP calls.
Usage Scenario:
- you are a vendor of Voice over IP Telephony services (VoIP)
- your customers call other users who can reside on different telephone networks
- your customers pay you for this service
in order to route the calls on particular networks you have to use the services of other vendors
- you are a customer of others vendors
- you pays others vendors for this service
So Asterisell views you (the VoIP service provider) as a reseller of others vendors services. It permits to associate for every call a cost and an income. The cost is what the customer pays to the service provider and the cost is what the service provider pays to other vendors in order to route the call.
Main features:
Customer features:
- report of calls with aggregate totals
- many filter-criteria
- different sort-criteria
- export to CSV and MS Excel document
- many VoIP accounts associated with the same customer
Administrator features:
- input fields are secure from intrusion attempts
- each customer could have a cost limit for the last 30 days
- informal currency conversion table for the test of cost limits
- administrator is advised via email if a customer pass its cost limit
- different cultures for each VoIP account or Customer
- prices and messages are displayed in the specified culture
- customers can be grouped into different price list categories
- different rate methods applicable to different time periods, customer categories, destination gateway channels, destination telephone network etc..
- customizable rate methods adding PHP Class respecting a specific interface
- generation of customer invoices
- delivery of emails with invoice details to customers
- support bulk generation of invoices and emails to all customers with associated incomes
- support for multi-currency invoices (not yet tested)
- problems during rate process are reported and signaled via email to the administrator
General features:
- multi-culture and locales support (it_IT, en_US, ecc..)
- multi-currency support (not yet tested)

PloneExFile provides a Plone/AT content type with an attachment, supporting preview & indexing & lock.
PloneExFile is a file like content type that provides indexing and preview support for MS Word, MS Excel, MS Powerpoint, PDF and OO Writer files.
Works with:
- Plone 2.5
- Plone 2.1
Enhancements:
- Added German translations and fixed description of upgrade procedure; provided by Carsten Kirck. Thank you!

Spreadsheet::WriteExcelXML is a Perl module that can create an Excel file in XML format.

SYNOPSIS

To write a string, a formatted string, a number and a formula to the first worksheet in an Excel XML spreadsheet called perl.xls:

use Spreadsheet::WriteExcelXML;

# Create a new Excel workbook
my $workbook = Spreadsheet::WriteExcelXML->new("perl.xls");

# Add a worksheet
$worksheet = $workbook->add_worksheet();

# Add and define a format
$format = $workbook->add_format(); # Add a format
$format->set_bold();
$format->set_color(red);
$format->set_align(center);

# Write a formatted and unformatted string, row and column notation.
$col = $row = 0;
$worksheet->write($row, $col, "Hi Excel!", $format);
$worksheet->write(1, $col, "Hi Excel!");

# Write a number and a formula using A1 notation
$worksheet->write(A3, 1.2345);
$worksheet->write(A4, =SIN(PI()/4));

The Spreadsheet::WriteExcelXML module can be used to create an Excel file in XML format. The Excel XML format is supported in Excel 2002 and 2003.

Multiple worksheets can be added to a workbook and formatting can be applied to cells. Text, numbers, and formulas can be written to the cells. The module supports strings up to 32,767 characters and the strings can be in UTF8 format.

Spreadsheet::WriteExcelXML uses the same interface as Spreadsheet::WriteExcel.
This module cannot, as yet, be used to write to an existing Excel XML file.