Kunal-Chowdhury.com - Microsoft Technology Blog for developers and consumers: Tips
Showing posts with label Tips. Show all posts
Showing posts with label Tips. Show all posts

Have you heard about StringCollection class in .NET?

StringCollection class is a spcialized collection type present in .NET Framework class libraries. The name itself represents it as a collection of strings. It exposes common methods and properties to manage string collection.

 

If you do not know about this class, in this post we are going learn about it's properties, methods and learn how to use it.



Solution for NPOI only supports BIFF8 format exception

In last few articles we have discussed about NPOI libraries for .NET. There could be some cases, while reading Excel files, you may get an exception with 'The supplied spreadsheet seems to be Excel 5.0/7.0 (BIFF5) format. POI only supports BIFF8 format' as message.

 

In this quick tip, we are going to discuss about this issue, the way to handle it and the way to read the same Excel workbook content.


Here's how to read Excel 95 or older document (XLS) using NPOI libraries

In the last two articles, we have learned how to use the NPOI library to read Excel 2007 (.xlsx) and Excel 97-2003 (.xls) file format. We have also discussed more about the APIs and shared the code snippet for you to understand it easily.

 

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


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.


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.



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.


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.



How to import favorites to Microsoft Edge on Windows 10?

Microsoft Edge on Windows 10 has a quick and simple settings page to import favorites and other data from different browsers like Google Chrome, Mozilla Firefox and Internet Explorer (IE). Based on the installed browsers list, it will provide you the option.

 

In this quick tip on Windows 10, we will learn how to import the information from other installed browsers. Do let me know, if this was helpful.


Email got stuck in Outbox folder? Check out this solution

This happens many time when the mail, that you are going to send, gets stuck in the Outbox folder of your favorite email client and provides you 'No Luck' to open/delete that email as it already started transmitting to the other side.

 

If you are one of such victim, here's a quick tip for you to easily stop transferring that mail, so that, you can open or delete it.


Affected by WannaCry ransomware? A decryptor tool is now available

You might have already heard about 'WannaCry' or 'WannaCrypt' ransomware which affected many outdated Windows system across the globe and demanded BitCoins worth $300 to decrypt the affected files. This was spread via a vulnerability on Windows system.

 

Though a fix was already given by Microsoft to safeguard the attack, but a tool to decrypt the affected PC has been recently published by security researchers.


Here's how to prevent unwanted software installation on Windows 10

If you are using 'Windows 10 Creators Update', you can now optionally block installation of any software on a PC, if it's not trusted by the Windows Store. Instead of a complete restriction, you can also warn the user.

 

If you are unaware of this new feature, let's go a step forward to learn how to configure your PC with this settings, provided that you are running Creators Update.


How to repair Microsoft Outlook data files using scanpst tool?

SCANPST.EXE is a Inbox Repair Tool for Microsoft Outlook to diagnose and repair errors in Outlook data file. If your Microsoft Outlook Data File (.pst and .ost) won’t open or if you suspect the file has been corrupted, use this tool to repair the file.

 

In this blog post, we will discuss how to repair the data files associated in your Microsoft Outlook client. Continue reading to learn about it.



ATTN: How to protect your system from #WannaCry #ransomware?

In last few days, you might have heard about 'WannaCry' or 'WannaCrypt' ransomware which spread affected many systems across the globe. This was spread like a worm by using the Windows SMB vulnerability, which was patched in March.

 

You might become a victim, if you are not running Windows 10 and not yet patched your system with all the security updates that Microsoft released.


ERROR: Attempting to open a Office file type that is blocked

When you try to open any office file documents created with an earlier version of Office applications like Word 95, Word 6.0 or Word 2, the file will open in 'Protected View' by default and the editing functions will be disabled.

 

Though it is not recommended, but if you face such issue and still want to open the document for editing, you can follow the steps mentioned here.


How to automatically free up space in Windows 10 Creators Update?

Windows 10 Creators Update can allow you to configure the system to automatically free up space by getting rid of files that you don't need. These are the files that resides in the temporary folder and in your recycle bin.

 

In this blog post, we are going to see how to configure your system to automatically free up those files. Continue reading more to learn it.


How to hide Windows 10 Settings pages with Creators Update?

Corporates some time needs to disable/hide few settings pages to block the users from changing the system settings. Windows 10 Creators Update provides the system admins to show/hide specific settings pages by tuning them in the Windows Group Policy Settings.

 

In this post, we will learn how to control the visibility of the pages. Before proceeding, make sure that you are an admin user.

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