public HSSFCreationHelper(HSSFWorkbook wb)
{
workbook = wb;
// Create the things we only ever need one of
dataFormat = new HSSFDataFormat(workbook.Workbook);
}
/// <summary>
/// Creates the instance of HSSFDataFormat for this workbook.
/// </summary>
/// <returns>the HSSFDataFormat object</returns>
public Zephyr.Utils.NPOI.SS.UserModel.IDataFormat CreateDataFormat()
{
if (formatter == null)
formatter = new HSSFDataFormat(workbook);
return formatter;
}
/// <summary>
/// Get the contents of the format string, by looking up
/// the DataFormat against the supplied workbook
/// </summary>
/// <param name="workbook">The workbook.</param>
/// <returns></returns>
public String GetDataFormatString(Zephyr.Utils.NPOI.HSSF.Model.InternalWorkbook workbook)
{
HSSFDataFormat format = new HSSFDataFormat(workbook);
return format.GetFormat(DataFormat);
}
/// <summary>
/// Get the contents of the format string, by looking up
/// the DataFormat against the bound workbook
/// </summary>
/// <returns></returns>
public String GetDataFormatString()
{
HSSFDataFormat format = new HSSFDataFormat(workbook);
return format.GetFormat(DataFormat);
}
/// <summary>
/// Get the contents of the format string, by looking up
/// the DataFormat against the supplied workbook
/// </summary>
/// <param name="workbook">The workbook.</param>
/// <returns></returns>
public String GetDataFormatString(Zephyr.Utils.NPOI.HSSF.Model.InternalWorkbook workbook)
{
HSSFDataFormat format = new HSSFDataFormat(workbook);
return(format.GetFormat(DataFormat));
}
/// <summary>
/// Get the contents of the format string, by looking up
/// the DataFormat against the bound workbook
/// </summary>
/// <returns></returns>
public String GetDataFormatString()
{
HSSFDataFormat format = new HSSFDataFormat(workbook);
return(format.GetFormat(DataFormat));
}
