ExcelSheet column type definition in VB.net

I am developing an appliction which queries the salesforce databse and exporting to excelsheet.

After exporting to excelsheet all the column values are in default type. It does not have any specific data type to a particular column.

How to define column type like integer, string, date programatically in VB.Net

Even In salesforce after generating the report, They used to export in excelsheet format.

But by default column values are formatted to text by contanetating the Single Quote ( ' ).

In front of some column values single quote( ' ) is concatanated to mention it as string.

How do define a single quote to a particular column programmatically in VB.Net. Can any body tell me the solution.

Sample code

-------------------

Private excelApp As Excel.Application

Private excelBook As Excel.Workbook

Private excelsheet As Excel.Worksheet

excelsheet.AutoFormat( ) will workout?

Thanks & Regards,

Arjun.

Need an account? Sign Up

Have an account? Sign In