Recently, I needed to be able to parse Excel files and to output Excel files. However, I found that my old code from previous blog posts were now problematic:
Those old implementations used EPPlus which is now a commercial product. I wanted something open source.
Day two of Microsoft Build is slowly coming to a close. Here are a few of my impressions after two days.
Earlier, I wanted to play around with Angular CLI, but my npm and node versions were out of date. The Angular CLI npm install would fail.
Fortunately, there is a straight-forward update method.
On github, the Microsoft team has placed a method for updating node through PowerShell:
I was happy to stumble upon this on Github. After using the script in the recommended fashion, from an elevated PowerShell console, the Angular CLI npm installer worked without a hitch.
Set-ExecutionPolicy Unrestricted -Scope CurrentUser -Force
npm install --global --production npm-windows-upgrade
Previously, I wrote about parsing an Excel spreadsheet to a list of objects. This is a pretty useful technique, but what do you do if you want to provide the user with an Excel template to get started? Being able to provide them with an initial template based on your object model is a good starting point.
Business people love their Excel spreadsheets. Fact. As such, I work with Excel a lot to parse and manipulate data. However, from a .NET perspective, Excel in its raw form isn’t overly useful. Being able to take an Excel worksheet and build a List<T> can be extremely useful.
Over the weekend, I started moving various source files over to github. Typically, I just use Notepad2 for basic editing and such.
However, after all the good things I read, and have seen, about Visual Studio Code, I finally decided to give it a try as a basic editor.
Earlier today, after a system outage, I was sent a W3C IIS Log to take a look at.
After staring at this log for a few minutes in Notepad2, my eyes started to glaze over. Basically, staring at system or IIS logs with a text editor is useless if there are tons of events or requests.
I knew there are plenty of parsing tools out there for log analysis, and I had used some before. Unfortunately, I had none of these tools installed on my laptop. Googling quick lead me to a Microsoft tool called ‘LogParser’ that I had never heard of before.
With all of the hoopla lately about Azure, I have been playing with it, and Application Insights, for the past few weeks.
One thing that I hadn’t really delved into is its .NET Web App hosting. As an MSDN subscriber, many of the cloud services are offered in some form of free capacities. This includes Web App and Azure SQL hosting.
Microsoft Ignite is coming to a close and it’s been a whirlwind week for me.
Overall, the material presented adhered to Microsoft’s agenda of touting Azure, its cloud, and IaaS/PaaS products. Infrastructure as a Service and Platform as a Service are interesting, in and of themselves, but I find that most aren’t ready to jump in with both feet.