Package hec.dataTable

Class HecDataTableToExcel

java.lang.Object

hec.dataTable.HecDataTableToExcel

public class HecDataTableToExcel
extends Object

Contains methods to Export data to Excel Used in DssVue to export TimeSeriesContainer, PairedData, etc, to an Excel workbook.

Constructor Summary

Constructors

Constructor	Description
HecDataTableToExcel()	Constructor for the Table object

Method Summary

Modifier and Type	Method	Description
void	createExcelFile(List[] dataSets, String excelFilename)
void	createExcelFile(Vector dataSets, String excelFilename)
protected void	createSheets(org.apache.poi.ss.usermodel.Workbook writableWorkbook, Vector jTables)
protected void	createTables(List dataSets)
org.apache.poi.ss.usermodel.Workbook	createXlsFile(String xlsFilename)
org.apache.poi.ss.usermodel.Workbook	createXlsxFile(String xlsxFilename)
Vector	getEditedContainers()
static HecDataTableToExcel	newTable()
Vector	orderPairedDataContainers(List dataSets)
protected boolean	readEditedSheets()
void	runExcel(List[] dataSets)
void	runExcel(List[] dataSets, String excelFilename)
void	runExcel(Vector dataSets)
void	runExcel(Vector dataSets, String excelFilename)
protected void	writeWookbook(org.apache.poi.ss.usermodel.Workbook writableWorkbook)

Methods inherited from class java.lang.Object

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

Constructor Details

HecDataTableToExcel

public HecDataTableToExcel()

Constructor for the Table object

Method Details

newTable

public static HecDataTableToExcel newTable()

createXlsFile

public org.apache.poi.ss.usermodel.Workbook createXlsFile(String xlsFilename)
                                                   throws Exception

Throws:

Exception

createXlsxFile

public org.apache.poi.ss.usermodel.Workbook createXlsxFile(String xlsxFilename)
                                                    throws Exception

Throws:

Exception

readEditedSheets

protected boolean readEditedSheets()
                            throws Exception

Throws:

Exception

createSheets

protected void createSheets(org.apache.poi.ss.usermodel.Workbook writableWorkbook,
 Vector jTables)
                     throws Exception

Throws:

Exception

writeWookbook

protected void writeWookbook(org.apache.poi.ss.usermodel.Workbook writableWorkbook)
                      throws Exception

Throws:

Exception

createTables

protected void createTables(List dataSets)
                     throws Exception

Throws:

Exception

orderPairedDataContainers

public Vector orderPairedDataContainers(List dataSets)

getEditedContainers

public Vector getEditedContainers()
                           throws Exception

Throws:

Exception

createExcelFile

public void createExcelFile(Vector dataSets,
 String excelFilename)
                     throws Exception

Throws:

Exception

createExcelFile

public void createExcelFile(List[] dataSets,
 String excelFilename)
                     throws Exception

Throws:

Exception

runExcel

public void runExcel(Vector dataSets)
              throws Exception

Throws:

Exception

runExcel

public void runExcel(List[] dataSets)
              throws Exception

Throws:

Exception

runExcel

public void runExcel(Vector dataSets,
 String excelFilename)
              throws Exception

Throws:

Exception

runExcel

public void runExcel(List[] dataSets,
 String excelFilename)
              throws Exception

Throws:

Exception