Open csv file in Excel

There are many ways to open csv file in excel i.e Import export wizard etc.

Here is a simple ways which i generally use a lot

Open your csv file in notepad and tell the seperator type i.e

sep=;

This will tell Excel how to read csv file with seperator ..

Thats it !!!

 

 

Advertisements

Read custom Properties of an Excel Workbook

You can read the Custom properties of any office document (below is an example for Excel workbook)

using System.Reflection;
using System;

object GetExcelWorkbookPropertyValue(Microsoft.Office.Interop.Excel.Workbook workbook, string propertyName)
{
object builtInProperties =workbook.CustomDocumentProperties;
Type builtInPropertiesType = builtInProperties.GetType();

object property = builtInPropertiesType.InvokeMember(“Item”, BindingFlags.GetProperty, null, builtInProperties, new object[] { propertyName });
Type propertyType = property.GetType();
object propertyValue = propertyType.InvokeMember(“Value”, BindingFlags.GetProperty, null, property, new object[] { }); return propertyValue;

}

Hope this will help you….