i am transferring data from a vb.net datagridview control to a new instance
of excel (early binding)
here i am creating a excel instance
here i am formatting the cells & transferring datavb.net Code:
Dim Exl_App As New Microsoft.Office.Interop.Excel.Application Dim Exl_Wbook As Workbook Exl_Wbook = Exl_App.Workbooks.Add Dim Exl_Sheet As Worksheet Dim ExL_Sheet2 As Worksheet
vb.net Code:
.Range("e1:e65000").Cells.NumberFormat = "Text" .Range("g1:g65000").Cells.NumberFormat = "Text" .Range("h1:h65000").Cells.NumberFormat = "Text" .Range("i1:i65000").Cells.NumberFormat = "Text"
but the out put in the excel file is (please refer to the attachment sheet2)
the date type data out put is appearing like
what is wrong i am doing here pleaseCode:T2011xt T2011xt T2011xt




Reply With Quote