Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (309)
Collections:
Other Resources:
What Is jxl.jar 2.6.12
What is jxl.jar 2.6.12?
✍: fyicenter.com
jxl.jar 2.6.12 is the JAR file for Java Excel API 2.6.12, which is a Java library for reading, writing and modifying Microsoft Excel spreadsheet files.
JAR File Size and Download Location:
JAR name: jxl-2.6.12.jar Target JDK version: 1.6 Dependency: None File name: jxl.jar File size: 725735 bytes Release date: 24-Oct-2009 Download: Java Excel API Website.
Here are Java Source Code files for jxl-2.6.12.jar:
⏎ jxl/write/NumberFormats.java
/********************************************************************* * * Copyright (C) 2002 Andrew Khan * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA ***************************************************************************/ package jxl.write; import jxl.biff.DisplayFormat; import jxl.format.Format; /** * Static class which contains the available list of built in Number formats */ public final class NumberFormats { /** * Inner class which holds the format index */ private static class BuiltInFormat implements DisplayFormat, Format { /** * The built in number format index */ private int index; /** * The format string */ private String formatString; /** * Constructor, using the predetermined index * * @param i the index * @param s the string */ public BuiltInFormat(int i, String s) { index = i; formatString = s; } /** * Accessor for the format index * * @return the index */ public int getFormatIndex() { return index; } /** * Accessor to determine if this format has been initialized. Since it is * built in, this will always return TRUE * * @return TRUE, since this is a built in format */ public boolean isInitialized() { return true; } /** * Determines whether this format is a built in format * * @return TRUE, since this is a built in numerical format */ public boolean isBuiltIn() { return true; } /** * Initializes this format with a dynamically determined index value. * Since this is a built in, and hence the index value is predetermined, * this method has an empty body * * @param pos the pos in the number formats list */ public void initialize(int pos) { } /** * Accesses the excel format string which is applied to the cell * Note that this is the string that excel uses, and not the java * equivalent * * @return the cell format string */ public String getFormatString() { return formatString; } /** * Standard equals method * * @param o the object to compare * @return TRUE if the two objects are equal, FALSE otherwise */ public boolean equals(Object o) { if (o == this) { return true; } if (!(o instanceof BuiltInFormat)) { return false; } BuiltInFormat bif = (BuiltInFormat) o; return index == bif.index; } /** * Standard hash code method * * @return the hash code */ public int hashCode() { return index; } } // The available built in number formats // First describe the fairly bog standard formats /** * The default format. This is equivalent to a number format of '#' */ public static final DisplayFormat DEFAULT = new BuiltInFormat(0x0, "#"); /** * Formatting for an integer number. This is equivalent to a DecimalFormat * of "0" */ public static final DisplayFormat INTEGER = new BuiltInFormat(0x1, "0"); /** * Formatting for a float. This formats number to two decimal places. It * is equivalent to a DecimalFormat of "0.00" */ public static final DisplayFormat FLOAT = new BuiltInFormat(0x2, "0.00"); /** * Formatting for an integer that has a thousands separator. * Equivalent to a DecimalFormat of "#,##0" */ public static final DisplayFormat THOUSANDS_INTEGER = new BuiltInFormat(0x3, "#,##0"); /** * Formatting for a float that has a thousands separator. * Equivalent to a DecimalFormat of "#,##0.00" */ public static final DisplayFormat THOUSANDS_FLOAT = new BuiltInFormat(0x4, "#,##0.00"); /** * Formatting for an integer which is presented in accounting format * (ie. deficits appear in parentheses) * Equivalent to a DecimalFormat of "$#,##0;($#,##0)" */ public static final DisplayFormat ACCOUNTING_INTEGER = new BuiltInFormat(0x5, "$#,##0;($#,##0)"); /** * As ACCOUNTING_INTEGER except that deficits appear coloured red */ public static final DisplayFormat ACCOUNTING_RED_INTEGER = new BuiltInFormat(0x6, "$#,##0;($#,##0)"); /** * Formatting for an integer which is presented in accounting format * (ie. deficits appear in parentheses) * Equivalent to a DecimalFormat of "$#,##0;($#,##0)" */ public static final DisplayFormat ACCOUNTING_FLOAT = new BuiltInFormat(0x7, "$#,##0;($#,##0)"); /** * As ACCOUNTING_FLOAT except that deficits appear coloured red */ public static final DisplayFormat ACCOUNTING_RED_FLOAT = new BuiltInFormat(0x8, "$#,##0;($#,##0)"); /** * Formatting for an integer presented as a percentage * Equivalent to a DecimalFormat of "0%" */ public static final DisplayFormat PERCENT_INTEGER = new BuiltInFormat(0x9, "0%"); /** * Formatting for a float percentage * Equivalent to a DecimalFormat "0.00%" */ public static final DisplayFormat PERCENT_FLOAT = new BuiltInFormat(0xa, "0.00%"); /** * Formatting for exponential or scientific notation * Equivalent to a DecimalFormat "0.00E00" */ public static final DisplayFormat EXPONENTIAL = new BuiltInFormat(0xb, "0.00E00"); /** * Formatting for one digit fractions */ public static final DisplayFormat FRACTION_ONE_DIGIT = new BuiltInFormat(0xc,"?/?"); /** * Formatting for two digit fractions */ public static final DisplayFormat FRACTION_TWO_DIGITS = new BuiltInFormat(0xd,"??/??"); // Now describe the more obscure formats /** * Equivalent to a DecimalFormat "#,##0;(#,##0)" */ public static final DisplayFormat FORMAT1 = new BuiltInFormat(0x25, "#,##0;(#,##0)"); /** * Equivalent to FORMAT1 except deficits are coloured red */ public static final DisplayFormat FORMAT2 = new BuiltInFormat(0x26, "#,##0;(#,##0)"); /** * Equivalent to DecimalFormat "#,##0.00;(#,##0.00)" */ public static final DisplayFormat FORMAT3 = new BuiltInFormat(0x27, "#,##0.00;(#,##0.00)"); /** * Equivalent to FORMAT3 except deficits are coloured red */ public static final DisplayFormat FORMAT4 = new BuiltInFormat(0x28, "#,##0.00;(#,##0.00)"); /** * Equivalent to DecimalFormat "#,##0;(#,##0)" */ public static final DisplayFormat FORMAT5 = new BuiltInFormat(0x29, "#,##0;(#,##0)"); /** * Equivalent to FORMAT5 except deficits are coloured red */ public static final DisplayFormat FORMAT6 = new BuiltInFormat(0x2a, "#,##0;(#,##0)"); /** * Equivalent to DecimalFormat "#,##0.00;(#,##0.00)" */ public static final DisplayFormat FORMAT7 = new BuiltInFormat(0x2b, "#,##0.00;(#,##0.00)"); /** * Equivalent to FORMAT7 except deficits are coloured red */ public static final DisplayFormat FORMAT8 = new BuiltInFormat(0x2c, "#,##0.00;(#,##0.00)"); /** * Equivalent to FORMAT7 */ public static final DisplayFormat FORMAT9 = new BuiltInFormat(0x2e, "#,##0.00;(#,##0.00)"); /** * Equivalent to DecimalFormat "##0.0E0" */ public static final DisplayFormat FORMAT10 = new BuiltInFormat(0x30, "##0.0E0"); /** * Forces numbers to be interpreted as text */ public static final DisplayFormat TEXT = new BuiltInFormat(0x31, "@"); }
⏎ jxl/write/NumberFormats.java
Or download all of them as a single archive file:
File name: jxl-2.6.12-src.zip File size: 824057 bytes Release date: 2009-10-24 Download
⇐ What Is jexcelapi_2_6_12.zip
2017-06-09, 68417👍, 6💬
Popular Posts:
pache Derby is an open source relational database implemented entirely in Java and available under t...
JLayer is a library that decodes/plays/converts MPEG 1/2/2.5 Layer 1/2/3 (i.e. MP3) in real time for...
Apache Log4j 1.2 Bridge allows applications coded to use Log4j 1.2 API to use Log4j 2 instead. Bytec...
MP3SPI is a Java Service Provider Interface that adds MP3 (MPEG 1/2/2.5 Layer 1/2/3) audio format su...
Jackson is "the Java JSON library" or "the best JSON parser for Java". Or simply as "JSON for Java"....