Using Excel to work with SQL Server data sets is often more convenient than having to write a complete solution using C#. A variety of solutions exist to work with Excel from your C# code and Microsoft.Office.Interop.Excel is just one of them. EPPlus is also a popular solution for working with Excel. EPPlus is free… Read More
Years ago, I wrote an application in VBA for Excel to parse an 830 document and format the data into a useable worksheet. The code can process an 830 document (EDI text file) containing upwards of 2500 lines in less than 20 seconds all while creating and formatting the worksheet from scratch. The VBA code… Read More
Visual Studio 16.9 and 16.10 Preview 1 bring many new features to enhance your coding experience. The best IDE is only a few clicks away. Read More
Released on February 9, 2021, Visual Studio Community 2019 4.0 gets even better. Read More
How to Create and Read Excel files from your C# application. Read More
Solution to Target Platform errors using Visual Studio C# Installer, Setup, or Deployment build.
ERROR: File ‘log4net.dll’ targeting ‘AMD64’ is not compatible with the project’s target platform ‘x86’
WARNING: File ‘log4net.dll’ targeting ‘x64’ is not compatible with the project’s target platform ‘x86’ Read More