{"id":13752,"date":"2023-11-17T09:56:58","date_gmt":"2023-11-17T08:56:58","guid":{"rendered":"https:\/\/pythonprogramming.altervista.org\/?p=13752"},"modified":"2023-11-17T09:57:45","modified_gmt":"2023-11-17T08:57:45","slug":"excel-python-p-1","status":"publish","type":"post","link":"https:\/\/pythonprogramming.altervista.org\/excel-python-p-1\/","title":{"rendered":"Excel + Python (p.1)"},"content":{"rendered":"\n
\"\"<\/a><\/figure>\n\n\n\n

We ca finally use Python into Excel directly, so let’s start using it. This is avaiable into the Microsoft 365 insider beta channel for the moment.<\/p>\n\n\n\n

The code<\/h2>\n\n\n\n

We can put the code into a cell by doing =py<\/strong> (and then press TAB) or pressing the python icon into the formulas tab.<\/p>\n\n\n\n

We ca finally use Python into Excel directly, so let’s start using it. This is avaiable into the Microsoft 365 insider beta channel for the moment. Write =py into a cell and then press TAB and you can start writing your code or press the python icon in the formulas tab of the Excel menu. You can run the script pressin ctrl+enter. To see the values you can use print, but you will see the result into the diagnostic panel only (activable pressing diagnostic near the python icon in the formulas tab). To see the values in the cells, do not use print, but just write the variable you want to get into the cells (if you separate them with a comma you will see them one under the other in different cells) and then go in the little arrow near the py text of the formulas on green background and choose excel values instead of python object, pressi ctrl+enter and you will get them.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n

You can see the code in the formulas tab<\/p>\n\n\n\n

import datetime\n\ntoday = datetime.datetime.today()\ntoday.day, today.month, today.year<\/pre>\n\n\n\n
Just three lines of code. We get the time from the datetime module and the today function.<\/p>\n\n\n\n
How to get the result in cells<\/h2>\n\n\n\n
Now, if we use print we will only get the result into the diagnostic panel<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
so, if we press ctrl + enter we wee this on the diagnostic panel on the right<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
1 the cell where the code is<\/p>\n\n\n\n
2 the year<\/p>\n\n\n\n
3 the month<\/p>\n\n\n\n
Let’s see if the formatting works in Excel too<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Result in the diagnostic<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
It worked, so we can check our variables better.<\/p>\n\n\n\n
Now, how to get some values into the Excel cells?<\/h2>\n\n\n\n
Simply doing this:<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Click on the arrow (1) and then on value of Excel. You will get this:<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
I commented the print statement, otherwise we wouldn’t have seen the values.<\/p>\n\n\n\n
So now the values are accessible into excel.<\/p>\n\n\n\n
Another way to get the value in a cell<\/h2>\n\n\n\n
Another way is to go into another cell and put = and then the cell where the value was (C3). Another is to create another python cell and write the variable into as you can see in the picture here.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
We can of course do operation with these values from python cells into regular Excel cells, like this shown in the picture below<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
 <\/p>\n\n\n\n
Ok, this is our first (not the very first, but the first of a new series maybe) sneak peek into Excel with Python. See ya next time for part 2.<\/p>\n\n\n\n
https:\/\/youtube.com\/shorts\/MGy1XK0CfRg<\/a><\/p>\n\n\n\n
How to use Excel with Python (p.1) https:\/\/t.co\/Ql4jm8MTsL<\/a> via @YouTube<\/a> #pythoninexcel<\/a> #python<\/a> #excel<\/a><\/p>— py-learn (@pythonprogrammi) November 17, 2023<\/a><\/blockquote>