// ----------------------------------------------------------------
/*
	excel_manipulate.groovy
					Aug/07/2013

*/
// ----------------------------------------------------------------
import java.io.File  
import java.io.IOException  
import jxl.Workbook
import jxl.Sheet
import jxl.Cell
import jxl.read.biff.BiffException

import jxl.write.Label   
import jxl.write.WriteException
import jxl.write.WritableSheet
import jxl.write.WritableWorkbook


import	java.util.HashMap 
import	java.util.Set 
// ----------------------------------------------------------------
public class excel_manipulate
{
// ----------------------------------------------------------------
static excel_read_proc (excel_file)
{
	def dict_aa = new HashMap()

	def workbook = Workbook.getWorkbook (new File(excel_file))    
  
	def sheet = workbook.getSheet(0)  
  
	for (row in 0..9)
		{
		try
			{
		def str_id = sheet.getCell (0,row).getContents ()
		def name = sheet.getCell (1,row).getContents ()
		def str_population = sheet.getCell (2,row).getContents ()
		def date_mod = sheet.getCell (3,row).getContents ()

		int	population = Integer.parseInt (str_population)

		def ff = new text_manipulate ()
		dict_aa = ff.dict_append_proc (dict_aa,str_id,name,population,date_mod)

			}
		catch (Exception ee)
			{
//			ee.printStackTrace ()
			break
			}

		}

	return	dict_aa
}

// ----------------------------------------------------------------
static void excel_create_row_proc (sheet,row,str_id,name,str_population,date_mod)
{
	Label label_aa = new Label (0,row,str_id)
	sheet.addCell (label_aa)

	Label label_bb = new Label (1,row,name)
	sheet.addCell (label_bb)

	Label label_cc = new Label (2,row,str_population)
	sheet.addCell (label_cc)

	Label label_dd = new Label (3,row,date_mod)
	sheet.addCell (label_dd)
}

// ----------------------------------------------------------------
public static void excel_write_proc (excel_file,dict_aa)
{
	def workbook = Workbook.createWorkbook (new File(excel_file))  
	def sheet = workbook.createSheet("First Sheet", 0)  

	Set set_aaa = dict_aa.keySet ()

	int row = 0
	for (Object key_aa: set_aaa)
		{
		def dict_unit = dict_aa.get (key_aa)

		String str_id = "" + key_aa
		String name = dict_unit.get ("name")
		String str_population = dict_unit.get ("population")
		String date_mod = dict_unit.get ("date_mod")
		excel_create_row_proc (sheet,row,str_id,name,str_population,date_mod)
		row++
		}

	workbook.write()
	workbook.close()
}

// ----------------------------------------------------------------
}
// ----------------------------------------------------------------