Excel Text-to-Columns using VB.net

Question

I have an excel sheet with variable number of entries in the column A. Sample:

402110000027547  97517161579      IDLE              402-11-150
402110000013260  97517117011      IDLE              402-11-190
402110000033664  97517125759      IDET              402-11-21

I want to execute text-to-columns and put these values in separate columns (A, B, C & D). Any help is appreciated.

No. I am using some other code to populate an excel worksheet. So its an excel workbook we're talking about. — slyclam
– slyclam, Commented May 30, 2015 at 6:29

Pᴇʜ · Accepted Answer · 2020-02-11 12:32:00Z

2

I got it working using this code:

With sheet
        .Columns(1).TextToColumns( _
        Destination:=.Cells(1, 1), _
        DataType:=Excel.XlTextParsingType.xlDelimited, _
        TextQualifier:=Excel.XlTextQualifier.xlTextQualifierDoubleQuote, _
        ConsecutiveDelimiter:=False, _
        TAB:=False, _
        Semicolon:=False, _
        Comma:=False, _
        Space:=True, _
        Other:=False, _
        TrailingMinusNumbers:=False)
    End With

Thanks to this page http://www.siddharthrout.com/index.php/2018/06/28/excel-text-to-columns-from-vb-net/

edited Feb 11, 2020 at 12:32

Pᴇʜ

57.9k10 gold badges55 silver badges75 bronze badges

answered May 30, 2015 at 7:05

slyclam

2901 gold badge9 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Maheswaran Ravisankar Over a year ago

Self help is the best help! Good Luck!

Collectives™ on Stack Overflow

Excel Text-to-Columns using VB.net

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related