millscript excel 0.1
Sponsored Links
Sponsored Links
Secleted [ 0 ] software to compare
Results 1 - 15 of about 2468
MillScript-Excel 0.1
MillScript-Excel project is a Java library for reading and writing Excel spreadsheets. more>>
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.
<<less Download (0.50MB)
Added: 2007-03-26 License: GPL (GNU General Public License) Price:
952 downloads
MillScript-XML 0.3
MillScript-XML is an alternative Java XML parsing library with its own custom API. more>>
MillScript-XML project is an alternative Java XML parsing library with its own custom API. The underlying tokenizer can be configured to permit non-well-formed XML.
This librarys API provides both an event model and a more conventional token stream model. The authors believe that the token stream is more friendly to applications, easier to use, and helps to minimise object creation and inter-conversion of types with the parser. A SAX2 implementation is provided for compatibility with existing applications.
In particular by making the tokenizer return Token objects instead of ints, we reduce the scope for unsupported token type creeping in. We have then implemented the visitor pattern for our Token objects, effectively bringing together the tokenizing and even style parsers into a common structure.
<<lessThis librarys API provides both an event model and a more conventional token stream model. The authors believe that the token stream is more friendly to applications, easier to use, and helps to minimise object creation and inter-conversion of types with the parser. A SAX2 implementation is provided for compatibility with existing applications.
In particular by making the tokenizer return Token objects instead of ints, we reduce the scope for unsupported token type creeping in. We have then implemented the visitor pattern for our Token objects, effectively bringing together the tokenizing and even style parsers into a common structure.
Download (0.066MB)
Added: 2007-03-26 License: GPL (GNU General Public License) Price:
942 downloads
MillScript-Util 0.1
MillScript-Util is an alternative to the standard Java Collections API. more>>
MillScript-Util is an alternative to the standard Java Collections API. The primary focus of MillScript-Util is to properly support features of MillScript at the Java level, in such a way that might be useful for other applications.
Main features:
- Immutability, updateability and extensibility separated in the API
- Lists, Sets and Bags unified with Maps
- Custom default actions, executed when mappings are not present
<<lessMain features:
- Immutability, updateability and extensibility separated in the API
- Lists, Sets and Bags unified with Maps
- Custom default actions, executed when mappings are not present
Download (0.13MB)
Added: 2007-03-26 License: GPL (GNU General Public License) Price:
942 downloads
MillScript 10.2.0
MillScript is an easy to use language for batch producing templated Web sites. more>>
MillScript projetc is a full featured, yet easy to use language for the batch production of templated Web sites.
The language is a Java-based, early implementation of Spice: an experimental language developed by the OpenSpice group.
MillScript benefits from a carefully considered and consistent syntax that should be most beneficial to ocassional and cross-over programmers. Its features include multiple valued expressions, embedded XML tags, powerful for loops, a rich template system, lambda functions, closures, classes, and methods, regular expressions, and more.
Enhancements:
- Temporarily removed SVG support as the Apache License is not compatible with the GPL. As soon as I find a GPL compatible alternative Ill reinstate this functionality
- Implemented Serializable for all classes are based on MillScript-Util functionality
- Fixed an issue with embedded XML which caused an exception when an attribute value was not a string
- Fixed an off by one error in the subrange function(used by the subrange syntax [X..Y])
- Updated to use new AlertReporter interface from MillScript-Alert
- Removed the Excel file loader, this can now be found in the MillScript-Excel package, which uses the new plugin system to add the loader into an installation.
- Added a simple plugin infrastructure, which scans for plugin configuration files on startup.
- Fixed the HTML renderers emtpy element tag set to match the HTML specification, i.e. an IFRAME is no longer considered an empty element, but the non-standard BGSOUND, SPACER and WBR tags are.
- Added XML namespace support to MillScript, via XML files in an inventory, but not within the MillScript language(which will come later)
- Added support for fat strings, i.e. strings that can span multiple lines. Fat strings are intended to bridge the gap between single line strings and autoloadable text files, i.e. medium length strings.
- Added support for chained relational expressions, e.g. x < y < z, where each expression is evaluated once and only if required.
- Added support for loading Excel spreadsheets. This is strictly limited to spreadsheets with text, numbers and very simple formulas(e.g. simple arithmetic and no floating point). Upgrades to this support are planned :-)
- Ensure methods report their name, rather than pretending to be anonymous.
- Added a properties file renderer and function, so you can now easily write Java properties files.
- Migrating to Java 5 - added generics type information, annotated for overrides and suppressing warnings and added enumerations
- Simplified name resolution code.
- Migrated Map(and List, etc) functionality from the Java Collections API to the new MillScript-Util one. This unifies Lists and Maps at the Java level, rather than the MillScript one.
- Fixed the bug stopping you from updating an list when indexing with negative indicies.
- Migrated all internal use of XML to MillScripts own custom XML parser and API, rather than the previous SAX and DOM based ones. This has included using the new parsers Name and Attribute(s) interfaces and implementations where appropriate.
- Migrated the template loaders to use the SAX API rather than transforming a DOM object.
- Added te-common library for command line argument parsing. Added a Java implementation of the website and status commands. More will follow.
- Added serialVersionUIDs to serializable classes, to enable version handling when serializing.
- Added a TrueType font loader, so you can now put TrueType fonts in your inventory and load them. When we have a graphics API youll be able to use these to draw onto images.
<<lessThe language is a Java-based, early implementation of Spice: an experimental language developed by the OpenSpice group.
MillScript benefits from a carefully considered and consistent syntax that should be most beneficial to ocassional and cross-over programmers. Its features include multiple valued expressions, embedded XML tags, powerful for loops, a rich template system, lambda functions, closures, classes, and methods, regular expressions, and more.
Enhancements:
- Temporarily removed SVG support as the Apache License is not compatible with the GPL. As soon as I find a GPL compatible alternative Ill reinstate this functionality
- Implemented Serializable for all classes are based on MillScript-Util functionality
- Fixed an issue with embedded XML which caused an exception when an attribute value was not a string
- Fixed an off by one error in the subrange function(used by the subrange syntax [X..Y])
- Updated to use new AlertReporter interface from MillScript-Alert
- Removed the Excel file loader, this can now be found in the MillScript-Excel package, which uses the new plugin system to add the loader into an installation.
- Added a simple plugin infrastructure, which scans for plugin configuration files on startup.
- Fixed the HTML renderers emtpy element tag set to match the HTML specification, i.e. an IFRAME is no longer considered an empty element, but the non-standard BGSOUND, SPACER and WBR tags are.
- Added XML namespace support to MillScript, via XML files in an inventory, but not within the MillScript language(which will come later)
- Added support for fat strings, i.e. strings that can span multiple lines. Fat strings are intended to bridge the gap between single line strings and autoloadable text files, i.e. medium length strings.
- Added support for chained relational expressions, e.g. x < y < z, where each expression is evaluated once and only if required.
- Added support for loading Excel spreadsheets. This is strictly limited to spreadsheets with text, numbers and very simple formulas(e.g. simple arithmetic and no floating point). Upgrades to this support are planned :-)
- Ensure methods report their name, rather than pretending to be anonymous.
- Added a properties file renderer and function, so you can now easily write Java properties files.
- Migrating to Java 5 - added generics type information, annotated for overrides and suppressing warnings and added enumerations
- Simplified name resolution code.
- Migrated Map(and List, etc) functionality from the Java Collections API to the new MillScript-Util one. This unifies Lists and Maps at the Java level, rather than the MillScript one.
- Fixed the bug stopping you from updating an list when indexing with negative indicies.
- Migrated all internal use of XML to MillScripts own custom XML parser and API, rather than the previous SAX and DOM based ones. This has included using the new parsers Name and Attribute(s) interfaces and implementations where appropriate.
- Migrated the template loaders to use the SAX API rather than transforming a DOM object.
- Added te-common library for command line argument parsing. Added a Java implementation of the website and status commands. More will follow.
- Added serialVersionUIDs to serializable classes, to enable version handling when serializing.
- Added a TrueType font loader, so you can now put TrueType fonts in your inventory and load them. When we have a graphics API youll be able to use these to draw onto images.
Download (6.4MB)
Added: 2007-03-21 License: GPL (GNU General Public License) Price:
948 downloads
MillScript-Alert 0.3.0
MillScript Alert is an extension to Java exceptions, providing much more useful debugging information. more>>
MillScript-Alert is an extension to Javas RuntimeException, with an emphasis on providing far more debugging information.
This system is used extensively by the MillScript project and its libraries, with good results.
Enhancements:
- Introduced the AlertReporter interface to abstract reporting alerts and handle different types of report
- Escape exception now prints the details of the alert that lead to the escape
- Switch to Java 5, add generics type information and annotate overrides
- Fixed alert to report the class of any parent alert or throwable object, so that you can see this information.
- Added serialVersionUIDs to serializable classes, to enable version handling when serializing.
- Added extra culprit methods to support all the primitive types as culprit values.
- Added an IllegalArgumentAlert to match the basic IllegalArgumentException.
<<lessThis system is used extensively by the MillScript project and its libraries, with good results.
Enhancements:
- Introduced the AlertReporter interface to abstract reporting alerts and handle different types of report
- Escape exception now prints the details of the alert that lead to the escape
- Switch to Java 5, add generics type information and annotate overrides
- Fixed alert to report the class of any parent alert or throwable object, so that you can see this information.
- Added serialVersionUIDs to serializable classes, to enable version handling when serializing.
- Added extra culprit methods to support all the primitive types as culprit values.
- Added an IllegalArgumentAlert to match the basic IllegalArgumentException.
Download (0.014MB)
Added: 2007-03-21 License: GPL (GNU General Public License) Price:
947 downloads
XML::Excel 0.02
XML::Excel is a Perl extension converting Excel files to XML. more>>
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.
<<lessSYNOPSIS
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.
Download (0.010MB)
Added: 2006-09-16 License: Perl Artistic License Price:
1135 downloads
php_writeexcel 0.3.0
php_writeexcel is a port of John McNamaras excellent Spreadsheet::WriteExcel Perl package to PHP. more>>
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.
<<lessIve 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.
Download (0.070MB)
Added: 2005-11-02 License: LGPL (GNU Lesser General Public License) Price:
1458 downloads
XLSperl 0.4
XLSperl module allows you to use Perl one-liners with Microsoft Excel files. more>>
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
<<lessSYNOPSYS
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
Download (0.009MB)
Added: 2007-07-26 License: Perl Artistic License Price:
822 downloads
Spreadsheet::WriteExcelXML 0.10
Spreadsheet::WriteExcelXML is a Perl module that can create an Excel file in XML format. more>>
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.
<<lessSYNOPSIS
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.
Download (0.14MB)
Added: 2006-12-04 License: Perl Artistic License Price:
1054 downloads
Spreadsheet::WriteExcel 2.18
Spreadsheet::WriteExcel is a Perl module which can be used to create native Excel binary files. more>>
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.
<<lessFormatted 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.
Download (0.46MB)
Added: 2007-01-25 License: Artistic License Price:
1024 downloads
tel 0.1.7
tel is a little console-based phone book program. more>>
tel is a little console-based phone book program. It allows adding, modifying, editing and searching of phone book entries right on your terminal. Pretty printing capabilities are also provided.
Entries are stored in simple csv file. This eases import and export with common spread sheet applications like Microsoft Excel or OpenOffice.org Calc.
The project is written in Python and distributed under the MIT license and therefore free software. You can download it free of charge, share it with your friends, modify and even sell it.
Originally tel was a little bash script developed by Pot and sabsirro in the german Ubuntu forum ubuntuusers.de. With development continuing at quick pace, bash quickly proved to be insufficient for writing such large projects as tel had now become.
First Pot and sabsirro planned to rewrite tel in Perl. But before development in perl had begun, lunar came up with a Python version of tel. This version was met with great interest. After a little while Pot and lunar agreed to continue this version as a separate project on BerliOS. When sabsirro joined the project after a little while, the tel developer team was complete.
<<lessEntries are stored in simple csv file. This eases import and export with common spread sheet applications like Microsoft Excel or OpenOffice.org Calc.
The project is written in Python and distributed under the MIT license and therefore free software. You can download it free of charge, share it with your friends, modify and even sell it.
Originally tel was a little bash script developed by Pot and sabsirro in the german Ubuntu forum ubuntuusers.de. With development continuing at quick pace, bash quickly proved to be insufficient for writing such large projects as tel had now become.
First Pot and sabsirro planned to rewrite tel in Perl. But before development in perl had begun, lunar came up with a Python version of tel. This version was met with great interest. After a little while Pot and lunar agreed to continue this version as a separate project on BerliOS. When sabsirro joined the project after a little while, the tel developer team was complete.
Download (0.023MB)
Added: 2007-03-30 License: MIT/X Consortium License Price:
938 downloads
Spreadsheet::ParseExcel 0.32
Spreadsheet::ParseExcel is a Perl module to get information from an Excel file. more>>
Spreadsheet::ParseExcel is a Perl module to get information from an Excel file.
This module allows you to get information from Excel file.
This module can handle files of Excel95, 97 and 2000. (and now supports Excel4)
The module will work on the majority of Windows, UNIX and Macintosh platforms.
<<lessThis module allows you to get information from Excel file.
This module can handle files of Excel95, 97 and 2000. (and now supports Excel4)
The module will work on the majority of Windows, UNIX and Macintosh platforms.
Download (0.096MB)
Added: 2007-05-05 License: Perl Artistic License Price:
919 downloads
Java2Excel 1.3.1
Java2Excel is a library that allows the generation of simple excel files using objects of type java.util.Collection. more>>
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.
<<lessThe 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.
Download (0.23MB)
Added: 2006-06-01 License: The Apache License 2.0 Price:
1241 downloads
pyXLWriter 0.4a3
pyXLWriter is a Python library for generating Excel spreadsheets. more>>
pyXLWriter is a Python library for generating Excel spreadsheets. Its a port of John McNamaras Spreadsheet::WriteExcel Perl module.
To install run python setup.py install in the root of the distribution.
Enhancements:
- Simple Worksheet.write correction (thanks to Frank Tobin)
- Corrected authors e-mail: fufff@users.sourceforge.net
<<lessTo install run python setup.py install in the root of the distribution.
Enhancements:
- Simple Worksheet.write correction (thanks to Frank Tobin)
- Corrected authors e-mail: fufff@users.sourceforge.net
Download (0.15MB)
Added: 2006-07-18 License: GPL (GNU General Public License) Price:
1200 downloads
Mr. Voice 2.2
Mr. Voice is a specific-purpose Perl/Tk front-end for an MP3 database. more>>
Mr. Voice is a specific-purpose Perl/Tk front-end for an MP3 database.
It was written to provide an easy-to-use MP3 solution for the production booth of an improv comedy troupe, and as such is tailored to providing quick searches and playback of MP3s that are split up into categories.
While not intended to be a standalone desktop MP3 player, others in a similar situation may find it useful.
What is Mr. Voice? A way to have a ton of audio at your disposal, and to be able to call up just the clip you need, just when you need it. If youre running any sort of production that needs audio, such as improv shows, theatre, church events, that sort of thing, Mr. Voice can help. It handles a wide variety of audio formats (MP3, OGG, WAV, AAC, WMA), can do queueing and playlisting, and has a powerful SQL database backend (without needing the overhead of a big database engine like MySQL).
Plus, its 100% free and open-source.
What isnt Mr. Voice? A general-purpose MP3 player. In fact, it doesnt play audio at all by itself - it farms that off to an audio player like XMMS or WinAmp. Its also probably not a wonderful iTunes replacement. Sure, you can categorize and search audio files, but its not designed to become a jukebox.
Enhancements:
- A new option under the Online Preferences to edit the XML-RPC (Mr. Voice Online) URL that is used (in case I need to change it again). It was hardcoded into the program before.
- Fixed bugs that were causing strange quote marks to appear in song and category names.
- Display the song filename in the "Edit Song" menu. Suggested by Bill in Portland.
- Display the time of a song next to the hotkey listing. Suggested by Ted in Chapel Hill.
- Added an option under the File menu to export the song list from your Mr. Voice database as either a text file or Microsoft Excel spreadsheet. Suggested by Ted in Chapel Hill.
<<lessIt was written to provide an easy-to-use MP3 solution for the production booth of an improv comedy troupe, and as such is tailored to providing quick searches and playback of MP3s that are split up into categories.
While not intended to be a standalone desktop MP3 player, others in a similar situation may find it useful.
What is Mr. Voice? A way to have a ton of audio at your disposal, and to be able to call up just the clip you need, just when you need it. If youre running any sort of production that needs audio, such as improv shows, theatre, church events, that sort of thing, Mr. Voice can help. It handles a wide variety of audio formats (MP3, OGG, WAV, AAC, WMA), can do queueing and playlisting, and has a powerful SQL database backend (without needing the overhead of a big database engine like MySQL).
Plus, its 100% free and open-source.
What isnt Mr. Voice? A general-purpose MP3 player. In fact, it doesnt play audio at all by itself - it farms that off to an audio player like XMMS or WinAmp. Its also probably not a wonderful iTunes replacement. Sure, you can categorize and search audio files, but its not designed to become a jukebox.
Enhancements:
- A new option under the Online Preferences to edit the XML-RPC (Mr. Voice Online) URL that is used (in case I need to change it again). It was hardcoded into the program before.
- Fixed bugs that were causing strange quote marks to appear in song and category names.
- Display the song filename in the "Edit Song" menu. Suggested by Bill in Portland.
- Display the time of a song next to the hotkey listing. Suggested by Ted in Chapel Hill.
- Added an option under the File menu to export the song list from your Mr. Voice database as either a text file or Microsoft Excel spreadsheet. Suggested by Ted in Chapel Hill.
Download (0.63MB)
Added: 2006-04-19 License: GPL (GNU General Public License) Price:
1292 downloads
Secleted [ 0 ] software to compare
Copyright Notice:
Software piracy is theft, Using crack, password, serial numbers, registration codes, key generators is illegal and prevent future software development. The above millscript excel 0.1 search only lists software in full, demo and trial versions for free download. Download links are directly from our mirror sites or publisher sites, torrent files or links from rapidshare.com, yousendit.com or megaupload.com are not allowed