test.java

图表生成程序组件 Chart_Excel: 该文件夹中存放着两套组件：用于生成图表的Chart组件

package JRsoft;

import java.io.*;
import jxl.*;
import jxl.write.*;
import jxl.format.*;
import java.util.*;
import java.awt.Color;

public class Test
{
	public static void writeExcel(OutputStream os) throws Exception 
	{
		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, "我爱中国");
		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);
		
		//写入Exel工作表
		wwb.write();
		//关闭Excel工作薄对象
		wwb.close();
	}

	//最好写一个这样的main方法来测试一下你的这个class是否写好了。
	//public static void main(String[] args)throws Exception
	public static void writeNow()throws Exception
	{
		FileOutputStream fos = null; 
		try
		{ 
			fos  =  new  FileOutputStream("D:\\Temp.xls"); 
			writeExcel(fos);
		}
		finally
		{ 
			try
			{ 
				fos.close(); 
			}
			catch(Exception e)
			{} 
		} 
	}

	public static String[][] readExcel(String fileNameTemp)
	{
		String[][] strTemp = null;
		InputStream is = null; 
		try
		{
			is = new FileInputStream(fileNameTemp); 
			jxl.Workbook rwb = Workbook.getWorkbook(is); 
			Sheet rs = rwb.getSheet(0); 
			int rows=rs.getRows();
			int cols=rs.getColumns();
			//System.out.println(rows+"  "+cols);
			strTemp = new String[rows][cols];
			for(int i=0;i<rows;i++)
			{
				for(int j=0;j<cols;j++)
				{
					Cell ctemp = rs.getCell(j,i); 
					strTemp[i][j] = ctemp.getContents(); 
				}
			}
			rwb.close(); 
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
		finally
		{ 
			try
			{ 
				is.close(); 
			}
			catch(Exception e)
			{} 
		} 
		return strTemp;
	}

	public static String toCN(String strvalue)
	{
		try
		{
			if(strvalue==null)
				return null;
			else
			{
				strvalue = new String(strvalue.getBytes("gb2312"), "GBK");
				return strvalue;
			}
		}
		catch(Exception e)
		{
			return null;
		}
	}

	public static String DBtoCN(String strvalue)
	{
		try
		{
			if(strvalue==null)
				return null;
			else
			{
			strvalue = new String(strvalue.getBytes("ISO-8859-1"),"gb2312");
			return strvalue;
			}
		}
		catch(Exception e)
		{
			return null;
		}
	}

}