org.camunda.bpm.dmn.xlsx.XlsxWorksheetContext Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of dmn-xlsx-converter Show documentation

There is a newer version: 0.4.0

/* Licensed 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.
 */
package org.camunda.bpm.dmn.xlsx;

import java.util.ArrayList;
import java.util.List;

import org.camunda.bpm.dmn.xlsx.elements.IndexedRow;
import org.xlsx4j.sml.CTRst;
import org.xlsx4j.sml.CTSst;
import org.xlsx4j.sml.Cell;
import org.xlsx4j.sml.Row;
import org.xlsx4j.sml.STCellType;
import org.xlsx4j.sml.Worksheet;

/**
 * @author Thorben Lindhauer
 *
 */
public class XlsxWorksheetContext {

  protected List cellContentHandlers;
  protected CTSst sharedStrings;
  protected Worksheet worksheet;
  protected String worksheetName;

  // cached state
  protected List indexedRows;

  public XlsxWorksheetContext(CTSst sharedStrings, Worksheet worksheet, String worksheetName) {
    this.sharedStrings = sharedStrings;
    this.worksheet = worksheet;
    this.cellContentHandlers = new ArrayList();
    this.worksheetName = worksheetName;
  }

  public List getRows() {
    if (indexedRows == null) {
      indexedRows = new ArrayList();
      for (Row row : worksheet.getSheetData().getRow()) {
        indexedRows.add(new IndexedRow(row));
      }
    }
    return indexedRows;
  }

  public String resolveSharedString(int index) {
    List siElements = sharedStrings.getSi();
    return siElements.get(index).getT().getValue();
  }

  public String resolveCellValue(Cell cell) {
    STCellType cellType = cell.getT();
    if (STCellType.S.equals(cellType)) {
      int sharedStringIndex = Integer.parseInt(cell.getV());
      return resolveSharedString(sharedStringIndex);
    }
    else {
      return cell.getV();
    }
  }

  public String getWorksheetName() {
    return worksheetName;
  }

}