Click here to Skip to main content
13,864,351 members
Click here to Skip to main content
Add your own
alternative version


14 bookmarked
Posted 26 Jan 2010
Licenced CPOL

Text Parser Using Regex Method to Export Searched Text to Microsoft Excel

, 26 Jan 2010
Rate this:
Please Sign up or sign in to vote.
Parsing text file data to a Microsoft Excel database or formatted text file.



I have developed a method to parse text file data to Microsoft Excel database or a formatted text file. In the early stage of development, I decided to use C# because it would save me a lot of time and it's faster to develop with. This program helps anyone who knows Regular Expressions to search for specific text in an unformatted text file and place their search results in a table so that they are able to manipulate the data found after exporting it to Microsoft Excel. Therefore, I developed that I can put together to achieve a fully functional desktop program.

Enjoy. :)


These is a list of custom method/projects used to achieve this program functionality:

  • Extract - Reads data from the ListView and exports it to Microsoft Excel using COM plug-ins.
  • UListview -This is a custom ListView which you can alter and add controls and so forth to it.
  • Urlcombo - This is a custom combo box, but this project was meant for a browser.
  • Text2ExcelParser - This project is the GUI for the filterMitext project.

Using the Code

Extract function: Using Microsoft .NET headings, I simply used a foreach and for loop to read data from the ListView. Refer to the code snippet below:

// using Microsoft.Office.Interop.Excel;
worksheet.Name = reportName;

foreach (ColumnHeader columnHeader in listView.Columns)
    worksheet.Cells[1, columnHeader.Index + 1] = columnHeader.Text;    
    for (int i = 0; i < listView.Items.Count; i++)
        for (int j = 0; j < listView.Columns.Count; j++)
            worksheet.Cells[i + 2, j + 1] = 
    //Also, you can use the Windows System.Windows.Form.SaveFileDialog to achieve this.
    savefDlg.Filter = " Excel Text format|*.xls| Text |*.txt| All files |*.*";
    if (savefDlg.ShowDialog() == DialogResult.OK)
        list2txtfilename = savefDlg.FileName;
        this.Text = filename + " - FilterMiText Expresso";

Text2ExcelParser: This is the GUI for the project. I made a text editor with useful functions which you can use to easily edit text. Also, the parser function is built in.

This code snippet is really the back bone of the project. The algorithm is based on a Find/Search method, but I spiced it up so that the data found is extracted to the ListView. See the details below.

//Refer to parse Text Information region.
while (_shouldStop == false)
    if (FindFirst)
        FindFirst = false;
        regex1 = new Regex(First_urlComboBox.Text, 
        match1 = regex1.Match(richTextBox1.Text);
    }else if (!FindFirst)
        match1 = match1.NextMatch();
    if (match1.Success){
        lvi = new ListViewItem(new string[] {   
           match1.ToString() });  
        FindFirst = true;
        MessageBox.Show(String.Format("Finish Parsing {0} records in {1}", 
              UltimateListView1.Items.Count, stopWatch.Elapsed),
              Application.ProductName + " Complete :)", 
              MessageBoxButtons.OK, MessageBoxIcon.Information);

Points of Interest

This project is about developing ideas for parsing text to Excel. Feel free to add or upgrade this program because it may be useful. Enjoy :)


  • 2007-2009 project.


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


About the Author

Andre' Gardiner
Software Developer
Canada Canada
I'm fascinated about new technology and innovations.

You may also be interested in...


Comments and Discussions

GeneralMy vote of 5 Pin
Rory B6-Sep-12 8:57
memberRory B6-Sep-12 8:57 
GeneralIs it possible to... Pin
fairplay228428-Oct-10 19:18
memberfairplay228428-Oct-10 19:18 
GeneralRe: Is it possible to... Pin
Andre' Gardiner29-Oct-10 10:32
professionalAndre' Gardiner29-Oct-10 10:32 
GeneralRe: Is it possible to... Pin
fairplay228430-Oct-10 21:24
memberfairplay228430-Oct-10 21:24 
AnswerRe: Is it possible to... Pin
Andre' Gardiner15-Nov-10 11:34
professionalAndre' Gardiner15-Nov-10 11:34 
GeneralRe: Is it possible to... Pin
fairplay228417-Nov-10 1:00
memberfairplay228417-Nov-10 1:00 
GeneralMy vote of 5 Pin
deqa15-Jul-10 21:27
memberdeqa15-Jul-10 21:27 
GeneralRe: My vote of 5 Pin
Andre' Gardiner2-Aug-10 12:08
professionalAndre' Gardiner2-Aug-10 12:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web02 | 2.8.190214.1 | Last Updated 26 Jan 2010
Article Copyright 2010 by Andre' Gardiner
Everything else Copyright © CodeProject, 1999-2019
Layout: fixed | fluid