package test.msxl;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.PrintStream;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class ReadXL
{
    private String fileName ;
    private PrintStream  out ;
    
    public ReadXL(String fileName) throws Exception
    {
        this.fileName = fileName;
    }
    private void readWB() throws Exception 
    {
        String outfile = fileName+".html" ;
        this.out = new PrintStream(new FileOutputStream(outfile));
        InputStream is = new FileInputStream(this.fileName);
        HSSFWorkbook workBook = new HSSFWorkbook(is);
        int sheetCount = workBook.getNumberOfSheets() ;
        println("sheet count="+sheetCount);
        for (int i = 0; i <  sheetCount; i++)
        {
            HSSFSheet sheet = workBook.getSheetAt(i);
            println("Sheet name:"+workBook.getSheetName(i));
        }
        
    }
    private  void print(Object  str) 
    {
        this.out.print(str) ;
    }
    private void println(Object obj)
    {
        this.out.println(obj);
    }
    public static void main(String[] args)
    {
        try
        {
            ReadXL readxl = new ReadXL(args[0]);
            readxl.readWB() ;
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
}