com.cyssxt.excel.util

Class ExcelUtil

java.lang.Object

com.cyssxt.excel.util.ExcelUtil

public class ExcelUtil
extends Object

Constructor Summary

Constructors

Constructor and Description
ExcelUtil()

Method Summary

Modifier and Type	Method and Description
static void	main(String[] args)
static ExcelDataInfo	readData(File file)
static ExcelDataInfo	readData2007(File file, String sheetName)
static ExcelDataInfo	readData2007(InputStream is, String sheetName)
static org.apache.poi.hssf.usermodel.HSSFWorkbook	write(Map<String,String> headers, List<Map> result)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ExcelUtil

public ExcelUtil()

Method Detail

readData

public static ExcelDataInfo readData(File file)
                              throws IOException

Throws:

IOException

readData2007

public static ExcelDataInfo readData2007(File file,
                                         String sheetName)
                                  throws IOException

Throws:

IOException

readData2007

public static ExcelDataInfo readData2007(InputStream is,
                                         String sheetName)
                                  throws IOException

Throws:

IOException

write

public static org.apache.poi.hssf.usermodel.HSSFWorkbook write(Map<String,String> headers,
                                                               List<Map> result)
                                                        throws IOException

Throws:

IOException

main

public static void main(String[] args)
                 throws IOException

Throws:

IOException