Same article, but for VBA is here – https://www.vitoshacademy.com/vba-split-worksheet-to-worksheets-save-excel-worksheets-to-csv/ This article does 2 things: Splits one worksheet to multiple worksheets Then goes through the worksheets and saves them as *.CSV files So what is the idea? Having this excel file, …
Python – Split worksheet to worksheets, save Excel worksheets to csv Read more →
If you are one of the many VBA developers, then most probably you have been asked once or twice to download some file from a local eshare or site. Before downloading it, it really makes sense to check, whether this …
VBA – Check if resource or url exists in the internet Read more →
Some time ago, probably yesterday or the day before, I had to filter a pandas dataframe and somehow it did not come intuitively into my mind how to do it. As I did not have an article about it, I …
Python – Filtering values from a Pandas DataFrame Read more →
Inserting into string in Excel should be a trivial task, but it always makes sense to have something prepared in the boilerplate, before you start working. Ok, why is it important to have a nice function, if something like this …
Back in ancient times, one of the most popular MS-DOS utilities I wrote was the Fast File Finder. It wasn’t particularly fast, of course. But it did the job of finding a file anywhere on the PC’s hard drive when …
The idea here would be to show some git log tricks and to develop the article, whenever I find something more and more worthy. Before starting this one, please remember that exiting vim editors in the command prompt is with …
Ok, dates in VBA and Excel are somehow complicated, because of some “feature” that Microsoft Excel has introduced, due to compatibility issues. I have already wrote a few articles about these here, and separate one about what day is Friday …
Python – Just a bit about datetime and timedelta Read more →
Sometimes, (but only sometimes) we think that writing too much code is useless and writing less code in python is more readable and performs faster. While in the general case this is true, this article is simply going to show …
Python – Init a class with a default list property correctly Read more →
Reading from the console and writing to it is a piece of cake in python. These two functions do it for you perfectly: a = input() print(a) Then why am I writing a whole article about it? Well, there is …
Plenty of times, when you are looping with a for-each loop in python, you somehow realize that you need a counter. Then you most probably write something ugly like this one: a = 0 for count_value in my_odd_squares: a = …
The idea of the article is to provide a Python code that does the following: Takes a list or DataFrame; Splits it into quite a few smaller parts; Writes each one on a separate Excel worksheet; Pretty much like this: …
Python – Write a DataFrame or List to multiple tabs in Excel Read more →
Same article, but for Python is here – https://www.vitoshacademy.com/python-split-worksheet-to-worksheets-save-excel-worksheets-to-csv/ This article does 2 things: Splits one worksheet to multiple worksheets Then goes through the worksheets and saves them as *.CSV files I hope that is enough for you. Ok, so …
VBA – Split worksheet to worksheets, save Excel worksheets to csv Read more →
Option Compare in VBA is the thing, that will save you ugly stuff like this one: Sub Testing() Dim userInput As String userInput = InputBox(“What is decimal 4094 in hex?”) If UCase(userInput) = UCase(“ffe”) Then Debug.Print “You have correctly written …
VBA – Option Compare (Text || Binary || Database) Read more →
Plotting a circle with matplotlib library in python is an interesting task. If you google it, you will find quite good answers, but anyway, I am here because I want to summarize my point of view. Pretty much, the idea …
Getting N-th string between two substrings might sound a bad idea, until you do not need it. And with VBA, you better have something prepared. So, imagine the following XML (from this article here): <FootballInfo> <row> <ID>1</ID> <FirstName>Peter</FirstName> <LastName>The Keeper</LastName> …
VBA – Get Substring Between 2 Substrings – Locate value of Nth XML Read more →
Dictionary to a CSV file is probably a good question, if you are hiring a VBA developer. For a python person it should be a trivial one, as this one should not be even a tough search in Google. Anyway, …
Getting some tiny URL, that redirects you to somewhere else might be dangerous. There are a lot of people, that would never ever click on bit.ly/something or goo.gl/something, just because they do not know where the redirect is going to …
How to get redirect url using Excel VBA or Python Read more →