public static double[,] GetDoubleMatrix(object oMatrix) { object[,] objectMatrix = CheckIfValidObjectMatrix(oMatrix); var result = new double[objectMatrix.GetLength(0), objectMatrix.GetLength(1)]; for (int rowIndex = objectMatrix.GetLowerBound(0); rowIndex <= objectMatrix.GetUpperBound(0); rowIndex++) { for (int colIndex = objectMatrix.GetLowerBound(1); colIndex <= objectMatrix.GetUpperBound(1); colIndex++) { result[rowIndex, colIndex] = ExcelDataConverters.TryGetDoubleValue(objectMatrix[rowIndex, colIndex]); } } return(result); }
public static bool OptionalBool(object oBool, bool defaultBool) { if (oBool == null) { return(defaultBool); } if (oBool is ExcelMissing) { return(defaultBool); } if (oBool is string) { string sBool = (oBool as string).ToUpper(); return(sBool == "WAHR" || sBool == "FALSE"); } double dBool = ExcelDataConverters.TryGetDoubleValue(oBool); return(dBool != 0.0); }