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/biff/ConditionalFormatRangeRecord.java
/********************************************************************* * * Copyright (C) 2007 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.biff; import jxl.common.Logger; import jxl.read.biff.Record; /** * Range information for conditional formatting */ public class ConditionalFormatRangeRecord extends WritableRecordData { // The logger private static Logger logger = Logger.getLogger(ConditionalFormatRangeRecord.class); /** * The enclosing range */ private Range enclosingRange; /** * The discrete ranges */ private Range[] ranges; /** * The number of ranges */ private int numRanges; /** * Initialized flag */ private boolean initialized; /** * Modified flag */ private boolean modified; /** * The data */ private byte[] data; private static class Range { public int firstRow; public int firstColumn; public int lastRow; public int lastColumn; public boolean modified; public Range() { modified = false; } /** * Inserts a blank column into this spreadsheet. If the column is out of * range of the columns in the sheet, then no action is taken * * @param col the column to insert */ public void insertColumn(int col) { if (col > lastColumn) { return; } if (col <= firstColumn) { firstColumn++; modified = true; } if (col <= lastColumn) { lastColumn++; modified = true; } } /** * Removes a column from this spreadsheet. If the column is out of range * of the columns in the sheet, then no action is taken * * @param col the column to remove */ public void removeColumn(int col) { if (col > lastColumn) { return; } if (col < firstColumn) { firstColumn--; modified = true; } if (col <= lastColumn) { lastColumn--; modified = true; } } /** * Removes a row from this spreadsheet. If the row is out of * range of the columns in the sheet, then no action is taken * * @param row the row to remove */ public void removeRow(int row) { if (row > lastRow) { return; } if (row < firstRow) { firstRow--; modified = true; } if (row <= lastRow) { lastRow--; modified = true; } } /** * Inserts a blank row into this spreadsheet. If the row is out of range * of the rows in the sheet, then no action is taken * * @param row the row to insert */ public void insertRow(int row) { if (row > lastRow) { return; } if (row <= firstRow) { firstRow++; modified = true; } if (row <= lastRow) { lastRow++; modified = true; } } } /** * Constructor */ public ConditionalFormatRangeRecord(Record t) { super(t); initialized = false; modified = false; data = getRecord().getData(); } /** * Initialization function */ private void initialize() { enclosingRange = new Range(); enclosingRange.firstRow = IntegerHelper.getInt(data[4], data[5]); enclosingRange.lastRow = IntegerHelper.getInt(data[6], data[7]); enclosingRange.firstColumn = IntegerHelper.getInt(data[8], data[9]); enclosingRange.lastColumn = IntegerHelper.getInt(data[10], data[11]); numRanges = IntegerHelper.getInt(data[12], data[13]); ranges = new Range[numRanges]; int pos = 14; for (int i = 0; i < numRanges; i++) { ranges[i] = new Range(); ranges[i].firstRow = IntegerHelper.getInt(data[pos], data[pos+1]); ranges[i].lastRow = IntegerHelper.getInt(data[pos+2], data[pos+3]); ranges[i].firstColumn = IntegerHelper.getInt(data[pos+4], data[pos+5]); ranges[i].lastColumn = IntegerHelper.getInt(data[pos+6], data[pos+7]); pos += 8; } initialized = true; } /** * Inserts a blank column into this spreadsheet. If the column is out of * range of the columns in the sheet, then no action is taken * * @param col the column to insert */ public void insertColumn(int col) { if (!initialized) { initialize(); } enclosingRange.insertColumn(col); if (enclosingRange.modified) { modified = true; } for (int i = 0 ; i < ranges.length ; i++) { ranges[i].insertColumn(col); if (ranges[i].modified) { modified = true; } } return; } /** * Inserts a blank column into this spreadsheet. If the column is out of * range of the columns in the sheet, then no action is taken * * @param col the column to insert */ public void removeColumn(int col) { if (!initialized) { initialize(); } enclosingRange.removeColumn(col); if (enclosingRange.modified) { modified = true; } for (int i = 0 ; i < ranges.length ; i++) { ranges[i].removeColumn(col); if (ranges[i].modified) { modified = true; } } return; } /** * Removes a row from this spreadsheet. If the row is out of * range of the columns in the sheet, then no action is taken * * @param row the row to remove */ public void removeRow(int row) { if (!initialized) { initialize(); } enclosingRange.removeRow(row); if (enclosingRange.modified) { modified = true; } for (int i = 0 ; i < ranges.length ; i++) { ranges[i].removeRow(row); if (ranges[i].modified) { modified = true; } } return; } /** * Inserts a blank row into this spreadsheet. If the row is out of range * of the rows in the sheet, then no action is taken * * @param row the row to insert */ public void insertRow(int row) { if (!initialized) { initialize(); } enclosingRange.insertRow(row); if (enclosingRange.modified) { modified = true; } for (int i = 0 ; i < ranges.length ; i++) { ranges[i].insertRow(row); if (ranges[i].modified) { modified = true; } } return; } /** * Retrieves the data for output to binary file * * @return the data to be written */ public byte[] getData() { if (!modified) { return data; } byte[] d = new byte[14 + ranges.length * 8]; // Copy in the original information System.arraycopy(data, 0, d, 0, 4); // Create the new range IntegerHelper.getTwoBytes(enclosingRange.firstRow, d, 4); IntegerHelper.getTwoBytes(enclosingRange.lastRow, d, 6); IntegerHelper.getTwoBytes(enclosingRange.firstColumn, d, 8); IntegerHelper.getTwoBytes(enclosingRange.lastColumn, d, 10); IntegerHelper.getTwoBytes(numRanges, d, 12); int pos = 14; for (int i = 0 ; i < ranges.length ; i++) { IntegerHelper.getTwoBytes(ranges[i].firstRow, d, pos); IntegerHelper.getTwoBytes(ranges[i].lastRow, d, pos+2); IntegerHelper.getTwoBytes(ranges[i].firstColumn, d, pos+4); IntegerHelper.getTwoBytes(ranges[i].lastColumn, d, pos+6); pos += 8; } return d; } }
⏎ jxl/biff/ConditionalFormatRangeRecord.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, 70858👍, 6💬
Popular Posts:
JDK 11 jdk.aot.jmod is the JMOD file for JDK 11 Ahead-of-Time (AOT) Compiler module. JDK 11 AOT Comp...
XML Serializer, Release 2.7.1, allows you to write out XML, HTML etc. as a stream of characters from...
JDK 11 jdk.jshell.jmod is the JMOD file for JDK 11 JShell tool, which can be invoked by the "jshell"...
JRE 5 sunjce_provider.jar is the JAR file for JRE 5 Sun JCE Provider, which provides implementations...
iText is an ideal library for developers looking to enhance web- and other applications with dynamic...