Posts

Showing posts from March, 2019

Generate an excel report using python code

Image
Hello Python enthusiasts, In my new blog I would like to cover a new scenario from our routine work where we have to generate excel reports for our Business from an output csv file. In my project lot of excel reports are generated using the output file generated from Informatica powercenter tool, where in command task we execute a shell script and give the name of output file as an argument to that shell script which generates the excel report. And I was just looking through the script and it bounced over me, I hope I am not sounding alien to my readers. I really found writing and understanding shell scripts as cumbersome and tedious. And things get further more complicated when you start getting an error in if-else just because of the underlying shell and you have to search google for the syntax or the compatible shell. I am not saying shell scripts are not good, they definitely are robust but just to make the things more readable and understandable I thought of why not to simplif...