Question Reading Excel data with retain the spacing

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
 
Back
Top