Free excel dates 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.

LibHdate is a small C,C++ library for Hebrew calendar and dates, holidays, and reading sequence (parasha).

LibHdate is using the sorce code from Amos Shapirs hdate package fixed and patched by Nadav HarEl.

The Torah reading sequence is from tables by Zvi HarEl.

Installation:

From source:

Untar:

tar -xvzf libhdate-XXX.tar.gz

Configure:

cd libhdate-XXX

configure --prefix=/usr [--enable-examples --enable-python --enable-perl --enable-pascal]
--enable-examples - build and install examples
--enable-python - build and install the python bindings
--enable-perl - build and install the perl bindings
--enable-pascal - build and install the pascal bindings

You will need swig and perl/python devel files.

Build:

make

Install:

make install (as root)

XLSperl module allows you to use Perl "one-liners" with Microsoft Excel files.

SYNOPSYS

XLSperl [options] -e ... file1.xls file2.xls ... fileX.xls
cat file.txt | XLSperl [options] -e ...

Perl "one-liners" have a great many uses for quick data processing tasks, often replacing the UNIX tools grep, sed, and awk. For example, a simple "grep" function can be written as:

perl -lne /pattern/ and print file.txt

which improves on the standard grep function by allowing the extended features of Perl regular expressions to be used.
However, this form of processing is only suitable for data that can be read (or needs to be written) in plain text format. XLSperl lets you use the same commands to process and create Microsoft Excel files, e.g. the following command will "grep" an Excel document:

XLSperl -lne /pattern/ and print file.xls

Usage:

Basic usage of XLSperl is as follows:

XLSperl [options] -e perl_code file1.xls file2.xls ... fileX.xls

Additionally Microsoft Excel files can be piped in to XLSperl

cat file.xls | XLSperl [options] -e perl_code

Parcelle project is a PyGTK application that captures and saves clipboard history.
Main features:
- Automatically captures clipboard changes.
- Saves clipboard history.
- Sort and search through entries.
- Edit and save changes to entries.
- Edit current clipboard contents.
- Dates entry additions and edits.
- Option to launch on startup to capture quietly.

Rose::DateTime is a Perl module with DateTime helper functions and objects.

SYNOPSIS

use Rose::DateTime::Util qw(:all);

$now = parse_date(now);
$then = parse_date(12/25/2001 6pm);

$date_text = format_date($then, "%D at %T %p");

...

use Rose::DateTime::Parser;

$parser = Rose::DateTime::Parser->new(time_zone => UTC);

$date = $parser->parse_date(12/25/1999);

The Rose::DateTime::* modules provide a few convenience functions and objects for use with DateTime dates.

Rose::DateTime::Util contains a simple date parser and a slightly customized date formatter.

Rose::DateTime::Parser encapsulates a date parser with an associated default time zone.

This module (Rose::DateTime) exists mostly to provide a version number for CPAN. See the individual modules for some actual documentation.

PHP Date Picker Class library will automatically generate the required HTML and JavaScript code that will make a pop-up window appear to let the user choose a date from a calendar. The selected date will be passed to a user-specified control from the calling page.
Every aspect is customizable by modifying a template and a related CSS file. The format in which the date is returned, the default date and time period, and the first day of the week can be selected.
Many thanks to Johan van Ieperen for sending in the dutch translation for the PHP class and for the valuable comments he made for improving usability, to Achim from Germany for finding the bug that would screw up the calendar on certain situations and also thank to Wassilios Meletiadis for sending in the german translation for this PHP class.
Further suggestions, comments and requests are welcommed. Id also really appreciate if you could send me links to the web pages where you are using the class so I can give them as refference and convince more people to use it. Thanks!
Enhancements:
- The selected date and time were not preserved if the month or year were changed.
- Using any date format other than the default would cause all dates to be disabled everywhere.
- A potential problem with selectableYearsRange and selectableTimesRange was fixed.
- The cause of the problem was the fact that PHPs date() function returns a string and therefore date("Y") would return the current date as a string rather than an integer, which made the calendar unusable.

Hebrew Calendar is a GTK class which shows the Hebrew dates and holydays and their corresponding Gregorian date. Hebrew Calendar is based on the GTK toolkit and it can be integrated in any piece of GTK software.

The dates convertor is a C++ class written by Nachum Dershowitz and Edward M. Reingold, and available in the Public Domain. There is also support for libhdate which is an open source hebrew to gregorian date library available in debian hebrew packages.