91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 643KB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2021-05-18
  • 語言: Java
  • 標簽: jxl??代碼??讀取word??

資源簡介

Java生成excel jxl 代碼Java生成excel jxl 代碼

資源截圖

代碼片段和文件信息

package?helloWord;

import?java.io.*;
import?java.util.*;

import?jxl.Workbook;
import?jxl.write.Label;
import?jxl.write.WritableSheet;
import?jxl.write.WritableWorkbook;
import?jxl.write.WriteException;
import?jxl.write.biff.RowsExceededException;

import?org.apache.poi.poifs.filesystem.DirectoryEntry;
import?org.apache.poi.poifs.filesystem.POIFSFileSystem;
import?org.textmining.text.extraction.WordExtractor;

?

public?class?Test?{

/**
?*?@param?args
?*?@throws?IOException?
?*/

public?void?show()?throws?Exception
{
FileInputStream?fs??=?new?FileInputStream(“c:\\freemarker.doc“);

WordExtractor?we=?new?WordExtractor();

String?str=?we.extractText(fs);

System.out.println(str);
}

public?void?writeWord()?throws?IOException
{
String?str=?“asdasdasd“;

byte[]?buff=?str.getBytes();

ByteArrayInputStream?b?=?new?ByteArrayInputStream(buff);

POIFSFileSystem?fs?=?new?POIFSFileSystem();

DirectoryEntry?de=?fs.getRoot();

FileOutputStream?os?=new?FileOutputStream(“c:\\zcq.doc“);

fs.writeFilesystem(os);

b.close();

os.close();

}

public?void?excel()
{
WritableWorkbook?wwb?=?null;????
????????try?{????
????????????//首先要使用Workbook類的工廠方法創建一個可寫入的工作薄(Workbook)對象????
????????????wwb?=?Workbook.createWorkbook(new?File(“zcq.xls“));????
????????}?catch?(IOException?e)?{????
????????????e.printStackTrace();????
????????}????
????????if(wwb!=null){????
????????????//創建一個可寫入的工作表????
????????????//Workbook的createSheet方法有兩個參數,第一個是工作表的名稱,第二個是工作表在工作薄中的位置????
????????????WritableSheet?ws?=?wwb.createSheet(“sheet1“?0);????
????????????????
????????????//下面開始添加單元格????
????????????for(int?i=0;i<10;i++){????
????????????????for(int?j=0;j<5;j++){????
????????????????????//這里需要注意的是,在Excel中,第一個參數表示列,第二個表示行????
????????????????????Label?labelC?=?new?Label(j?i?“這是第“+(i+1)+“行,第“+(j+1)+“列“);????
????????????????????Label?labelC2?=?new?Label(j?i?“這是第“+(i+1)+“行,第“+(j+1)+“列“);????
????????????????????try?{????
????????????????????????//將生成的單元格添加到工作表中????
????????????????????????ws.addCell(labelC);?
????????????????????????ws.addCell(labelC2);
????????????????????}?catch?(RowsExceededException?e)?{????
????????????????????????e.printStackTrace();????
????????????????????}?catch?(WriteException?e)?{????
????????????????????????e.printStackTrace();????
????????????????????}????
???
????????????????}????
????????????}????
???
????????????try?{????
????????????????//從內存中寫入文件中????
????????????????wwb.write();????
????????????????//關閉資源,釋放內存????
????????????????wwb.close();????
????????????}?catch?(IOException?e)?{????
????????????????e.printStackTrace();????
????????????}?catch?(WriteException?e)?{????
????????????????e.printStackTrace();????
????????????}????
????????}????

}

public?static?void?main(String[]?args)?throws?Exception?{

Test?t=?new?Test();

t.excel();

}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????725247??2008-11-25?01:40??jxl.jar

?????文件???????3134??2009-03-02?16:52??Test.java

-----------?---------??----------?-----??----

???????????????728381????????????????????2


評論

共有 條評論