def testImportExcel(self): result = importer.importExcel(CONST_EXCEl_FILENAME) self.assertNotEqual(None, result, 'result is none') self.assertEquals(34, len(result)) self.assertEquals('Nr.', result[100].name) self.assertTrue(result[100].isVariabel) self.assertFalse(result[300].isVariabel)
def createSpatiaLiteDatabase(excelPath, projectName, outputPath): ''' Main Method Creates a Spatialite-database with given attribute Names as Excel sheet The name of the file will be 'projectName.sqlite' ''' excelElements = guiCreator.importExcel(excelPath) attributeNames = extractAttributeNames(excelElements) createTables(attributeNames[0], attributeNames[1], projectName, outputPath)