把先引入表单元格的样式复制到后引入的表中

0 0

把先引入表单元格的样式复制到后引入的表中5

public class TestJxl {
public static void main(String args[]) {
JFileChooser jfc = new JFileChooser();
jfc.showOpenDialog(null);
File f1 = jfc.getSelectedFile();
int q, w;
List<String> list = new ArrayList<String>();
try {
FileInputStream fis = new FileInputStream(f1);
Workbook wb1 = Workbook.getWorkbook(f1);
jxl.Sheet st = wb1.getSheet(0);
Cell cell = null;
q = st.getColumns();
w = st.getRows();
System.out.println(q);
System.out.println(w);
for (int i = 0; i < q; i++) {
for (int j = 0; j < w; j++) {
cell = st.getCell(i, j);
list.add(cell.getContents());
}
}
for (String ss : list) {
System.out.println(ss);
}
jfc.showOpenDialog(null);
File f2 = jfc.getSelectedFile();
FileInputStream fis1=new FileInputStream(f2);
Workbook rwb=Workbook.getWorkbook(fis1);
WritableWorkbook wwb = Workbook.createWorkbook(f2,rwb);
WritableSheet dataSheet = wwb.getSheet(0);
jxl.write.WritableCellFormat CwcfF=
new jxl.write.WritableCellFormat(st.getCell(0, 0).getCellFormat());
int r=dataSheet.getRows();
int y = 0;
for (int i = 0; i < q; i++) {
for (int j = r+1; j < r+w+1; j++) {
dataSheet.addCell(new Label(i, j, list.get(y++),CwcfF));
}
}
wwb.write();
wb1.close();
fis.close();
wwb.close();
fis1.close();
} catch (Exception ex) {
ex.printStackTrace();
}

}
}

问题补充：这里只选择了第一个引入表的第一个单元格样式

Jxl

2012年8月14日 17:16

wu753870625
16
0 0 3

1个答案按时间排序按投票排序

0 0

你的问题又被我看到了，给你一个excel各种操作的例子吧，你运行看看效果，还有一些样式。

import java.io.File;
import java.net.URL;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import jxl.Workbook;
import jxl.write.DateTime;
import jxl.write.Formula;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.WritableCell;
import jxl.write.WritableCellFeatures;
import jxl.write.WritableHyperlink;
import jxl.write.WritableImage;

public class FormatWriteExcel
{
    private static String[] headerNames = {"String", "Number", "DateTime", "Range", "Hyperlinks", "Image"};
    
    public static void main(String[] a)
    {
        try
        {
            write("d:/a.xls");
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }
    
    public static void write(String file) throws Exception
    {
        //创建可写入的Excel工作薄对象
        jxl.write.WritableWorkbook lWriteWorkbook = null;
        try
        {
            lWriteWorkbook = Workbook.createWorkbook(new File(file));
            //读取当前工作表
            jxl.write.WritableSheet sheet = lWriteWorkbook.createSheet("数据格式", 0);
            
            for (int i = 0; i < headerNames.length; i++)
            {
                String lValue = (String) headerNames[i];
                Label lLabel = new jxl.write.Label(i, 0, lValue, ExcelStyle.getHeaderStyle());
                sheet.addCell(lLabel);
            }
            
            WritableCell cell = null;
            //文本格式
            cell = new Label(0, 1, "test1");
            sheet.addCell(cell);
            
            //数字格式
            cell = new Number(1, 1, 123.456);
            sheet.addCell(cell);
            cell = new Number(1, 2, 234.567);
            sheet.addCell(cell);
            
            //添加公式
            Formula formula = new Formula(1, 4, "SUM(B2:B3)");
            sheet.addCell(formula);
            
            //日期格式
            cell = new DateTime(2, 1, new Date());
            sheet.addCell(cell);
            
            //下拉选择格式
            Label label = new jxl.write.Label(3, 1, "是");   
            WritableCellFeatures wcf = new WritableCellFeatures();   
            List<String> angerlist = new ArrayList<String>();   
            angerlist.add("是");   
            angerlist.add("否");   
            wcf.setDataValidationList(angerlist);   
            label.setCellFeatures(wcf);   
            sheet.addCell(label);  

            //URL
            WritableHyperlink link = new WritableHyperlink(4, 1, new URL("http://www.baidu.com"));
            sheet.addHyperlink(link);
            
            //Image
            WritableImage wi = new WritableImage(5.0D, 1.0D, 2D, 9D, new File("E:/document/常用API/Java-ExcelApi/jexcelapi/resources/littlemoretonhall.png"));
            sheet.addImage(wi);
            
            //合并单元格
            cell = new Label(2, 6, "单元格合并");
            sheet.addCell(cell);
            sheet.mergeCells(2, 6, 3, 7);
            
            lWriteWorkbook.write();
            lWriteWorkbook.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }
}

import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.Colour;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WriteException;

public class ExcelStyle
{
    private static WritableCellFormat HeaderFormat;
    
    static
    {
        WritableFont lHeaderWritableFont = new WritableFont(WritableFont.ARIAL, 12);
        //列头样式
        HeaderFormat = new WritableCellFormat(lHeaderWritableFont);

        try
        {
            HeaderFormat.setAlignment(jxl.format.Alignment.CENTRE);
            HeaderFormat.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);
            HeaderFormat.setBackground(Colour.ICE_BLUE);
            HeaderFormat.setBorder(Border.ALL, BorderLineStyle.MEDIUM);
        }
        catch(WriteException e)
        {
            e.printStackTrace();
        }
    }
    
    public static WritableCellFormat getHeaderStyle()
    {
        return HeaderFormat;
    }
}

实际上，你的问题实现起来，就存在一个前提，两个表格的是否模板相同。
比如说，第一个表格第一行1至4列是合并单元格，而第二个表格第一列的1至4行是合并单元格，那么你这个样式如何设置呢？
如果表格的模板相同，那么只需要通过getCellFormat方法获取样式再循环复制到另一个表格中即可。

2012年8月14日 19:26