• Coding

    Automate Simple Tasks with Python: Excel Table to HTML Table using the python Dominate Module

    Book Sometimes a database is really not necessary. Why not try a simple excel sheet Coded this in an hour; sips on coffee though 9:06:34 PM I generated the excel workbook using a website called Mockaroo. Today’s task is to convert a basic excel sheet table into an HTML table. I broke the task into sub tasks which were then later translated into functions.   Do you need a website ? I can build it for you! PseudoCode Convert Excel Table into one dimensional List containing dictionaries Convert List into HTML document Save HTML string into a file with “.html” extension Done The Excel Sheet looked like this: MOCK_DATA The code generated…

error: Content is protected !!