How to Read Data and Find Specific Email Formats in Excel Files Using C#?

Extracting and Validating Email Addresses from Excel with C#

This guide demonstrates how to read data from Excel files using C#, focusing on efficiently extracting and validating email addresses. The process involves opening the Excel file, iterating through cells to find email addresses, and verifying their format.

Accessing the Excel File:

The provided code snippet uses Excel.Workbooks.Open to open the Excel file. For optimal performance and resource management, ensure you specify read-only access and handle potential errors:

<code class="language-csharp">string filePath = s.Text; // Replace 's.Text' with your file path.
try
{
    Excel.Workbook workbook = ExcelObj.Workbooks.Open(filePath, ReadOnly: true, UpdateLinks: false);
    // ... further processing ...
}
catch (Exception ex)
{
    // Handle exceptions, such as file not found or access denied.
    Console.WriteLine($"Error opening Excel file: {ex.Message}");
}</code>

Locating and Extracting Email Addresses:

To efficiently locate email addresses, iterate through the UsedRange of each worksheet. Regular expressions provide a robust way to validate email formats:

<code class="language-csharp">using System.Text.RegularExpressions;

// ... (previous code) ...

foreach (Excel.Worksheet worksheet in workbook.Worksheets)
{
    foreach (Excel.Range cell in worksheet.UsedRange)
    {
        string cellValue = cell.Value2?.ToString();
        if (!string.IsNullOrEmpty(cellValue))
        {
            // Regular expression for email validation (adjust as needed)
            string emailRegex = @"\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b";
            Match match = Regex.Match(cellValue, emailRegex);
            if (match.Success)
            {
                string emailAddress = match.Value;
                // Process the validated email address
                Console.WriteLine($"Found email: {emailAddress}");
            }
        }
    }
}

// ... (rest of the code) ...</code>

Efficient Data Handling and Cleanup:

The Value2 property provides the raw cell value, avoiding potential formatting issues. Remember to properly dispose of Excel objects to prevent resource leaks:

<code class="language-csharp">// ... (previous code) ...

workbook.Close(SaveChanges: false); // Close without saving changes.
ExcelObj.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelObj);
workbook = null;
ExcelObj = null;
GC.Collect(); // Force garbage collection.</code>

Alternative Approaches:

While this method uses the Excel COM object, consider alternatives like EPPlus or ClosedXML for improved performance and reduced dependencies, especially when dealing with large files. These libraries offer a more managed approach to Excel manipulation.

This refined approach combines efficient data extraction with robust email validation and proper resource management, making it a more reliable and scalable solution. Remember to adjust the regular expression to match your specific email address requirements.

The above is the detailed content of How to Read Data and Find Specific Email Formats in Excel Files Using C#?. For more information, please follow other related articles on the PHP Chinese website!