Reading from Excel in C# is actally not at tough as many VBA developers would assume. The simple reading is actually quite straightforward – there is only small little trick, requiring the adding of the Microsoft.Office.Interop.Excel reference to the Visual …
C# – Reading from Excel Spreadsheets with Asynchronous Programming (Async) Read more »
Getting the last row of a given column in Excel with a formula or with VBA is quite a trivial task. It is explained here quite well 🙂 However, when we come to C#, the only “trick” that is provided …
C# – How to get the last filled cell of a given row in Excel Read more »
Finding the biggest square of specific units in a given matrix of these units is a standard dynamic programming problem. The examples in Google for it are above 18 million, thus I would simply show how it is done with …
C# – Find the Biggest Square in a Matrix – What can Excel and VBA add to it? Read more »