How to read data from text file and write to excel in C#?
I have a text file with sample data as below:ACR Name1 Name2 Name3 Name4 Street HouseNo Street5 District PostalCode City Cty Rg PO Box POBoxPcd
1001124248 MEX LIMITED LEVEL 2 LOTEMAU CENTRE VAEA STR APIA AS
1001206457 LEADER COMPUTERS LTD PTY SKARRATT STREET NORTH 2128 SILVERWATER AU QLD
1001206533 QUEST POTTS POINT SPRINGFIELD AVE 15 5006 MASCOT AU NSW
1001211948 4D DOORS PTY LTD 95-97 WHITEHORSE ROAD 0000 BLACBURN AU VIC
1001213081 CLAY & CO ENGINEERS PTY LTD 40 PRINCES CHARLES PDE 2231 KURNELL AU NSW
1001225939 AZELIS AUSTRALIA PTY LTD C/O NORTHLINE 11 SHORT STREET 2164 SMITHFIELD AU NSW
1001209854 STEMCELL TECH AUSTRALIA PTY. LTD C/O LOGICAL FREIGHT SOLUTIONS 4 INTERNATIONAL SQUARE 3043 TULLAMARINE AU VIC
1001222543 AB KNITWEAR T/A MERINO GOLD 11 THOMAS ST 3056 BRUNSWICK AU VIC
1001213071 MURRAY RIVER ORGANICS PTY LTD LEVEL 1/360 LITTLE COLLINS ST 3000 MELBOURNE AU VIC
1001213075 G-STAR AUSTRALIA PTY LTD 3B VICTORIA STREET 2021 PADDINGTON AU NSW
1001211233 SCHMOLZ-BICKENBACH AUSTRALIA PTY.LTD. 800-808 PRINCES HIGHWAY 3171 SPRINGVALE AU VIC
1001225553 DUTY FREE STORE AUSTRALIA PYT. LTD KEITH SMITH AVE 2020 MASCOT AU
1001225554 AMUSE BEAUTY STUDIO T2 SYDNEY DOMESTIC TERM RPORT 2020 MASCOT AU
1001221462 HEINEMANN AUSTRALIA PTY LTD 1767 BOTANY ROAD 2019 BANKSMEADOW AU
I want the C# code to read the text file and write each row into an excel file.
So my output would be an excel.
Can anybody help me in this??