btac.sa.lib

Class excelCustomReportGeneration

java.lang.Object

btac.sa.lib.excelCustomReportGeneration

public class excelCustomReportGeneration
extends Object

Constructor Summary

Constructors

Constructor and Description
excelCustomReportGeneration()

Method Summary

Modifier and Type	Method and Description
static void	closeFile()
static void	connectExcel(String addUniqueNameToFile, String reportSampleFileTemplatePath, String reportSampleFileTemplateName)
static String	fileNameForReport(String addUniqueNameToFile, String reportSampleFileTemplatePath, String reportSampleFileTemplateName)
static void	setValueIntoCell(String strSheetName, int iColumnNumber, int iRowNumber, int intData)
static void	setValueIntoCell(String strSheetName, int iColumnNumber, int iRowNumber, String strData)

Methods inherited from class java.lang.Object

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

Constructor Detail

excelCustomReportGeneration

public excelCustomReportGeneration()

Method Detail

fileNameForReport

public static String fileNameForReport(String addUniqueNameToFile,
                                       String reportSampleFileTemplatePath,
                                       String reportSampleFileTemplateName)
                                throws Exception

Throws:

Exception

connectExcel

public static void connectExcel(String addUniqueNameToFile,
                                String reportSampleFileTemplatePath,
                                String reportSampleFileTemplateName)
                         throws Exception

Throws:

Exception

setValueIntoCell

public static void setValueIntoCell(String strSheetName,
                                    int iColumnNumber,
                                    int iRowNumber,
                                    String strData)
                             throws jxl.write.WriteException,
                                    Exception

Throws:

jxl.write.WriteException

Exception

setValueIntoCell

public static void setValueIntoCell(String strSheetName,
                                    int iColumnNumber,
                                    int iRowNumber,
                                    int intData)
                             throws jxl.write.WriteException,
                                    Exception

Throws:

jxl.write.WriteException

Exception

closeFile

public static void closeFile()
                      throws Exception

Throws:

Exception