def test_ExcelWrapper(self): logging.debug('') logging.debug('test_ExcelWrapper') from excel_wrapper.excel_wrapper import ExcelWrapper excelFile = r"excel_wrapper_test.xlsx" xmlFile = r"excel_wrapper_test.xml" ew = ExcelWrapper(excelFile, xmlFile) ew.execute() assert_rel_error(self, ew.y, 2.12345, 0.0001) self.assertEqual(not ew.b, ew.bout, msg='excel_wrapper could not handle a Bool variable') self.assertEqual(ew.s.lower(), ew.sout, msg='excel_wrapper couldn not handle a Str variable.') del(ew) os._exit(1)
def test_ExcelWrapper(self): logging.debug('') logging.debug('test_ExcelWrapper') from excel_wrapper.excel_wrapper import ExcelWrapper test_root = os.path.abspath(os.path.dirname(__file__)) excelFile = os.path.join(test_root, "excel_wrapper_test.xlsx") xmlFile = os.path.join(test_root, "excel_wrapper_test.xml") ew = ExcelWrapper(excelFile, xmlFile) ew.execute() assert_rel_error(self, ew.y, 2.12345, 0.0001) self.assertEqual(not ew.b, ew.bout, msg='excel_wrapper could not handle a Bool variable') self.assertEqual(ew.s.lower(), ew.sout, msg='excel_wrapper couldn not handle a Str variable.') del (ew) os._exit(1)
def test_ExcelWrapper(self): logging.debug('') logging.debug('test_ExcelWrapper') from excel_wrapper.excel_wrapper import ExcelWrapper test_root = os.path.abspath(os.path.dirname(__file__)) excelFile = os.path.join( test_root, "excel_wrapper_test.xlsx" ) xmlFile = os.path.join( test_root, "excel_wrapper_test.xml" ) ew = ExcelWrapper(excelFile, xmlFile) ew.execute() assert_rel_error(self, ew.y, 2.12345, 0.0001) self.assertEqual(not ew.b, ew.bout, msg='excel_wrapper could not handle a Bool variable') self.assertEqual(ew.s.lower(), ew.sout, msg='excel_wrapper couldn not handle a Str variable.') del(ew) os._exit(1)
def _test_ExcelWrapper(self, varfile, inputs={ 'x': 10, 'b': True, 's': u'aSdF', 'macroVar': u'macrocheck', 'macroVB': 12 }): prob = Problem() root = prob.root = Group() this_dir = os.path.dirname(os.path.abspath(__file__)) excelfile = os.path.join(this_dir, "excel_wrapper_test.xlsm") varfile = os.path.join(this_dir, varfile) kwargs = {} if not varfile.endswith('.json'): kwargs['macros'] = ('Macro5', 'Sheet3.Transfer_ColA') root.add('ew', ExcelWrapper(excelfile, varfile, **kwargs), promotes=['*']) varcomp = IndepVarComp( ((name, val) for name, val in six.iteritems(inputs))) root.add('vc', varcomp) root.connect('vc.x', 'x') root.connect('vc.b', 'b') root.connect('vc.s', 's') root.connect('vc.macroVar', 'macroVar_in') root.connect('vc.macroVB', 'macroVB_in') prob.setup() prob.run() self.assertEqual((2.1 * float(prob['x'])), prob['y']) self.assertEqual((2.1 * float(inputs['x'])), prob['y']) self.assertEqual(inputs['b'], prob['b']) self.assertEqual(prob['macroVar_in'], prob['macroVar_out']) self.assertEqual(3 * int(prob['macroVB_in']) - 1, int(prob['macroVB_out'])) self.assertEqual(bool(prob['b']), not prob['bout']) self.assertEqual(inputs['s'], prob['s']) self.assertEqual(prob['s'].lower(), prob['sout']) self.assertEqual( float(prob['sheet1_in']) + 100, prob['sheet2_out'], "Excel wrapper fails in multiple sheets")