Tips

Showing posts with label Tips. Show all posts

Let's continue our 'Back to Basics' series. It's often an interview question to get an idea of the basic knowledge of a candidate. This is one of the simple question that an interviewer may ask during an interview and you should also know this while writing your code.

 

In this post, we are again going to discuss on the basics and this time we will learn the difference between null string and empty string.

Published by on under .Net | C#

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.

Published by on under .Net | C#

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.

Published by on under .Net | C#

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.

Published by on under .Net | C#

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.

Published by on under .Net | C#

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.

Published by on under .Net | C#

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.

Published by on under Tips | Win10Tips

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.

Published by on under Tips | Visual Studio 2013

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.

Published by on under Microsoft Word | Office

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.

Published by on under Tips | Win10Tips

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.

Published by on under Petya | Ransomware

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.

Published by on under iTextSharp | PDF

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.

Published by on under Tips | Windows

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.

Published by on under Office | Outlook

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.

Published by on under Ransomware | Security

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.

Published by on under Tips | Windows

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.

Published by on under Office | Office 2013

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.

Published by on under Ransomware | Security

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.

Published by on under Office | Office 2013

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.

Published by on under Tips | Windows