Kunal-Chowdhury.com - Microsoft Technology Blog for developers and consumers

Here's how to read Excel 97-2003 document (XLS) using NPOI libraries

In the last article, we have discussed about the NPOI library and then learned how to read Excel 2007 file formats using the free, open sourced NPOI library. I hope, the code snippet was clear and easy to understand.

 

In this article, we will learn how to read Excel 97-2003 workbooks easily using the free Apache NPOI libraries in your C#/.NET applications.



Windows 10 PC build 16241 rolls out to insiders in the Fast ring

Windows 10 Insider Preview build 16241 is being rolled out to Windows Insiders in the fast ring. It includes a no. of new improvements to the Windows Shell. Apart from that, Windows 10 Mobile Insider Preview build 15230, has been also released.

 

Check this post to know the latest improvements, fixes in this new PC build 16241. Don't forget to checkout the known issues before downloading this build.


Here's how to read Excel 2007 document (XLSX) using NPOI libraries

Recently, we have learned how to read Excel workbooks using the Microsoft Office COM APIs. As you may already know that the COM APIs are slow while performing operation, we will see another way to read the content which is faster.

 

In this article, we will learn how to read Excel 2007 workbooks using the Apache NPOI libraries which is available freely to use in your application.


Windows 10 most likely to allow control over update bandwidth

Windows 10 Update delivery works better by creating a peer network to send/receive updates within LAN and/or internet. But till date, there was no control over it's upload/download bandwidth and thus, there was a need for it.

 

Though this feature is not yet announced in Release Notes, but a separate settings page has been seen in recent version of Insiders Preview build, which we are going to discuss in this post.


Windows 10 preview build 16237 is now available, here's what's new

After the last Windows Insiders Preview build 16232, which was released on 28th June, Microsoft came up with a new build 16237 for the insiders. If you are in the fast ring, enjoy your weekend exploring the new improvements part of it.

 

This new build mainly focuses improvements to Microsoft Edge, Windows Shell including the Action Center, Emoji Panel, handwriting panel and many more.


Here's how to change Codelens Indicator style in Visual Studio

Code lens is a feature, first introduced in Visual Studio 2013, which helps you to understand important aspects about your code without leaving your favorite editor. It tells us the code changes in a fantastic way, within the code editor.

 

In this small tips & tricks post on Visual Studio, we will learn how to change the font and color settings of Code Lens.



Microsoft Word returns Error 800A175D - Could Not Open Macro Storage

If you are using Microsoft Word Automation or COM Components to read a MS Word document, you may notice the following error message for few word documents "Error 800A175D - Could Not Open Macro Storage".

 

This is caused by the user account, whose "user hive" is not loaded when Microsoft Word started. Continue reading to know more about the issue and solution.


Windows 10 Fall Creators Update to introduce Controlled folder access in Windows Defender

Along with Windows 10 Insiders Preview build 16232, Microsoft to introduce a new feature called 'Controlled folder access' in Windows 10 Fall Creators Update. This will make it easier for you to protect valuable data from malicious apps and threats.

 

In this post, we are going to preview this new feature that's going to introduce in Windows Defender in the next major build of Windows 10.


Windows 10 build 16232 released to PCs in Fast ring

A new Windows 10 PC build (16232) is now available to the fast ring insiders, along with Mobile Build 15228. This new PC build includes a no. of new security enhancements to Windows Defender, many other improvements and fixes.

 

Don't forget to read the 'Known Issues' first, before downloading as there is a possibility of update failure in this build.


A massive cyber attack named '#Petya' is spreading across the world

In a month of two, after the attack of 'WannaCry', a new Ransomware named 'Petya' started spreading across the world. It's a massive cyber attack that paralyzed firms, airports, banks and government departments that uses unpatched old Windows operating system.

 

Starting with Ukraine, it already spread many countries like UK, Spain and India. Check this post to know how to take precaution from such attacks.


Extracting text with iTextSharp throws an InvalidCastException

If you are using 'iTextSharp' library to read/write PDF files in your application and faced an InvalidCastException with the message "Unable to cast object of type 'iTextSharp.text.pdf.PdfLiteral' to type 'iTextSharp.text.pdf.PdfString'", this post will help you to know the root cause of the issue. Continue reading to learn more about it.


 
© 2008-2017 Kunal-Chowdhury.com - Microsoft Technology Blog for developers and consumers | Designed by Kunal Chowdhury
Back to top