Jxcell Java Excel Designer

Description:

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:

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 5 Runtime Needed) supports VBA and macros(Copy from template).