{"id":3874,"date":"2019-10-03T13:19:25","date_gmt":"2019-10-03T11:19:25","guid":{"rendered":"https:\/\/pythonprogramming.altervista.org\/?p=3874"},"modified":"2019-10-05T17:31:24","modified_gmt":"2019-10-05T15:31:24","slug":"create-and-html-table-with-python-and-tkinter","status":"publish","type":"post","link":"https:\/\/pythonprogramming.altervista.org\/create-and-html-table-with-python-and-tkinter\/","title":{"rendered":"Create and HTML table with Python and tkinter"},"content":{"rendered":"

The whole code<\/h2>\n

With this code we can create our table in html, starting from a table made in Excel like this:<\/p>\n

\"\"<\/a><\/p>\n

then, due to the need to convert this table in an html table, we copy it (ctrl+c) and paste it into our application. Then we press convert, then we save it and we show the table with the menu command save and show.<\/p>\n

Here is the GUI when we copied the Excel data:<\/p>\n

\"\"<\/a><\/p>\n

Then we press convert and we have this:<\/p>\n

\"\"<\/a><\/p>\n

You can see the data converted into html table. You then save and show the html file with the two commands in the menu. This is the output (the one above is not a picture, we used the html code generated above)<\/p>\n<\/table>\n

The whole code<\/h2>\n

This is the whole code to make this simple but useful app.<\/p>\n

import os\r\n\r\n\r\nhtml = \"\"\r\ndef table(x):\r\n\tglobal html\r\n\t\"\"\" Create table with data in a multiline\r\n\tstring as first argument x)\"\"\"\r\n\thtml = \"<!-- table -->\"\r\n\thtml += \"<table border=1>\"\r\n\tfor line in x.splitlines():\r\n\t\tfor n in line.split():\r\n\t\t\thtml += f\"<td>{n}<\/td>\"\r\n\t\thtml += \"<tr>\"\r\n\thtml += \"<\/table>\"\r\n\treturn html\r\n\r\ndef create(a):\r\n\ttab = table(text.get(\"1.0\", tk.END))\r\n\ttext.delete(\"1.0\", tk.END)\r\n\ttext.insert(\"1.0\", tab)\r\n\tlabel['text'] = \"Now you can copy the html code for the table (ctrl + a)\"\r\n\r\ndef save_html():\r\n\tif html != \"\":\r\n\t\twith open(\"table.html\", \"w\") as file:\r\n\t\t\tfile.write(text.get(\"1.0\", tk.END))\r\n\r\ndef show_html():\r\n\tif os.path.exists(\"table.html\"):\r\n\t\tos.startfile(\"table.html\")\r\n\r\ndef convert_to_html():\r\n\thtml = table(text.get(\"1.0\",tk.END))\r\n\tclear()\r\n\ttext.insert(\"1.0\", html)\r\n\r\ndef clear():\r\n\ttext.delete(\"1.0\", tk.END)\r\n\r\nimport tkinter as tk\r\nroot = tk.Tk()\r\nroot.title(\"Html table converter\")\r\nlabel = tk.Label(root, text=\"Insert data here separated by space and press Ctrl+c to convert to html table:\")\r\nlabel.pack()\r\ntext = tk.Text(root)\r\ntext.pack()\r\ntext.bind(\"<Control-c>\", create)\r\ntext.focus()\r\n# create a toplevel menu \r\nmenubar = tk.Menu(root)\r\nmenubar.add_command(label=\"Convert - crtl+c |\", command=convert_to_html)\r\nmenubar.add_command(label=\"Save  |\", command=save_html)\r\nmenubar.add_command(label=\"Show  |\", command=show_html)\r\nmenubar.add_command(label=\"Clear screen  |\", command=clear)\r\n# display the menu\r\nroot.config(menu=menubar)\r\nroot.mainloop()\r\n<\/pre>\n
*update: addet crtl+c as shortcut to convert data into html<\/p>\n
Version 2<\/h2>\n
In this version we have two text box, the first for the text, the second with the html. In this version you separare the cells with tabs, so that you can use a space between words in the same cell (otherwise, it would separate each word into different cells, having you to write two words like this first_second, to avoid splitting the single words into different cells.<\/p>\n
\"\"<\/a><\/p>\n
The code:<\/p>\n
import os\r\n\r\n\r\nhtml = \"\"\r\ndef table(x):\r\n\tglobal html\r\n\thtml = \"\"\r\n\t\"\"\" Create table with data in a multiline\r\n\tstring as first argument x)\"\"\"\r\n\thtml = \"<!-- table -->\"\r\n\thtml += \"<table border=1>\"\r\n\tfor line in x.splitlines():\r\n\t\tfor n in line.split(\"\\t\"):\r\n\t\t\thtml += f\"<td>{n}<\/td>\"\r\n\t\thtml += \"<tr>\"\r\n\thtml += \"<\/table>\"\r\n\treturn html\r\n\r\ndef create(a):\r\n\ttab = table(text.get(\"1.0\", tk.END))\r\n\t#text.delete(\"1.0\", tk.END)\r\n\ttext2.insert(\"1.0\", tab)\r\n\tlabel['text'] = \"Now you can copy the html code for the table (ctrl + a)\"\r\n\r\ndef save_html():\r\n\tif html != \"\":\r\n\t\twith open(\"table.html\", \"w\", encoding=\"utf-8\") as file:\r\n\t\t\tfile.write(text2.get(\"1.0\", tk.END))\r\n\r\ndef show_html():\r\n\tif os.path.exists(\"table.html\"):\r\n\t\tos.startfile(\"table.html\")\r\n\r\ndef convert_to_html():\r\n\thtml = table(text.get(\"1.0\",tk.END))\r\n\tclear2()\r\n\ttext2.insert(\"1.0\", html)\r\n\r\ndef clear2():\r\n\ttext2.delete(\"1.0\", tk.END)\r\n\r\ndef clear():\r\n\ttext.delete(\"1.0\", tk.END)\r\n\ttext2.delete(\"1.0\", tk.END)\r\n\r\nimport tkinter as tk\r\nroot = tk.Tk()\r\nroot.title(\"Html table converter\")\r\nlabel = tk.Label(root, text=\"Insert data here separated by tabs\")\r\nlabel.pack()\r\ntext = tk.Text(root, height=7)\r\ntext.pack()\r\ntext.bind(\"<Control-p>\", create)\r\ntext.focus()\r\nlabel2 = tk.Label(root, text=\"Press ctr+p and you'll get the html code here\")\r\nlabel2.pack()\r\ntext2 = tk.Text(root, bg='gold', height=7)\r\ntext2.pack()\r\n# create a toplevel menu \r\nmenubar = tk.Menu(root)\r\nmenubar.add_command(label=\"Convert - crtl+p |\", command=convert_to_html)\r\nmenubar.add_command(label=\"Save  |\", command=save_html)\r\nmenubar.add_command(label=\"Show  |\", command=show_html)\r\nmenubar.add_command(label=\"Clear screen  |\", command=clear)\r\n# display the menu\r\nroot.config(menu=menubar)\r\nroot.mainloop()\r\n<\/pre>\n
Version 3: filedialog<\/h2>\n
Now you can open a txt<\/strong> file with the data from a filedialog<\/strong> window called by tkinter<\/strong>. This way, you can save your data into a txt file, so that you can change them and convert them easily with the app into a html table. Now it is also possible to clean the html tags<\/strong> and get back the cleaned data, pasting (or opening) a html code\/file.<\/p>\n
import tkinter as tk\r\nimport os\r\nfrom tkinter import filedialog\r\n\r\n\r\nmy_filetypes = [('python', '.py'), ('html', '.html'), ('text files', '.txt')]\r\ndef open_folder():\r\n\tanswer = filedialog.askopenfilename(parent=root,\r\n                                    initialdir=os.getcwd(),\r\n                                    title=\"Please select a file:\",\r\n                                    filetypes=my_filetypes)\r\n\ttry:\r\n\t\ttext.delete(\"1.0\", tk.END)\r\n\t\twith open(answer) as file:\r\n\t\t\ttext.insert(\"1.0\", file.read())\r\n\texcept FileNotFoundError:\r\n\t\tprint(\"file not found\")\r\n\r\ndef convert_reverse(x):\r\n\ttags = [\r\n\t\t(\"<\/table>\",\"\"),\r\n\t\t(\"<!-- table -->\",\"\"),\r\n\t\t(\"<table border=1>\",\"\"),\r\n\t\t(\"<td>\",\"\\t\"),\r\n\t\t(\"<\/td>\", \"\"),\r\n\t\t(\"<tr>\", \"\\n\")]\r\n\tfor tag in tags:\r\n\t\tx = x.replace(tag[0], tag[1])\r\n\treturn x\r\n\r\nhtml = \"\"\r\ndef table(x):\r\n\tglobal html\r\n\tif \"<table\" in x:\r\n\t\treturn convert_reverse(x)\r\n\thtml = \"\"\r\n\t\"\"\" Create table with data in a multiline\r\n\tstring as first argument x)\"\"\"\r\n\thtml += \"<table border=1>\"\r\n\tfor line in x.splitlines():\r\n\t\tfor n in line.split(\"\\t\"):\r\n\t\t\tif n == \"\":\r\n\t\t\t\tcontinue\r\n\t\t\thtml += f\"<td>{n}<\/td>\"\r\n\t\thtml += \"<tr>\"\r\n\thtml += \"<\/table>\"\r\n\treturn html\r\n\r\ndef create(a):\r\n\ttab = table(text.get(\"1.0\", tk.END))\r\n\t#text.delete(\"1.0\", tk.END)\r\n\ttext2.insert(\"1.0\", tab)\r\n\tlabel['text'] = \"Now you can copy the html code for the table (ctrl + a)\"\r\n\r\ndef save_html():\r\n\tif html != \"\":\r\n\t\twith open(\"table.html\", \"w\", encoding=\"utf-8\") as file:\r\n\t\t\tfile.write(text2.get(\"1.0\", tk.END))\r\n\r\ndef show_html():\r\n\tif os.path.exists(\"table.html\"):\r\n\t\tos.startfile(\"table.html\")\r\n\r\ndef convert_to_html():\r\n\thtml = table(text.get(\"1.0\",tk.END))\r\n\tclear2()\r\n\ttext2.insert(\"1.0\", html)\r\n\r\ndef clear2():\r\n\ttext2.delete(\"1.0\", tk.END)\r\n\r\ndef clear():\r\n\ttext.delete(\"1.0\", tk.END)\r\n\ttext2.delete(\"1.0\", tk.END)\r\n\r\nroot = tk.Tk()\r\nroot.title(\"Html table converter\")\r\nlabel = tk.Label(root, text=\"Copy data from Excel and insert them here separated by tabs\")\r\nlabel.pack()\r\ntext = tk.Text(root)\r\ntext.pack(fill=tk.BOTH, expand=1)\r\ntext.bind(\"<Control-p>\", create)\r\ntext.focus()\r\nlabel2 = tk.Label(root, text=\"Press ctr+p and you'll get the html code here\")\r\nlabel2.pack()\r\ntext2 = tk.Text(root, bg='gold')\r\ntext2.pack(fill=tk.BOTH, expand=1)\r\n# create a toplevel menu \r\nmenubar = tk.Menu(root)\r\nmenubar.add_command(label=\"Open\", command=open_folder)\r\nmenubar.add_command(label=\"Convert\", command=convert_to_html)\r\nmenubar.add_command(label=\"Save\", command=save_html)\r\nmenubar.add_command(label=\"Show\", command=show_html)\r\nmenubar.add_command(label=\"Clear\", command=clear)\r\n# display the menu\r\nroot.config(menu=menubar)\r\nroot.mainloop()<\/pre>\n
\"\"<\/a><\/p>\n\t\r\n

N.<\/td>Bene_A_4%<\/td>Bene_B_10%<\/td>Trasporto<\/td>CDR<\/td>Trasp_A<\/td>trasp_B<\/td>IVA_A<\/td>IVA_B<\/td>TOT<\/td>
1<\/td>1200,00<\/td>800,00<\/td>100,00<\/td>0,05<\/td>60,00<\/td>40,00<\/td>50,40<\/td>84,00<\/td>2234,40<\/td>
2<\/td>1400,00<\/td>900,00<\/td>120,00<\/td>0,05<\/td>73,04<\/td>46,96<\/td>58,92<\/td>94,70<\/td>2573,62<\/td>
3<\/td>1600,00<\/td>1000,00<\/td>140,00<\/td>0,05<\/td>86,15<\/td>53,85<\/td>67,45<\/td>105,38<\/td>2912,83<\/td>
4<\/td>1800,00<\/td>1100,00<\/td>160,00<\/td>0,06<\/td>99,31<\/td>60,69<\/td>75,97<\/td>116,07<\/td>3252,04<\/td>
5<\/td>2000,00<\/td>1200,00<\/td>180,00<\/td>0,06<\/td>112,50<\/td>67,50<\/td>84,50<\/td>126,75<\/td>3591,25<\/td>