OpenXML and opening a file in Read only mode

Posted by Anuraj on Tuesday, September 9, 2014

.Net .Net 4.0 ASP.Net Windows Forms

In one of my project, I am using OpenXML SDK for opening Excel files. Recently I got an issue like SpreadsheetDocument.Open() method was throwing an IOException, if the Excel file is opened by MS Excel, even if I set the isEditable parameter false.

Generate HTML file from XML using XSLT

Posted by Anuraj on Monday, August 25, 2014

.Net .Net 4.0 ASP.Net CodeProject Windows Forms

Recently I had to work on FxCop, for static code analysis. For those who don’t know what is FxCop, check this link. But one issue I faced was, the report can be saved / exported from FxCop is only in XML format. I searched for tool which help me to convert this XML to any other formats like HTML or doc, but I couldn’t find anything. :( Then I found FxCop comes with some XSL file, which help you to convert the FxCop generated XML to HTML. You can find these XSL files under - “C:\Program Files (x86)\Microsoft Fxcop 10.0\Xml” folder. And here is the code which helps to generate HTML using XML and XSLT.

"Remove and Sort" namespaces using shortcut in Visual Studio

Posted by Anuraj on Wednesday, August 6, 2014

.Net Visual Studio

If you are using StyleCop for maintaining C# coding standards and conventions, we used to do Remove and Sort namespaces feature from Visual Studio. The Organize Usings options in the Visual Studio integrated development environment (IDE) provide an easy way to sort and remove using and extern declarations without changing the behavior of the source code. Over time, source files may become bloated and difficult to read because of unnecessary and unorganized using directives. The Organize Usings options compact source code by removing unused using directives and improves readability by sorting them. I am huge fan of keyboard shortcuts, but by default VS did come with a keyboard shortcut for this feature. This post is about adding a keyboard shortcut to Remove and Sort.

Create Custom Configuration Sections in .Net

Posted by Anuraj on Tuesday, July 15, 2014

.Net .Net 3.0 / 3.5 .Net 4.0 ASP.Net ASP.Net MVC Visual Studio

This post is about creating custom configuration sections in .Net. If you search for this topic in internet, you will find lot of code snippets and blog posts(Here is the MSDN link). Unlike that, this post is about a nice tool, .NET Configuration Code Generator which will help you to generate code for you to create custom configuration section. It is a free, open source tool licensed under Apache License 2.0 (Apache).

Read Excel as DataTable using OpenXML and C#

Posted by Anuraj on Friday, July 11, 2014

.Net .Net 3.0 / 3.5 .Net 4.0 ASP.Net ASP.Net MVC

In the current project we were using OpenXML extensively for reading Excel files. Here is the code snippet, which will help you to read / convert Excel files to DataTable.

How to pass parameters to Work Flow

Posted by Anuraj on Wednesday, July 2, 2014

.Net ASP.Net WF Windows Forms

You can create arguments to workflow and can pass the values from outside. For creating arguments, you can use the Arguments Tab in the WorkFlow designer.

How to load WF workflows dynamically

Posted by Anuraj on Tuesday, July 1, 2014

.Net .Net 4.0 ASP.Net MVC WF Windows Forms WPF

This is post is about loading and running Workflow foundation (WF) XAML files. It is a powerful technique which can be used to change Workflows on the fly, without re-compiling the application. All this functionalities can be achieved via single line of code.
MVP
Subscribe


Copyright © 2017 - Anuraj P. Blog content licensed under the Creative Commons CC BY 2.5 | Unless otherwise stated or granted, code samples licensed under the MIT license. This is a personal blog. The opinions expressed here represent my own and not those of my employer. Hosted with ❤ by GitHub