Coding Duo

 Hello dudes! Did you ever feel irritated by resizing each column in Excel?👀 Don't worry this post is to solve your problem! Yess this post is about "How to enable column auto-resizing feature in excel using a single line macro (VBA)" Language : VBA  Before resizing Size of column is not consistent with text Whenever the above problem arises we will be manually adjusting the column right? . But hereafter it wont be the case! Steps to enable column autofit feature: Step 1: - Right click on sheet name and select View Code Step 2 : - After getting this window click on the drop-down menu and select Worksheet (which means this code is applicable only for this specific sheet) - First and last line of the code will be generated automatically , so our work is to type " Cells.EntireColumn.Autofit " - Click on to excel icon on left corner (which brings you back to sheets) - Haan Done! - This code not only resize the columns as per existing data, but the resizing operat...

 Hello Dudes!  Hope you all are doing well 😀  Today we gonna see a python code for " Number Guessing Game"! . In short, in this game python will choose a random number within the given range and you are required to guess the number. Don't worry, until you choose the right one it will help you with some comments 😉. Language : Python IDE : Pycharm  Code : - "random" module is imported (with which random number can be generated within the given range). - An user defined function named "number_guessing_game" is created  - Two variables are created   1) number -In this variable randomly generated number is stored  2) guess - The number which you guess will be stored here . Initially this variable is assigned with null. - The logic behind while loop is : until you guess the correct number it will ask you to guess. - The logic behind if condition is : if guessed value is lower than the generated value then the comment " Your guess is too low" ...

 Hello dudes! Inaiku nama pakaporadhu - Single line python code for calculator"  IDE : Visual Studio Code Input: print(eval(input ("Enter" ) ) )  ->eval() is an inbuilt function of python ->In this function when we pass any python expression as a “string” , it evaluates the expression and returns the result as an integer or float  -> so indha inbuilt function ah use pani nama single line la calculator pana mudiyum Output: -> Input code ah run panitu, direct ah terminal la poi nama calculations potu enter thandha udane answer vandhurum -> Here we gave 2+3/4*6  and got 6.5 as result -> Ethana mathematical expressions thandhalum BODMAS ( Brackets, Orders, Division, Multiplication, Addition and Subtraction ) rules padi dhan result varum So inike indha code try panunga, eval() use pani vera enalam pana mudiyum nu explore panitu comment la solunga! see you all in next post bybye Enjoy Coding!

 Hello dudes, Today we gonna see about how to generate audio from the text input using python. Language: Python IDE : Pycharm Step 1 : The API (Application Programming Interface) we will be using here is gTTS (google Text To Speech), so our first step is to install this API by running the following code pip install gTTS    Step 2 : Type the following code and execute : Using this code we have freedom to  : -> Change Text Input -> Change Language  -> Change Pace [Fast or Slow] -> Save the generated audio - > Play the generated audio Note : texts after "#"  symbol are comments ,otherwise called as non-executable statements which are given here only for the purpose of explanation.   Step 3:  Yeah its time to run it!   The generated audio will be saved in the location of the code. After saving, media player (at first time you are required to choose your desired media player) will be opened automatically.      The...

Hii makkale! Today we gonna see about a simple python code with which automatic whatsapp message can be sent to any whatsapp number at the scheduled time!. Ok doods let's dive into the project!  Step 1: To carry out this task a python library named pywhatkit is used. To install this library in your machine jus type in the following code in your code editor pip install pywhatkit.  Note : Make sure to install this library otherwise the following code doesn't work.  Step 2 : Type the following code in your code editor..  Line 1 : import pywhatkit as pwt.  This lines tells that pywhatkit can be called as pwt in the upcoming lines of code. It's not mandatory to use pwt, we can use any word instead of pwt.  Eg: import pywhatkit as sethapayale , too works😜. It's a kinda chella peyar (nickname) . But make sure this chella peyar  (nickname ) to be the same throughout the project.  Line 2 : pwt.sendwhatmsg ("phone number with code'', '' message...

 Hello Makkale! Inaiku nama pakaporadhu " How to create digital pulli for digital kolam using Python " in other words " How to create pyramid pattern using python "  Language : Python    IDE : Pycharm  Mangalagarama Pycharm la start panrom Lets dive into the code In the above code, we have initialized the n variable to enter the number of rows for the pattern. We entered n = 5, the range of outer for loop will be 0 to 4. The iteration of the inner for loop depends on the outer loop. The inner loop is responsible to print the number of columns of kolam. In the first iteration, the value of i is 0, and it increased by 1, so it becomes 0+1, now inner loop iterated first time and print one kola pulli (*). In the second iteration, the value of i is 1 and it increased by 1, so it becomes 1+1, now inner loop iterated two times and print two kola pulli (*). The end argument prevents to jump into another line. It will printer the star until the loop is valid. The la...