testmisc.java

Office格式转换代码

/* ====================================================================
 * The Apache Software License, Version 1.1
 *
 * Copyright (c) 2002 The Apache Software Foundation.  All rights
 * reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions
 * are met:
 *
 * 1. Redistributions of source code must retain the above copyright
 *    notice, this list of conditions and the following disclaimer.
 *
 * 2. Redistributions in binary form must reproduce the above copyright
 *    notice, this list of conditions and the following disclaimer in
 *    the documentation and/or other materials provided with the
 *    distribution.
 *
 * 3. The end-user documentation included with the redistribution,
 *    if any, must include the following acknowledgment:
 *       "This product includes software developed by the
 *        Apache Software Foundation (http://www.apache.org/)."
 *    Alternately, this acknowledgment may appear in the software itself,
 *    if and wherever such third-party acknowledgments normally appear.
 *
 * 4. The names "Apache" and "Apache Software Foundation" and
 *    "Apache POI" must not be used to endorse or promote products
 *    derived from this software without prior written permission. For
 *    written permission, please contact [e-mail].
 *
 * 5. Products derived from this software may not be called "Apache",
 *    "Apache POI", nor may "Apache" appear in their name, without
 *    prior written permission of the Apache Software Foundation.
 *
 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
 * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
 * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
 * DISCLAIMED.  IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
 * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
 * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
 * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
 * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
 * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
 * SUCH DAMAGE.
 * ====================================================================
 *
 * This software consists of voluntary contributions made by many
 * individuals on behalf of the Apache Software Foundation.  For more
 * information on the Apache Software Foundation, please see
 * <http://www.apache.org/>.
 */

package org.apache.poi.hssf.usermodel;

import junit.framework.TestCase;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.util.Date;
import java.util.Iterator;

public class TestMisc extends TestCase {
	public TestMisc(String s) {
		super(s);
	}

	public void testDummy() {
		assertTrue("always true", true);
	}

	/*
	//Double byte strings
	public void test15556() throws java.io.IOException {
	
	    String filename = System.getProperty("HSSF.testdata.path");
	    filename=filename+"/15556.xls";
	    FileInputStream in = new FileInputStream(filename);
	    HSSFWorkbook wb = new HSSFWorkbook(in);
	    HSSFSheet sheet = wb.getSheetAt(0);
	    HSSFRow row = sheet.getRow(45);
	    this.assertTrue("Read row fine!" , true);
	
	} */

	/*    public void test16716() throws Exception{
	        FileInputStream fs = new FileInputStream("16716.xls");
	        HSSFWorkbook wb = new HSSFWorkbook(fs);
	        HSSFSheet sheet = wb.getSheetAt(0);
	        HSSFRow row = sheet.getRow(2);
	        HSSFCell cell = row.getCell((short)3);
	        if (cell == null)
	            cell = row.createCell((short)3);
	        //cell.setCellType(HSSFCell.CELL_TYPE_STRING);
	        cell.setCellValue("a test");
	        
	        // Write the output to a file
	        FileOutputStream fileOut = new FileOutputStream("n16716.xls");
	        wb.write(fileOut);
	        fileOut.close();
	    }
	    
	      public void test20881() throws Exception{
	          FileInputStream fs = new FileInputStream("20881.xls");
	          HSSFWorkbook wb = new HSSFWorkbook(fs);
	          HSSFSheet sheet = wb.getSheetAt(0);
	          //HSSFSheet sheet1 = wb.getSheetAt(1);
	          HSSFRow row = sheet.getRow(3);
	          HSSFCell cell = row.getCell((short)3);
	          if (cell == null)
	              cell = row.createCell((short) 2);
	          cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC);
	          cell.setCellValue(80);
	          
	          // Write the output to a file
	          FileOutputStream fileOut = new FileOutputStream("n20881.xls");
	          wb.write(fileOut);
	          fileOut.close();
	          
	          
	      }
	 **/

	/*    
	     public void testMonth()
	      throws java.io.IOException
	  {
	          File file = File.createTempFile("testMonthFormula",".xls");
	          FileOutputStream out    = new FileOutputStream(file);
	          HSSFWorkbook     wb     = new HSSFWorkbook();
	          HSSFSheet        s      = wb.createSheet("A");
	          HSSFRow          r      = null;
	          HSSFCell         c      = null;
	          r = s.createRow((short)0);
	          c = r.createCell((short)0);c.setCellFormula("TODAY()");
	          c = r.createCell((short)1);c.setCellFormula("DATE(YEAR(A1),MONTH(A1),DAY(A1))");          
	          wb.write(out);
	          out.close();
	          
	           assertTrue("file exists",file.exists());
	
	  }
	   */

	public void test25769() throws Exception {

		FileInputStream fileIn = new FileInputStream("25769.xls");
		//		   create a new org.apache.poi.poifs.filesystem.Filesystem

		HSSFWorkbook wb = new HSSFWorkbook(fileIn);
		HSSFSheet sheet = wb.getSheet("InputData");

		Iterator rowIterator = sheet.rowIterator();
		while (rowIterator.hasNext()) {
			HSSFRow row = (HSSFRow) rowIterator.next();
			HSSFCell cell = row.getCell((short) 0);
			if (cell == null) {
				System.out.println("---> Cell null ");
			} else {
				System.out.println(cell.getStringCellValue());
				
			}
		}
	}



	private String unicodeString(String ss) {
		char s[] = ss.toCharArray();
		java.lang.StringBuffer sb = new java.lang.StringBuffer();
		for (int x = 0; x < s.length; x++) {
			sb.append("\\u").append(Integer.toHexString(s[x]));
		}
		return sb.toString();
	}

}