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)