posted on August 31, 2022 by long2know in ASP.NET, Microsoft
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:
https://long2know.com/2016/05/parsing-excel-to-a-list-of-objects/
https://long2know.com/2016/06/create-an-excel-template-from-objects/
Those old implementations used EPPlus which is now a commercial product. I wanted something open source.
More Linkposted on May 11, 2017 by long2know in Microsoft
Day two of Microsoft Build is slowly coming to a close. Here are a few of my impressions after two days.
posted on December 17, 2016 by long2know in JavaScript
Recently I posted about a method I use in JavaScript (Angular specifically) to transform posted Date objects to transmit the local DateTime. It’s a simple method that uses JavaScript’s “toLocaleString” method while intercepting POST requests. Everything worked fine except when IE11 was introduced into the equation.
posted on June 30, 2016 by long2know in JavaScript, Microsoft
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:
https://github.com/felixrieseberg/npm-windows-upgrade
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 npm-windows-upgrade
posted on June 8, 2016 by long2know in ASP.NET, Microsoft
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.
posted on May 25, 2016 by long2know in ASP.NET, Microsoft
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.
posted on August 10, 2015 by long2know in Microsoft
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.
posted on May 15, 2015 by long2know in Microsoft, Testing, Web
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.
posted on May 14, 2015 by long2know in ASP.NET, Azure, Microsoft
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.
posted on May 8, 2015 by long2know in Microsoft, Web
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.
