com.scudata.excel.SheetInfoHandler Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of esproc Show documentation

SPL(Structured Process Language) A programming language specially for structured data computing.

There is a newer version: 20241126

package com.scudata.excel;

import org.xml.sax.Attributes;
import org.xml.sax.SAXException;
import org.xml.sax.helpers.DefaultHandler;

import com.scudata.common.Logger;
import com.scudata.common.StringUtils;

/**
 * Used to read sheet informations from xlsx format files
 */
class SheetInfoHandler extends DefaultHandler {

	/**
	 * SheetInfo object
	 */
	private SheetInfo sheetInfo;

	/**
	 * Constructor
	 * 
	 * @param si
	 *            SheetInfo
	 */
	SheetInfoHandler(SheetInfo si) {
		sheetInfo = si;
		sheetInfo.setRowCount(0);
		sheetInfo.setColCount(0);
	}

	/**
	 * Processing element start
	 */
	public void startElement(String uri, String localName, String name,
			Attributes attributes) throws SAXException {
		if (name.equals("dimension")) {
			String ref = attributes.getValue("ref");
			if (StringUtils.isValidString(ref)) {
				int sepIndex = ref.indexOf(":");
				int rowCount = 0, colCount = 0;
				if (sepIndex > -1) {
					String v = ref.substring(sepIndex + 1, ref.length());
					String s = v.replaceAll("[\\d]", "");
					colCount = ExcelUtils.nameToColumn(s) + 1;
					rowCount = ExcelUtils.getLabelNumber(v);
					sheetInfo.setRowCount(rowCount);
					sheetInfo.setColCount(colCount);
				} else {
					Logger.debug("Invalid sheet dimension of "
							+ sheetInfo.getSheetName() + ": " + ref);
				}
			} else {
				Logger.debug("The sheet dimension of "
						+ sheetInfo.getSheetName() + " is empty");
			}
			throw new BreakException();
		}
	}

	/**
	 * Processing element end
	 */
	public void endElement(String uri, String localName, String name)
			throws SAXException {
	}

	/**
	 * Handling characters between elements
	 */
	public void characters(char[] ch, int start, int length)
			throws SAXException {
	}

}