/* ====================================================================
|
Licensed to the Apache Software Foundation (ASF) under one or more
|
contributor license agreements. See the NOTICE file distributed with
|
this work for additional information regarding copyright ownership.
|
The ASF licenses this file to You under the Apache License, Version 2.0
|
(the "License"); you may not use this file except in compliance with
|
the License. You may obtain a copy of the License at
|
|
http://www.apache.org/licenses/LICENSE-2.0
|
|
Unless required by applicable law or agreed to in writing, software
|
distributed under the License is distributed on an "AS IS" BASIS,
|
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
See the License for the specific language governing permissions and
|
limitations under the License.
|
==================================================================== */
|
using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using HH.WMS.Utils.NPOI.SS.UserModel;
|
|
namespace HH.WMS.Utils.NPOI.SS.Util
|
{
|
|
/**
|
* Class that provides useful sheet build capabilities. It can be used
|
* in test cases to improve readability or in Swing applications with
|
* tables.
|
*
|
* @author Roman Kashitsyn
|
*/
|
public class SheetBuilder
|
{
|
|
private IWorkbook workbook;
|
private Object[][] cells;
|
private bool shouldCreateEmptyCells = false;
|
|
public SheetBuilder(IWorkbook workbook, Object[][] cells)
|
{
|
this.workbook = workbook;
|
this.cells = cells;
|
}
|
|
/**
|
* @return true if null objects should be trated as empty cells
|
* false otherwise
|
*/
|
public bool GetCreateEmptyCells()
|
{
|
return shouldCreateEmptyCells;
|
}
|
|
/**
|
* @param shouldCreateEmptyCells true if null array elements should be
|
* trated as empty cells
|
* @return this
|
*/
|
public SheetBuilder SetCreateEmptyCells(bool shouldCreateEmptyCells)
|
{
|
this.shouldCreateEmptyCells = shouldCreateEmptyCells;
|
return this;
|
}
|
|
/**
|
* Builds sheet from parent workbook and 2D array with cell
|
* values. Creates rows anyway (even if row contains only null
|
* cells), creates cells only if corresponding property is true.
|
* The conversion is performed in the following way:
|
*
|
* <ul>
|
* <li>Numbers become numeric cells.</li>
|
* <li><code>java.util.Date</code> or <code>java.util.Calendar</code>
|
* instances become date cells.</li>
|
* <li>String with leading '=' char become formulas (leading '='
|
* trancated).</li>
|
* <li>Other objects become strings via <code>Object.toString()</code>
|
* method.</li>
|
* </ul>
|
*
|
* @return newly created sheet
|
*/
|
public ISheet Build()
|
{
|
ISheet sheet = workbook.CreateSheet();
|
IRow currentRow = null;
|
ICell currentCell = null;
|
|
for (int rowIndex = 0; rowIndex < cells.Length; ++rowIndex)
|
{
|
Object[] rowArray = cells[rowIndex];
|
currentRow = sheet.CreateRow(rowIndex);
|
|
for (int cellIndex = 0; cellIndex < rowArray.Length; ++cellIndex)
|
{
|
Object cellValue = rowArray[cellIndex];
|
if (cellValue != null || shouldCreateEmptyCells)
|
{
|
currentCell = currentRow.CreateCell(cellIndex);
|
SetCellValue(currentCell, cellValue);
|
}
|
}
|
}
|
return sheet;
|
}
|
|
/**
|
* Sets the cell value using object type information.
|
* @param cell cell to change
|
* @param value value to set
|
*/
|
public void SetCellValue(ICell cell, Object value)
|
{
|
double doubleValue = 0;
|
if (value == null || cell == null)
|
{
|
return;
|
}
|
//else if (value is Number)
|
if (double.TryParse(value.ToString(), out doubleValue))
|
{
|
//double doubleValue = ((Number)value).doubleValue();
|
cell.SetCellValue(doubleValue);
|
}
|
else if (value is DateTime)
|
{
|
cell.SetCellValue((DateTime)value);
|
//} else if (value is Calendar) {
|
// cell.SetCellValue((Calendar) value);
|
}
|
else if (IsFormulaDefinition(value))
|
{
|
cell.CellFormula = (GetFormula(value));
|
}
|
else
|
{
|
cell.SetCellValue(value.ToString());
|
}
|
}
|
|
private bool IsFormulaDefinition(Object obj)
|
{
|
if (obj is String)
|
{
|
String str = (String)obj;
|
if (str.Length < 2)
|
{
|
return false;
|
}
|
else
|
{
|
return ((String)obj)[0] == '=';
|
}
|
}
|
else
|
{
|
return false;
|
}
|
}
|
|
private String GetFormula(Object obj)
|
{
|
return ((String)obj).Substring(1);
|
}
|
}
|
}
|
