I have created windows application in VB.Net for export excel functionality
from datatable.
For this I used "Interop.Excel.dll" and "Interop.Office.dll" and created
worksheet as below

Dim excelBook As Excel.Workbook = excelApp.Workbooks.Add



Dim excelWorksheet As Excel.Worksheet = CType(excelBook.Worksheets(1),
Excel.Worksheet).





For cntDs As Integer = 0 To dsExport.Tables.Count - 1




With excelWorksheet
.....
....




End With



Next

Its working fine. But once the data opened in the excel sheet (excel 2007),
if there is any number with leading zero (eg:00123), it will be truncated
which i dont want.

Even though if I change the format of excel sheet as text after loading the
data, the truncated zeros are not coming. Is there any property in excel 2007
to stop truncating leading zeros? Please advise.

Thanks in advance,
HR.