java

Question

可不可以存为CSV格式的文件，再导入Excel？

Answer 1

http://jakarta.apache.org/poi/
去下载个包，里边的api可以操作excel

Answer 2

import jxl.*;
import jxl.write.*;
import java.io.*;public class Test{    public static void main(String[] args) throws Exception    {
       
        FileOutputStream fileOut3 = new FileOutputStream("workbook_test.xls");
        jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(fileOut3);
        WritableSheet sheet = wwb.createSheet("Test", 0);
        int rows=100,cols=10;
        for (int rowIndex = 0; rowIndex < rows; rowIndex++) {             for (int colIndex = 0; colIndex < cols; colIndex++) {
                jxl.write.Number number = new jxl.write.Number(colIndex,rowIndex, 10);
                sheet.addCell(number);
            }
        }
        wwb.write();
        wwb.close();    }

Answer 3

excel是可以開啟visual foxpro的dbf文件的,
利用jdbc操縱dbf文件,然後用excel打開dbf數據庫文件,是這樣的嗎

Answer 4

我赞成 icy_csdn() 的！（我个人观点）
你可以试试

Answer 5

你可以用JAVA EXCEL API包，它是开原得，你可以修改它的代码！！这个挺好使，我以前用过！！import java.io.*;
import jxl.*;
import jxl.write.*;public class ExcelExport
{
    public ExcelExport()
    {
    }    private final static String targetfile = "test.xls";
    public void test()
    {
        try
        {
            jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File(targetfile));
            jxl.write.WritableSheet ws = wwb.createSheet("Test Sheet 1", 0);            WritableCellFormat wcf = new WritableCellFormat();
            wcf.setVerticalAlignment(VerticalAlignment.CENTRE);            jxl.write.Label labelC = new jxl.write.Label(0, 1, "&#65420;&#65431;&#65394;&#65421;&#65407;&#65384;", wcf);
            ws.addCell(labelC);
            ws.mergeCells(0, 1, 0, 3);
            labelC = new jxl.write.Label(1, 0, "1&#65428;&#65410;", wcf);
            ws.addCell(labelC);
            ws.mergeCells(1, 0, 4, 0);
            labelC = new jxl.write.Label(5, 0, "2&#65428;&#65410;", wcf);
            ws.addCell(labelC);
            ws.mergeCells(5, 0, 8, 0);
            labelC = new jxl.write.Label(1, 1, "&#65427;&#65411;&#65403;&#65383;&#65418;&#63729;", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(2, 1, "&#65403;&#65392;&#65422;&#65407;", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(3, 1, "&#65415;&#65399;&#65399;&#65425;&#65410;&#65418;", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(4, 1, "&#65408;&#12539;&#65418;", wcf);
            ws.addCell(labelC);            labelC = new jxl.write.Label(1, 2, "22", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(2, 2, "20", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(3, 2, "10%", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(4, 2, "12%", wcf);
            ws.addCell(labelC);            labelC = new jxl.write.Label(1, 3, "12", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(2, 3, "-", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(3, 3, "-", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(4, 3, "9%", wcf);
            ws.addCell(labelC);            labelC = new jxl.write.Label(5, 1, "&#65427;&#65411;&#65403;&#65383;&#65418;&#63729;", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(6, 1, "&#65403;&#65392;&#65422;&#65407;", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(7, 1, "&#65415;&#65399;&#65399;&#65425;&#65410;&#65418;", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(8, 1, "&#65408;&#12539;&#65418;", wcf);
            ws.addCell(labelC);            labelC = new jxl.write.Label(5, 2, "51", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(6, 2, "40", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(7, 2, "10%", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(8, 2, "4%", wcf);
            ws.addCell(labelC);            labelC = new jxl.write.Label(5, 3, "0", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(6, 3, "0", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(7, 3, "10%", wcf);
            ws.addCell(labelC);
            labelC = new jxl.write.Label(8, 3, "2%", wcf);
            ws.addCell(labelC);            wwb.write();
            wwb.close();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
}