VbNEt2008 Format Excel 2003 Spreadsheet cells
Hullo Friends,
I need your help. Please help me.
I am using VbNet2008 window application to transfer data from SQL SERVER table to Excel 2003 Spreadsheet.
The SQL SERVER table datatype is nvarchar : 00612 and when transfer to Excel spreadsheet cell it appeared at 612 instead of 00612. Also another SQLSERVER table data 0(934,21) appeared as (934,21) instead of 0(934,21)
Problem is how to format the spreadsheet cells ?
How's the coding looks like.
Please share with me. Thank You.
Cheers,
Lennie Kuah