package com.test;

import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

import com.meterware.httpunit.GetMethodWebRequest;
import com.meterware.httpunit.WebConversation;
import com.meterware.httpunit.WebRequest;
import com.meterware.httpunit.WebResponse;
import com.meterware.httpunit.WebTable;

public class Main {

	public static void main(String[] args) throws Exception {
		WebConversation wc = new WebConversation();
		WebRequest request = new GetMethodWebRequest(
				"http://www.javaniu.com/table.html");
		WebResponse response = wc.getResponse(request);
		WebTable table = response.getTables()[0];
		Workbook wb = new HSSFWorkbook();
		Sheet sheet = wb.createSheet("table2excel");

		int rowCount = table.getRowCount();
		int columnCount = table.getColumnCount();
		for (int i = 0; i < rowCount; i++) {
			Row row = sheet.createRow(i);
			for (int j = 0; j < columnCount; j++) {
				System.out.println(table.getCellAsText(i, j));
				row.createCell(j).setCellValue(table.getCellAsText(i, j));
			}
		}
		FileOutputStream fileOut = new FileOutputStream("c:/workbook.xls");
		wb.write(fileOut);
		fileOut.close();
	}
}