com.eviware.soapui.impl.wsdl.teststeps.datasource

Class ExcelFacade

java.lang.Object

com.eviware.soapui.impl.wsdl.teststeps.datasource.ExcelFacade

public class ExcelFacade
extends Object

A facade to the Excel file manipulation functionality in Apache POI.

Field Summary

Fields

Modifier and Type	Field and Description
static int	BUFFER_SIZE
static int	ROW_CACHE_SIZE

Constructor Summary

Constructors

Constructor and Description
ExcelFacade()

Method Summary

Modifier and Type	Method and Description
static com.monitorjbl.xlsx.StreamingReader	getStreamingReader(File file, int sheetIndex)
static com.monitorjbl.xlsx.StreamingReader	getStreamingReader(File file, String sheetName)
static org.apache.poi.ss.usermodel.Workbook	makeEmptyWorkbookFor(String outFile)
static org.apache.poi.ss.usermodel.Workbook	readWorkbookFrom(File filePath)
static void	writeWorkbookToFile(org.apache.poi.ss.usermodel.Workbook workbook, File file)

Methods inherited from class java.lang.Object

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

Field Detail

ROW_CACHE_SIZE

public static int ROW_CACHE_SIZE

BUFFER_SIZE

public static int BUFFER_SIZE

Constructor Detail

ExcelFacade

public ExcelFacade()

Method Detail

readWorkbookFrom

public static org.apache.poi.ss.usermodel.Workbook readWorkbookFrom(File filePath)
                                                             throws IOException

Throws:

IOException

getStreamingReader

public static com.monitorjbl.xlsx.StreamingReader getStreamingReader(File file,
                                                                     int sheetIndex)
                                                              throws IOException

Throws:

IOException

getStreamingReader

public static com.monitorjbl.xlsx.StreamingReader getStreamingReader(File file,
                                                                     String sheetName)
                                                              throws IOException

Throws:

IOException

makeEmptyWorkbookFor

public static org.apache.poi.ss.usermodel.Workbook makeEmptyWorkbookFor(String outFile)

writeWorkbookToFile

public static void writeWorkbookToFile(org.apache.poi.ss.usermodel.Workbook workbook,
                                       File file)
                                throws IOException

Throws:

IOException