package jp.profaim.vendorutil.msexcel.windows.maper;

import java.io.File;

import jp.profaim.vendorutil.msexcel.windows.mapper.ExcelApplication;
import jp.profaim.vendorutil.msexcel.windows.mapper.ExcelCell;
import jp.profaim.vendorutil.msexcel.windows.mapper.ExcelWorkBook;
import jp.profaim.vendorutil.msexcel.windows.mapper.ExcelWorkSheet;
import jp.profaim.vendorutil.msexcel.windows.mapper.exception.WorkBookNotFoundException;
import jp.profaim.vendorutil.msexcel.windows.mapper.exception.WorkSheetNotFoundException;
import junit.framework.TestCase;

public class ExcelApplicationRelease1Test extends TestCase {

	public void testStdUse()
	{
		
		ExcelApplication ea = null;
		ExcelWorkBook wb = null;
		ExcelWorkSheet ws = null;
		try
		{
			
			File excelBook = new File("resource", "テスト用.xls");
			
			ea = new ExcelApplication();
			wb = ea.openWorkBook(excelBook);
			ws = wb.getWorkSheet("テストシート");
			int rowCnt = ws.getRowCount();
			System.out.println("使用済み行数 = "+rowCnt);
			int colCnt = ws.getColumnCount();
			System.out.println("使用済み列数 = "+colCnt);
			
			int r = 0;
			int c = 0;
			ExcelCell currCell = null;
			for(r=0;r<rowCnt;r++)
			{
				for(c=0;c<colCnt;c++)
				{
					System.out.println("(x,y)=("+r+","+c+")");
					currCell = ws.getCell(r, c);
					System.out.println("Value="+currCell.getValue());
				}
			}
			
		}
		finally
		{
			if(wb != null)
			{
				wb.close();
			}
		}
	}
	
	/**
	 * 存在しないワークブックを指定
	 * 定義: 2006/11/04
	 * @author profaim
	 */
	public void testWorkBookNotFOund()
	{
		ExcelApplication ea = null;
		ExcelWorkBook wb = null;
		try
		{
			
			File excelBook = new File("resource", "存在しないワークブック.xls");
			
			ea = new ExcelApplication();
			wb = ea.openWorkBook(excelBook);
			
		}catch(WorkBookNotFoundException e)
		{
			return;
		}
		finally
		{
			if(wb != null)
			{
				wb.close();
			}
		}
		fail("存在しないワークブックを指定してで例外が発生しませんでした。");
	}
	
	/**
	 * ワークシートが存在しない場合にWorkSheetNotFoundExceptionが発生する
	 * 定義: 2006/11/04 14:26:53
	 * @author profaim
	 */
	public void testWorkSheetNotFOund()
	{
		ExcelApplication ea = null;
		ExcelWorkBook wb = null;
		ExcelWorkSheet ws = null;
		try
		{
			
			File excelBook = new File("resource", "テスト用.xls");
			
			ea = new ExcelApplication();
			wb = ea.openWorkBook(excelBook);
			ws = wb.getWorkSheet("存在しないワークシート");
			
		}catch(WorkSheetNotFoundException e)
		{
			return;
		}
		finally
		{
			if(wb != null)
			{
				wb.close();
			}
		}
		fail("存在しないワークシートの取得で例外が発生しませんでした。");
	}
	
	public void testReadSihtWritedBook()
	{
		
		ExcelApplication ea = null;
		ExcelWorkBook wb = null;
		ExcelWorkSheet ws = null;
		try
		{
			
			File excelBook = new File("resource", "有効範囲の開始がA1ではない.xls");
			
			ea = new ExcelApplication();
			wb = ea.openWorkBook(excelBook);
			ws = wb.getWorkSheet("Sheet1");
			int rowCnt = ws.getRowCount();
			System.out.println("使用済み行数 = "+rowCnt);
			int colCnt = ws.getColumnCount();
			System.out.println("使用済み列数 = "+colCnt);
			
			int r = 0;
			int c = 0;
			ExcelCell currCell = null;
			for(r=0;r<rowCnt;r++)
			{
				for(c=0;c<colCnt;c++)
				{
					System.out.println("(x,y)=("+r+","+c+")");
					currCell = ws.getCell(r, c);
					System.out.println("Value="+currCell.getValue());
				}
			}
			
		}
		finally
		{
			if(wb != null)
			{
				wb.close();
			}
		}
	}
	
}