JAVA Excel Designner

Jxcell is a high performance java component which can write, read, calculate Excel compatible files without the need for Microsoft Excel on either the developer or client machines. It was entirely written in 100% pure java code.

Jxcell is also a swing component which most like excel,it behave exactly like excel.You can transfer data between excel and jxcell.

Features

Look at the following table for the list of Jxcell features:

Jxcell Feature

Sample Code

Sample Files

Unicode support

CSV files (delimited with comma, tab, semicolon or any other separator)

CsvChartTest.java

Excel 2007 OpenXML support

OpenXML.java

Open Encrypted Excel files and Save Encrypted Excel files

Encrypt&Decrypt.java

Multiple worksheets per file

Template support (create new workbooks using existing workbook as a template)

Various cell data types (numbers, strings,dates, floating point etc.)

Custom number formatting

Merged regions

Cell styles (alignment, indentation, rotation, borders, shading, protection, text wrapping and shrinking etc.)

Font formatting (size, color, font type, italic and strikeout properties, different levels of boldness, underlining, subscript and superscript)

formatting options(font,color,content format,pattern,border line,border color,align).

Conditional Formats (Apply cell formats when the value of a cell or formula meets a predetermined set of conditions..)

conditionalformat.rar

output conditionformats.xls

Text orientation and Applying different formatting to parts of a cell

textformatting.java

output textformatting.xls

Data Validation

datavalidation.java

output datavalidation.xls

Copy/Move/Delete (Cells can be copied, moved and deleted with the same behaviour as in Excel. Rows and columns can be copied and moved as well.Copy/move between sheets are supported. Entire sheets can be copied.)

RangeCopy.java

Row height and column width

Formula support (absolute and relative references, names, 3D cell references, more than 260 supported functions)

FormulaTest.java

output out.xls

Named ranges(Names can be used where you want.Access cells through their name is easy)

Calculation Engine(Cells and whole worksheets can be calculated)

Formulas with referrences to external workbooks are supported as well.

Group.java

Charts(Supports all standard Chart Types like Column, Bar, Line, Pie, Scatter etc)

CsvChartTest.java

input book.csv output barChart.xls columnChart.xls lineChart.xls pieChart.xls areaChart.xls

Customize Charts (stack chart,percent Pie chart data lable,chart format set etc)

chartsample.rar(863k)

Pictures support (BMP, JPG, GIF, PNG, WMF)

PicTest.java

PicTest.rar(1517k)

Hyperlink support(cell link,url link,email link,file link)

Hyperlinks.java

hyperlink.xls

Export data to(Excel files,CSV text files,HTML fils.)

Convert Excel to Pdf file

pdfprint.java

PdfPrint.rar(2021k)

Access all printing options (Select paper size, set margins. Set header and footer, including formatting codes. Define printing areas. Set page breaks. Preserving print area and summaries)

Spreadsheet Designer.

View,Create,Modify,Print spreadsheet in Swing gui Component.

Java spreadsheet Applet

book.htm(Java Runtime Needed)

supports VBA and macros(Copy from template).