|
-
Apr 30th, 2013, 01:24 AM
#1
Thread Starter
New Member
Read Excel data with retain spacing between data
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|