calvinkwoo3000
New member
- Joined
- Apr 27, 2006
- Messages
- 2
- Programming Experience
- Beginner
I manage to read my excel data correctly,
How do i retain the spacing in between.
data in excel file = ABC DEF (3 spacing between ABC and DEF)
what i get = ABC DEF (remain 1 spacing be ABC and DEF)
*** I want ABC DEF (3 spacing in between)
my coding as below:
Dim oWS As Excel.Worksheet = DirectCast(oWBa.Worksheets(1), Excel.Worksheet)
oWS.Range("B" & i).Text // get ABC DEF
oWS.Range("B" & i).Value // get ABC DEF
oWS.Range("B" & i).Value2 // get ABC DEF
How do i retain the spacing in between.
data in excel file = ABC DEF (3 spacing between ABC and DEF)
what i get = ABC DEF (remain 1 spacing be ABC and DEF)
*** I want ABC DEF (3 spacing in between)
my coding as below:
Dim oWS As Excel.Worksheet = DirectCast(oWBa.Worksheets(1), Excel.Worksheet)
oWS.Range("B" & i).Text // get ABC DEF
oWS.Range("B" & i).Value // get ABC DEF
oWS.Range("B" & i).Value2 // get ABC DEF