Tag: sql server

C# – Create a website to upload an excel file and process it on a Python program.

Posted on by SQL Master

In this exercise we will create a simple Web Application just to upload an excel file and send it to a python program. We will implement this solution to perform the steps described in the flowchart below. 1 – The user will upload a file to application 2 – The file will be sent to … Continue reading “C# – Create a website to upload an excel file and process it on a Python program.”

Python – Inserting data from Excel file into Database table

Posted on by SQL Master

On this post we will do an exercise in which we will read data from an Excel file and insert this data into a SQL Server database table. Consider the situation in which you want open an excel file to perform some mathematical operations and after that insert the results into a database table. Note … Continue reading “Python – Inserting data from Excel file into Database table”