public static void writeExcel(OutputStream os) throws Exception {
try{
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
jxl.write.WritableSheet ws = wwb.createSheet("testSheet1", 0);
jxl.write.Label labelC = new jxl.write.Label(0, 0, "我爱中国1");
ws.addCell(labelC);
jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.
ARIAL,
20, WritableFont.BOLD, false,
UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.GREEN);
jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);
wcfFC.setBackground(jxl.format.Colour.RED);
labelC = new jxl.write.Label(6, 0, "中国爱我", wcfFC);
ws.addCell(labelC);
wwb.write();
wwb.close();
}
catch(Exception e){
System.out.println(e.toString()); }
} public static void main(String[] args) {
try{
File f = new File("kk.xls");
f.createNewFile();
writeExcel(new FileOutputStream(f));
}
catch(Exception e){
System.out.println(e.toString());
}
}
try{
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
jxl.write.WritableSheet ws = wwb.createSheet("testSheet1", 0);
jxl.write.Label labelC = new jxl.write.Label(0, 0, "我爱中国1");
ws.addCell(labelC);
jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.
ARIAL,
20, WritableFont.BOLD, false,
UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.GREEN);
jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);
wcfFC.setBackground(jxl.format.Colour.RED);
labelC = new jxl.write.Label(6, 0, "中国爱我", wcfFC);
ws.addCell(labelC);
wwb.write();
wwb.close();
}
catch(Exception e){
System.out.println(e.toString()); }
} public static void main(String[] args) {
try{
File f = new File("kk.xls");
f.createNewFile();
writeExcel(new FileOutputStream(f));
}
catch(Exception e){
System.out.println(e.toString());
}
}
解决方案 »
- Java Email [EOF] exception
- java中如何计算string的byte长度?
- 为什么是空值?
- 求教!关于集合类的疑问2则
- 求助!java下运行多行dos命令不成功。有原程序。
- 老大,谁有用JAVA编写的记事本呀?
- 打听一下,一班面试java程序员会让你上机操作?
- 有这样一串字符,如何放到arraylist里?
- jsp测试连接Oracle时的问题.
- 请问:.java的文件必须要保存在安装目录下吗?
- 两个自编public CLASS 放在同一个目录下 如c:\test,为什么不能在一个CLASS中NEW另一个CLASS?
- 现金1000元!!征求护士工作安排表java解决方案,注意。是现金哦,在线等待
import java.io.*;
import jxl.*;
import jxl.write.*; public class CreateXLS
{
public static void main(String args[])
{
try
{
//打开文件
WritableWorkbook book=
Workbook.createWorkbook(new File(“测试.xls”)); //生成名为“第一页”的工作表,参数0表示这是第一页
WritableSheet sheet=book.createSheet(“第一页”,0); //在Label对象的构造子中指名单元格位置是第一列第一行(0,0)
//以及单元格内容为test
Label label=new Label(0,0,”test”); //将定义好的单元格添加到工作表中
sheet.addCell(label); /*生成一个保存数字的单元格
必须使用Number的完整包路径,否则有语法歧义
单元格位置是第二列,第一行,值为789.123*/
jxl.write.Number number = new jxl.write.Number(1,0,789.123);
sheet.addCell(number); //写入数据并关闭文件
book.write();
book.close(); }catch(Exception e)
{
System.out.println(e);
}
}
java解析XML的包有jdom,jaxp等。你可以上sun的网站查找jaxp,这个应该是最新的xml解析工具。
首先自己封装一个JDOM的类,如取名UniXML.
import java.io.*;
import java.util.*;import org.jdom.*;
import org.jdom.input.*;
import org.jdom.output.*;import javax.xml.transform.*;
import javax.xml.transform.stream.StreamResult;
import javax.xml.transform.stream.StreamSource;public class UniXML
{
private static String strRootTag = "xml";
public Document unidoc = null;
public Element rootElement = null; public String Query(String strTags) {
Element tmpElement = GetElementByTags(strTags);
return tmpElement.getTextTrim();
} public Element GetElementByTags(String strTags) {
Element rootElem = unidoc.getRootElement();
int i = 0;
Element elemEnd = null;
StringTokenizer TokTags = new StringTokenizer(strTags, "/");
while (TokTags.hasMoreTokens()) {
i++;
String strTok = TokTags.nextElement().toString();
if (i == 1)
elemEnd = rootElem.getChild(strTok);
else
elemEnd = elemEnd.getChild(strTok);
} return elemEnd;
}
......
}然后再定义如下:
UniXML unixml= new UniXML("你的XML字串")
String act = unixml.Query("map/act");
String cmd = unixml.Query("map/cmd");
......