MD5 校验值：7cd346351ab05a28e42aff65173e0141
ReadWrite.java 文件包含反编译后的源代码，请注意，该内容仅供学习和参考使用，不得用于非法用途。
package jxl.demo;
import com.leptonsoftware.fibernet.R;
import common.b;
import java.io.File;
import java.net.MalformedURLException;
import java.net.URL;
import java.util.ArrayList;
import java.util.Calendar;
import jxl.CellType;
import jxl.Workbook;
import jxl.format.Colour;
import jxl.format.UnderlineStyle;
import jxl.write.Blank;
import jxl.write.DateFormat;
import jxl.write.DateFormats;
import jxl.write.DateTime;
import jxl.write.Formula;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.NumberFormat;
import jxl.write.WritableCell;
import jxl.write.WritableCellFeatures;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableHyperlink;
import jxl.write.WritableImage;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class ReadWrite {
static Class class$jxl$demo$ReadWrite;
private static b logger;
private File inputWorkbook;
private File outputWorkbook;
static {
Class cls = class$jxl$demo$ReadWrite;
if (cls == null) {
cls = class$("jxl.demo.ReadWrite");
class$jxl$demo$ReadWrite = cls;
}
logger = b.getLogger(cls);
}
public ReadWrite(String str, String str2) {
this.inputWorkbook = new File(str);
this.outputWorkbook = new File(str2);
logger.setSuppressWarnings(Boolean.getBoolean("jxl.nowarnings"));
b bVar = logger;
StringBuffer stringBuffer = new StringBuffer();
stringBuffer.append("Input file: ");
stringBuffer.append(str);
bVar.info(stringBuffer.toString());
b bVar2 = logger;
StringBuffer stringBuffer2 = new StringBuffer();
stringBuffer2.append("Output file: ");
stringBuffer2.append(str2);
bVar2.info(stringBuffer2.toString());
}
static Class class$(String str) {
try {
return Class.forName(str);
} catch (ClassNotFoundException e10) {
throw new NoClassDefFoundError(e10.getMessage());
}
}
private void modify(WritableWorkbook writableWorkbook) {
logger.info("Modifying...");
WritableSheet sheet = writableWorkbook.getSheet("modified");
WritableCell writableCell = sheet.getWritableCell(1, 3);
WritableFont.FontName fontName = WritableFont.ARIAL;
writableCell.setCellFormat(new WritableCellFormat(new WritableFont(fontName, 10, WritableFont.BOLD)));
sheet.getWritableCell(1, 4).setCellFormat(new WritableCellFormat(new WritableFont(fontName, 10, WritableFont.NO_BOLD, false, UnderlineStyle.SINGLE)));
sheet.getWritableCell(1, 5).setCellFormat(new WritableCellFormat(new WritableFont(fontName, 10)));
WritableCell writableCell2 = sheet.getWritableCell(1, 6);
CellType type = writableCell2.getType();
CellType cellType = CellType.LABEL;
if (type == cellType) {
Label label = (Label) writableCell2;
StringBuffer stringBuffer = new StringBuffer();
stringBuffer.append(label.getString());
stringBuffer.append(" - mod");
label.setString(stringBuffer.toString());
}
sheet.getWritableCell(1, 9).setCellFormat(new WritableCellFormat(new NumberFormat("#.0000000")));
sheet.getWritableCell(1, 10).setCellFormat(new WritableCellFormat(new NumberFormat("0.####E0")));
sheet.getWritableCell(1, 11).setCellFormat(WritableWorkbook.NORMAL_STYLE);
WritableCell writableCell3 = sheet.getWritableCell(1, 12);
CellType type2 = writableCell3.getType();
CellType cellType2 = CellType.NUMBER;
if (type2 == cellType2) {
((Number) writableCell3).setValue(42.0d);
}
WritableCell writableCell4 = sheet.getWritableCell(1, 13);
if (writableCell4.getType() == cellType2) {
Number number = (Number) writableCell4;
number.setValue(number.getValue() + 0.1d);
}
sheet.getWritableCell(1, 16).setCellFormat(new WritableCellFormat(new DateFormat("dd MMM yyyy HH:mm:ss")));
WritableCell writableCell5 = sheet.getWritableCell(1, 17);
WritableCellFormat writableCellFormat = new WritableCellFormat(DateFormats.FORMAT9);
writableCell5.setCellFormat(writableCellFormat);
WritableCell writableCell6 = sheet.getWritableCell(1, 18);
if (writableCell6.getType() == CellType.DATE) {
Calendar calendar = Calendar.getInstance();
calendar.set(1998, 1, 18, 11, 23, 28);
((DateTime) writableCell6).setDate(calendar.getTime());
}
WritableCell writableCell7 = sheet.getWritableCell(1, 22);
if (writableCell7.getType() == cellType2) {
((Number) writableCell7).setValue(6.8d);
}
WritableCell writableCell8 = sheet.getWritableCell(1, 29);
if (writableCell8.getType() == cellType) {
((Label) writableCell8).setString("Modified string contents");
}
sheet.insertRow(34);
sheet.removeRow(38);
sheet.insertColumn(9);
sheet.removeColumn(11);
sheet.removeRow(43);
sheet.insertRow(43);
for (WritableHyperlink writableHyperlink : sheet.getWritableHyperlinks()) {
if (writableHyperlink.getColumn() == 1 && writableHyperlink.getRow() == 39) {
try {
writableHyperlink.setURL(new URL("http://www.andykhan.com/jexcelapi/index.html"));
} catch (MalformedURLException e10) {
logger.warn(e10.toString());
}
} else if (writableHyperlink.getColumn() == 1 && writableHyperlink.getRow() == 40) {
writableHyperlink.setFile(new File("../jexcelapi/docs/overview-summary.html"));
} else if (writableHyperlink.getColumn() == 1 && writableHyperlink.getRow() == 41) {
writableHyperlink.setFile(new File("d:/home/jexcelapi/docs/jxl/package-summary.html"));
} else if (writableHyperlink.getColumn() == 1 && writableHyperlink.getRow() == 44) {
sheet.removeHyperlink(writableHyperlink);
}
}
WritableCell writableCell9 = sheet.getWritableCell(5, 30);
WritableCellFormat writableCellFormat2 = new WritableCellFormat(writableCell9.getCellFormat());
writableCellFormat2.setBackground(Colour.RED);
writableCell9.setCellFormat(writableCellFormat2);
sheet.addCell(new Label(0, 49, "Modified merged cells"));
((Number) sheet.getWritableCell(0, 70)).setValue(9.0d);
((Number) sheet.getWritableCell(0, 71)).setValue(10.0d);
((Number) sheet.getWritableCell(0, 73)).setValue(4.0d);
sheet.addCell(new Formula(1, 80, "ROUND(COS(original!B10),2)"));
sheet.addCell(new Formula(1, 83, "value1+value2"));
sheet.addCell(new Formula(1, 84, "AVERAGE(value1,value1*4,value2)"));
sheet.addCell(new Label(0, 88, "Some copied cells", writableCellFormat));
sheet.addCell(new Label(0, 89, "Number from B9"));
sheet.addCell(sheet.getWritableCell(1, 9).copyTo(1, 89));
sheet.addCell(new Label(0, 90, "Label from B4 (modified format)"));
sheet.addCell(sheet.getWritableCell(1, 3).copyTo(1, 90));
sheet.addCell(new Label(0, 91, "Date from B17"));
sheet.addCell(sheet.getWritableCell(1, 16).copyTo(1, 91));
sheet.addCell(new Label(0, 92, "Boolean from E16"));
sheet.addCell(sheet.getWritableCell(4, 15).copyTo(1, 92));
sheet.addCell(new Label(0, 93, "URL from B40"));
sheet.addCell(sheet.getWritableCell(1, 39).copyTo(1, 93));
int i10 = 0;
while (i10 < 6) {
int i11 = i10 + 1;
sheet.addCell(new Number(1, i10 + 94, i11 + (i10 / 8.0d)));
i10 = i11;
}
sheet.addCell(new Label(0, 100, "Formula from B27"));
sheet.addCell(sheet.getWritableCell(1, 26).copyTo(1, 100));
sheet.addCell(new Label(0, 101, "A brand new formula"));
sheet.addCell(new Formula(1, 101, "SUM(B94:B96)"));
sheet.addCell(new Label(0, R.styleable.AppCompatTheme_textAppearanceSearchResultTitle, "A copy of it"));
sheet.addCell(sheet.getWritableCell(1, 101).copyTo(1, R.styleable.AppCompatTheme_textAppearanceSearchResultTitle));
sheet.removeImage(sheet.getImage(1));
sheet.addImage(new WritableImage(1.0d, 116.0d, 2.0d, 9.0d, new File("resources/littlemoretonhall.png")));
sheet.addCell(new Label(0, 151, "Added drop down validation"));
WritableCell blank = new Blank(1, 151);
WritableCellFeatures writableCellFeatures = new WritableCellFeatures();
ArrayList arrayList = new ArrayList();
arrayList.add("The Fellowship of the Ring");
arrayList.add("The Two Towers");
arrayList.add("The Return of the King");
writableCellFeatures.setDataValidationList(arrayList);
blank.setCellFeatures(writableCellFeatures);
sheet.addCell(blank);
sheet.addCell(new Label(0, 152, "Added number validation 2.718 < x < 3.142"));
Blank blank2 = new Blank(1, 152);
WritableCellFeatures writableCellFeatures2 = new WritableCellFeatures();
writableCellFeatures2.setNumberValidation(2.718d, 3.142d, WritableCellFeatures.BETWEEN);
blank2.setCellFeatures(writableCellFeatures2);
sheet.addCell(blank2);
((Label) sheet.getWritableCell(0, 156)).setString("Label text modified");
sheet.getWritableCell(0, 157).getWritableCellFeatures().setComment("modified comment text");
sheet.getWritableCell(0, 158).getWritableCellFeatures().removeComment();
}
public void readWrite() {
logger.info("Reading...");
Workbook workbook = Workbook.getWorkbook(this.inputWorkbook);
logger.info("Copying...");
WritableWorkbook createWorkbook = Workbook.createWorkbook(this.outputWorkbook, workbook);
if (this.inputWorkbook.getName().equals("jxlrwtest.xls")) {
modify(createWorkbook);
}
createWorkbook.write();
createWorkbook.close();
logger.info("Done");
}
}