Developer Publish

Tuesday, 10th December 2019
  • Twitter
  • Facebook
  • Google+
  • RSS
  • Home
  • C#
  • Visual Studio
  • Shoutout
  • How To
  • Books
  • Contact Us

Tag Archives: how to

How to Convert an Image to Byte Array in C# ?

November 4, 2016 no comments
You can convert an Bitmap image to byte array in C# using the  BinaryReader’s ReadByte method. Here are the steps that you need to follow for the conversion. – Create an instance of the Fi...

How to insert the current file name in a cell in Microsoft Excel ?

November 3, 2016 no comments
Assume that you want to display the name of the current file in a cell of your worksheet , you can easily do it using the formulas in Microsoft Excel 2016. How to insert the current file name in a ce...

How to add additional authors to the Excel Workbook in Excel 2016 ?

November 2, 2016 no comments
There are scenarios where you might want to add more than one author names for a Workbook in Excel. You can do that easily in Microsoft Excel by using the Related People options. How to add additiona...

How to insert the Current file path to a Cell in Microsoft Excel ?

November 2, 2016 no comments
Do you want to insert the current excel workbook’s file path in to a cell in Microsoft Excel ?. You can use the formula to perform this. How to insert the Current file path to a Cell in Microsoft Exc...

How to limit entries to numeric value in Microsoft Excel ?

October 31, 2016 no comments
There are times when you might want to control what data the user can enter to a cell. For example , you want the user to enter only a numeric value that is greater than 75. How to limit entries to n...

Finding the nearest value in Microsoft Excel

October 30, 2016 no comments
Assume that you have a range of numbers in a column and you are required to find out the nearest value or the closest value to the specified number from the range. How to find the nearest value in Mi...

How to get the Created Time and Last Modified Time of your Excel Workb...

October 26, 2016 no comments
Do you want to retreive the created time and the last modified time of your Excel workbook and display it in the excel sheet ? Here’s a code snippet demonstrating how you can display them in th...

Removing Non numeric characters from cell in Microsoft Excel using VBA...

October 26, 2016 no comments
This blog will demonstrate how to remove the non numeric characters from the cell in Microsoft Excel 2016. Assume that you have a worksheet where a cells from the range “A1:D30” contains the alpha-nu...

How to Export Excel data as HTML in Microsoft Excel 2016?

October 21, 2016 no comments
There are times when you might need to export the excel data to a HTML web page and its pretty easy to do it with Microsoft Excel 2016. How to Export Excel data as HTML in Microsoft Excel 2016? You c...

Inserting the color coded drop-down list in Microsoft Excel

October 21, 2016 no comments
There are times when you have to NOT just create or insert a drop-down list in Microsoft Excel sheet but also color code the value so that when the user selects a value from the drop-down list , the ...
« Previous 1 2 3 4 5 6 7 … 20 Next »

Popular Posts

1

How to install Windows 10 Technical Preview on Mic...

Oct 2, 2014 10
2

How to try C# 6.0 and Rosyln ?

Jan 3, 2015 6
3

Telerik Sample Apps, Resources and Giveaways for W...

Mar 21, 2012 5
4

Exception Filters in C# 6.0

Mar 16, 2015 5
5

Lambda Expression for Function Members in C# 6.0

Jan 4, 2015 5

Recent Posts

Json.NET How to #2 – Convert a simple JSON string to C...
Delphi Community Edition free for download.

If you are a seasonal delphi or objective pascal developer and would like to try the new Embarcadero Delphi version free , then you can use the Delphi Community Edition. Delphi Community Edition is a free version for hobby programmers or small compan... Delphi Community Edition free for download.

Fix – Sqllib error: OLEDB Error encountered calling ID...

Are you facing the below error in SQL Server and looking for a fix ? Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17 Here’s a simple fix that worked for me. Navigate to...

Fix – Sqllib error: OLEDB Error encountered calling ID...
SQL Server – Shortcut to display the Stored procedure ...

Are you looking at displaying the stored procedure code quickly with-in your SQL Server Management Studio ?. Here’s how you do it. How to display SP Code in SQL Server Management Studio ? Open SQL Management Studio and connect to the server. 1....

How to Convert a string to Title Case in C# ?

Assume that you have a string in C# and you want to have a mixture of both the upper case and the lowercase (i meant TitleCase in this example). You can do that easily using the ToTitleCase method defined in the TextInfo class. How to Convert a strin... How to Convert a string to Title Case in C# ?

Categories

  • Alternatives
  • Android
  • ASP.NET
  • Azure
  • Books
  • C#
  • Devices
  • Downloads
  • Events
  • Excel
  • F#
  • GiveAways
  • How To
  • JavaScript
  • Json.NET
  • Microsoft Office
  • OutSystems
  • Oxygene
  • Shoutout
  • SQL Server
  • Telerik
  • Trivia
  • Uncategorized
  • UWP
  • Videos
  • Visual Studio
  • Web
  • Windows
  • Windows Phone
  • Windows Store App
  • Xamarin
  • XAML

Archives

Recent Comments

  • jonathan warne on How to delete all hidden rows or columns in Microsoft Excel 2016 ?
  • Husker on How to delete all hidden rows or columns in Microsoft Excel 2016 ?
  • G on How to delete all hidden rows or columns in Microsoft Excel 2016 ?
  • Anthony Siciliano on How to limit the number of characters in a cell in Excel?
  • Jeff on How to Hide the comment indicators in Microsoft Excel 2016 ?
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Subscribe

  • RSS Feed
  • Twitter
  • LinkedIn
  • Skype
  • Email
  • reddit
  • Subscribe via Email

Featured Posts

  • Json.NET How to #2 – Convert a simple JSON string to C...

  • Delphi Community Edition free for download.

  • Fix – Sqllib error: OLEDB Error encountered calling ID...

  • SQL Server – Shortcut to display the Stored procedure ...

  • How to Convert a string to Title Case in C# ?

  • SQL Function to make all TEXT to propercase in SQL Server

Ads

Recent Posts

  • Json.NET How to #2 – Convert a simple JSON string to C# object and vice versa.
  • Delphi Community Edition free for download.
  • Fix – Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17
  • SQL Server – Shortcut to display the Stored procedure Code
  • How to Convert a string to Title Case in C# ?
  • SQL Function to make all TEXT to propercase in SQL Server
  • Fix for error CS0656: Missing compiler required member ‘Microsoft.CSharp.RuntimeBinder.CSharpArgumentInfo.Create’
  • How to build C# objects dynamically ?
  • Search for Domain Names easily with the Lean Domain Search Generator for Your Website
  • How to find if string contains another string in Outsystems ?

Contact

©2016 Developer Publish