Author: Vitosh

Dynamic dropdown list in Excel VBA with variables

Dropdown lists in Excel usually are built from a range or from a variable list. Dropdown list from Excel Range Thus, building a dynamic dropdown list may include building a dynamic range, with undeclared end. Thus, let’s imagine that the

Tagged with: , , , , ,

Prime numbers matrix and coloring with Python and xlsxwriter

About 4 years ago, I wrote an article about prime numbers in Excel and their visualisation with VBA – vba-function-in-excel-to-check-prime-numbers. Pretty much, it displays the prime numbers in a 10 x N matrix, starting from 1 and finishing at N:

Tagged with: , , , , , , , , , ,

Scraping web site and writing its links to a database with Python

Scraping a web site with BeautifulSoup 4 and Python is a walk in the park, if you have scraped a web site with VBA before. Still, there are a few tricks, that should be taken into account. Trick #1 –

Tagged with: , , ,

Adding data to SqlLite3 database with Python

After reading the database to python from the previous post here, it is time to do the ADD data to the database. Our database is created like this:

The database has autoincremented primary key, thus we do not need

Tagged with: , , , ,

Connecting SqlLite3 database to Python and Reading it

Connecting SqlLite3 database to a Python file is actually 1 line of code: conn = sqlite3.connect(r"C:\Users\database.db") I have used a database from sqllitetutorial.net, which was rather neat. Then DB Browser for SQLLite a LEFT JOIN was implemented, in order to unite the

Tagged with: , , ,

Adding data to SqlLite3 database, but only one value with Python

Life is hard, when you are learning Python and you see things that are making no sense the way they run. After writing about adding data to SqlLite3 with Python, today I have tried to do the same, but for

Tagged with: , , ,

Find all HTML tags in a web page and print them from a sorted dictionary

Finding all HTML tags from a web page and recording these to a dictionary is magically easy task with Python (if you compare it with #VBA), when Beautiful Soup 4 is used. soup.find_all(True) loops through the tags and a simple

Tagged with: , , , ,

Write Formulas in Excel through Python XlsWriter

Writing formulas with Excel with Python is a technique, that needs some practice, actually. Although XlsWriter has some good documentaion, not a lot is covered on the point, that concerns creating a file with a formula in it. First and

Tagged with: , , , ,

Writing to a text file in Python from a variable, ignoring encoding problems

Writing to a file in Python is usually a simple 2-liner, which is easy to be written:

However, problems with the encoding may cause some research needed. Concerning the encoding this is a great article from the creator of

Tagged with: , , ,

Show all links from a website with Python and BeautifulSoup

Showing all links from a website with Python and BeautifulSoup is actually 6 lines of code – 2 to define the used libraries and 4 to do the job:

In general, BeautifulSoup comes out of the box with beautiful

Tagged with: ,

Python – The birthday paradox algorithm

The birthday paradox is an interesting problem, mainly because of its somehow “unexpected” results. The problem usually is stated as the following: What is the minimum number of people in a room, in order to have a probability higher than

Tagged with: , , ,

VBA – How to implement workbook events in Excel – GIF

The Excel Workbook object is a part of the Workbooks collection. The events are the code, which is “activated” or “triggered”, once a specific event happens. These events are different and could be unlimited, but there are a few built-in Workbook

Tagged with: , , ,

Sets in Python – Differece, Symetric Difference, Union, Intersection

After writing the article scraping a web site up to the N-th level with Python, I have decided to summarize what could be achieved with Set() in this language. Pretty much, sets can be described as lists with a few

Tagged with: , , , ,

Numpy and Pandas – Small introduction with Jupyter Notebook

Last week I was participating at the Python and ML Summit in Berlin. One of the most interesting lectures, on which I participated, was a workshop by, named “Reading all yourself was yesterday – How to turn large amounts of

Tagged with: , , , , ,

Python and MachineLearning Summit in Berlin – Summary

This Monday and Tuesday (14. – 15. October 2019) I was in Berlin, participating at the #Python and #ML Summit. Actually, #Berlin is a nice city, one of my favourites in Germany, thus if you are not from there, only

Tagged with: , , , ,

Competitive Programming – Bus Stops Problem – Video

In competitive programming, following the ICPC rules, one of the best strategies is to scan the problems given to your team and to start with the easiest ones. The easiest ones are not always the first problems and sometimes these

Tagged with: , ,

VBA – How to avoid naming variables with non-latin alphabet characters (special letters)

Writing code in the local language is actually taught by about 100% of the German VBA books, which I have read. Which is “kind of ok”, if the VBA code only works on German computers. However, if this is not

Tagged with: , ,

C# – Learn about advanced scenarios – ASP.NET MVC with EF Core

Exactly 1 month and 5 days after the first video tutorial for the ASP.NET MVC with EF Core series, the last 10th video tutorial, following the Microsoft ones, is published. It is about advanced scenarios, and I have mentioned the

Tagged with: , , , ,

VBA – Color Only Half of the Border of an Excel Cell

Coloring the border of an Excel cell is a trivial task. The LineColor feature in Excel is easy to use out of the box: However, whenever half of the cell needs to be colored, the trick is a bit more tough

Tagged with: , , , , ,

C# – Implementing Inheritance – ASP.NET MVC with EF Core

Slowly, after handling concurrency in the ASP.NET MVC application, we are approaching the end of the video tutorial series. Implementing inheritance is the prelast one and it is actually pretty an important one as well. In the video, the following

Tagged with: , , ,

Book Review – Pro ASP.NET Core MVC 2

Adam Freeman has written the 7th edition of the Pro ASP.NET Core MVC 2 book. And there should really be a reason to issue the book so many times! The book itself gives my favourite way of presenting software –

Tagged with: , ,

C# – Handle concurrency – ASP.NET MVC with EF Core

After updating the related data in the ASP.NET tutorial, it is time for the next step – handling concurrency in the MVC Application. These are the points, followed by the video: Learn about concurrency conflicts Add a tracking property Create

Tagged with: , , , ,

C# – Update related data – ASP.NET MVC with EF Core

After reading complex the data, it is time to be able to update it. This video fills the following points from the ASP.NET MVC tutorial: Customize Courses pages Add Instructors Edit page Add courses to Edit page Update Delete page

Tagged with: , , , ,

C# – Read related data – ASP.NET MVC with EF Core – Video

After creating a complex data model, now it is time to display the data, following the tutorial. The task is actually a challenging one, as far as the data display is in a way partial – in the  “Instructors” view,

Tagged with: , , ,

C# – Create a complex data model – ASP.NET MVC with EF Core – Video

Creating a complex data model with the previous data model in ASP.NET is actually a challenging task. The model in general looks like this: It is not “extremely” complex, but it is something bigger than the previous 3 tables that

Tagged with: , , , ,

C# – Using Migrations – ASP.NET MVC with EF Core – Video

Migrations in C# are quite well facilitated by the EntityFramework. In general, when an application with databse is created, initially the database model is taken from the model classes. When these models classes change, then they get out of sync

Tagged with: , , , , ,

C# – Add sorting, filtering, and paging – ASP.NET MVC – Video

Sorting, filtering, paging and summary of an app are quite important features. In this video, which is a continuation of the Microsoft tutorial, I present step-by-step how to do each one of these. It is quite a large video, but

Tagged with: , , , ,

C# – Implement CRUD Functionality – ASP.NET MVC with EF Core – Video

This is the second video of the Microsoft tutorials, for ASP.NET MVC with Entity Framework Core: Continuing the previous video, in this one the following tasks are carried out: Customize the Details page Update the Create page Update the Edit

Tagged with: , , ,

C# – Get started with EF Core in an ASP.NET MVC Web App – Video

Lately, I have started with creating video tutorials for ASP.NET. Thus, today it is time to deep dive in the ASP.NET once again, following the Microsoft tutorial for ASP.NET MVC Web App from here. In the video below, the following

Tagged with: , , , , , ,

C# – Create a web app with ASP.NET Core MVC – Video

Creating a web application with ASP.NET could look as a hard task. Still, with the pre-built MVC models from Visual Studio, the task is a bit easier. This is how the application looks like, with 2 search buttons and fully

Tagged with: , , , , , ,
Top