Export From Excel Into .txt file [C#]

Question

1.00/5 (2 votes)

See more:

Greetings

Dear members, I've been checking out on internet, however, i didn't a single similar question, so i thought to ask it, may come handy for someone else, so here i go:

I have this giant excel files with 2 columns and +800,000 rows, the process is like this:
I am Filtering based on the second column(so there are many similar data on second columns), then after filter, i copy the first column and paste it on a notepad file(.txt) and change its name to second's column filter.
[Summery]
Input: Excel File
Output: multiple .txt files

if i do this by hand would take hours and hours, so i thought maybe you can point me into a right direction, then rest i do myself.

Thank you in advance,

Posted 25-Aug-15 13:00pm

Member 11734067

Updated 25-Aug-15 14:14pm

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 25-Aug-15 19:30pm

The expression "Notepad File" is ridiculous. This is nearly the same as saying "Microsoft's letter 'M'". :-)
Why having Excel at all, if you want to work with text file?..
—SA

Member 11734067 25-Aug-15 20:14pm

Hey,
Well to be honest, i have lists of phone numbers and postal codes, as first and second columns, I'm trying to organize them, then upload them on my SQL Server, thought it would take ages to do it by myself, is it possible to write something in C# that can run it?
regards!

Sergey Alexandrovich Kryukov 25-Aug-15 21:19pm

You see, converting Excel from text would not be a problem, but them you will need to process the text. To me, it smells like non-engineering attempts to get around the dead-ends of a regular non-engineering user: putting data in Excel, manual work, all that stuff. Is it something like that? Then "conversion" is not a decent solution, half-measure...
—SA

Member 11734067 25-Aug-15 21:56pm

Well Thank you, although "conversion" about the details and insults is not a decent solution, indeed,

Anyone else have any solution, i am all yours,
regards.

Sergey Alexandrovich Kryukov 25-Aug-15 22:56pm

Well, well...
—SA

RedDk 25-Aug-15 22:10pm

If you're using Excel AND SQL Server, why not just save your spreadsheet as .csv and BULK LOAD the spreadsheet into it's own table? Operate on the data once in SQL Server.

I'm always inclined to get away from Excel when dealing with data. Excel is great for swapping columns of .txt files that are importable. But SQL Server is bristling with functionality datawise.

PIEBALDconsult 25-Aug-15 23:03pm

You can use SSIS to import Excel directly into SQL Server.

Wendelius 26-Aug-15 0:11am

If this is a one-time problem only, why build a program for it in the first place? Just filter the data and use File/Save as or copy to get the data to a text file...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Sergey Alexandrovich Kryukov · Answer 1 · 2015-08-25T16:56:00

You could find plentiful of information anywhere. For example, you could use Microsoft.Jet: https://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine[^].

Here is one of the code samples:
https://social.msdn.microsoft.com/Forums/vstudio/en-US/a6ceb8be-b633-4fff-88e0-1692206e2db2/c-excel-to-text-conversion[^].

[EDIT] Another approach is using Microsoft.Office.Interop.Excel, and one more would be using Microsoft Open XML SDK. You will find plenty of code samples. [END EDIT]

But I'll repeat: what you are going to do with the text? It looks to me as a non-engineering approach, the attempt of getting a little further from the user-level manual work. The mere fact that someone put the huge amount of data in Excel, office personnel's tool, tell the tail. Please, nothing personal. I could be mistaken here, but your attempt to play the "insult" card only confirms that. If I'm mistaken, just explain that. Anyway, you got the "solution".

—SA