X-Git-Url: http://git.argeo.org/?p=gpl%2Fargeo-suite.git;a=blobdiff_plain;f=org.argeo.suite.workbench.rap%2Fsrc%2Forg%2Fargeo%2Fsuite%2Fworkbench%2Fcommands%2FJxlUtils.java;fp=org.argeo.suite.workbench.rap%2Fsrc%2Forg%2Fargeo%2Fsuite%2Fworkbench%2Fcommands%2FJxlUtils.java;h=8be4fa4cdfd5d4d80b63dcbb5f5944f578aed08d;hp=0000000000000000000000000000000000000000;hb=e80a8ae5c0b59bac7e83733458bf18eb097653d8;hpb=c15d3ac165d281991257defa4976bfe3f35df44b

diff --git a/org.argeo.suite.workbench.rap/src/org/argeo/suite/workbench/commands/JxlUtils.java b/org.argeo.suite.workbench.rap/src/org/argeo/suite/workbench/commands/JxlUtils.java
new file mode 100644
index 0000000..8be4fa4
--- /dev/null
+++ b/org.argeo.suite.workbench.rap/src/org/argeo/suite/workbench/commands/JxlUtils.java
@@ -0,0 +1,82 @@
+package org.argeo.suite.workbench.commands;
+
+import java.io.IOException;
+import java.io.InputStream;
+
+import org.argeo.connect.ConnectException;
+import org.argeo.eclipse.ui.EclipseUiUtils;
+
+import jxl.Cell;
+import jxl.CellType;
+import jxl.JXLException;
+import jxl.Sheet;
+import jxl.Workbook;
+import jxl.WorkbookSettings;
+
+/** Centralise useful methods to simplify development with JXL library */
+class JxlUtils {
+
+	public static boolean isEmptyCell(Sheet sheet, int x, int y) {
+		Cell cell = sheet.getCell(x, y);
+		CellType type = cell.getType();
+		return type == CellType.EMPTY;
+	}
+
+	public static String getStringValue(Sheet sheet, int x, int y) {
+		Cell cell = sheet.getCell(x, y);
+		CellType type = cell.getType();
+		String stringValue = null;
+		if (type == CellType.LABEL || type == CellType.NUMBER)
+			stringValue = cell.getContents();
+		return stringValue;
+	}
+
+	public static String getCompulsoryStringValue(Sheet sheet, int x, int y) {
+		Cell cell = sheet.getCell(x, y);
+		CellType type = cell.getType();
+		String stringValue = null;
+		if (type == CellType.LABEL)
+			stringValue = cell.getContents();
+		else if (type == CellType.NUMBER)
+			stringValue = cell.getContents();
+		if (EclipseUiUtils.isEmpty(stringValue))
+			throw new ConnectException("No name defined at [" + x + "," + y + "], cannot parse indicator file");
+		return stringValue;
+	}
+
+	public static Double getNumberValue(Sheet sheet, int x, int y) {
+		Cell cell = sheet.getCell(x, y);
+		CellType type = cell.getType();
+		if (type == CellType.NUMBER)
+			return new Double(cell.getContents());
+		else if (type == CellType.EMPTY)
+			return null;
+		else
+			throw new ConnectException("Not a number at [" + x + "," + y + "]: " + type.toString());
+	}
+
+	public static Sheet getOnlySheet(InputStream in, String encoding) throws IOException {
+		Workbook wkb = toWorkbook(in, encoding);
+		Sheet sheet = wkb.getSheet(0);
+		return sheet;
+	}
+
+	public static Sheet getSheet(InputStream in, String encoding, int index) throws IOException {
+		Workbook wkb = toWorkbook(in, encoding);
+		return wkb.getSheet(index);
+	}
+
+	public static Workbook toWorkbook(InputStream in, String encoding) throws IOException {
+		try {
+			WorkbookSettings ws = new WorkbookSettings();
+			ws.setEncoding(encoding);
+			return Workbook.getWorkbook(in, ws);
+		} catch (JXLException e) {
+			throw new ConnectException("Unable to open XLS file", e);
+		}
+	}
+
+	// Prevents instantiation
+	private JxlUtils() {
+	}
+}