Blog

Getting cell text in OpenXML SDK 2.5 is quite tricky because the cell text can be either stored in the cell itself, or in a shared string table. In the latter case, the cell value is just an index to the shared string table. Also, some files have data stored in CellValue, other files have data in the InnerText fields. To address all these variations, I wrote the tiny function to get the cell text in any case:

In the age of web development, programming C# WinForms applications are kind of outdated, but still, many software programmers are involved in developing legacy desktop applications, which will definitely be used for years from now on. Sometimes it is easier to develop a simple WinForms application that is self-sufficient and will just work by itself rather than pay rent for Microsoft Azure or Amazon AWS every month. So, the questions regarding these applications are still actual and demanded. 

When you build a form, the user is required to use the mouse to control it: click the buttons, edit text boxes, checkboxes, etc. But what if you need your form to be controlled just by the keyboard? Is it possible to press a hotkey and activate a specific control in the WinForms application? The answer is yes, and it is quite simple. 

Usually console applications are not associated with interactivity. Most of console apps accept some parameters via command line, do their job and exit. If the interactivity is needed, one has an option to build simple letters-controlled menu. While it is OK for simple applications, it is not enough for interactive applications. An alternative would be to create windowed application, which has richer keyboard and mouse control functionality out-of-the-box. But what to do if you want to stick with console application? Windows can enable your app to receive direct events related to mouse and keyboard sent to your console window.