Extract from notepad to Excel sheet

Question

1.00/5 (1 vote)

See more:

VS2010

I have a text file like this::
Name Account Address
-----------------------------------
Abc 1234 London
Def 2345 Usa
Ghe 7890 Italy

I want this to export in excel using c# and each value will be in different cell..
Name,Account, Address will be heading for each column. And under that in each cell the corresponding values will come.

Posted 15-Jul-14 0:01am

JaideepChandra

Updated 15-Jul-14 0:07am

v2

Add a Solution

Comments

[no name] 15-Jul-14 6:22am

Okay.... this is your requirement for some task you need to do. It is not a question or a description of a problem.

ZurdoDev 15-Jul-14 7:19am

Where are you stuck?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-07-15T04:56:00

You can do it using ADO.NET[^].

Please, read these articles:
Accessing Microsoft Office Data from .NET Applications[^]
Much ADO About Text Files[^]
Schema.ini File (Text File Driver)[^]
Using OleDb to Import Text Files (tab, CSV, custom)[^]
Reading Comma Delimited Files[^]
Read Text File (txt, csv, log, tab, fixed length)[^]

Extract from notepad to Excel sheet

1 solution

Solution 1

Add your solution here

Preview 0

Extract from notepad to Excel sheet

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us