How do I. iterate through excel cells using c#?

Question

0.00/5 (No votes)

See more:

, +

I need to know how to iterate through excel cells using C#.

I have a Data Table that I use to export data to an existing Excel file. I need to be able to search for values that only equal "tel:" and "email:". These values will only be in the second column in excel.

Here is my code sequence. Please let me know what I am doing wrong or if there is a better way.

C#

int rowNum = 1;

foreach (Microsoft.Office.Interop.Excel.Range cell in ws.Rows[rowNum, 2])
     {
         if (cell.Value = "tel:")
         {
        ws.Rows[rowNum].Delete();
         }
     }

Posted 24-Jun-15 6:44am

Member 11783760

Updated 24-Jun-15 9:35am

Abhishek Pant

v2

Add a Solution

Comments

Ralf Meier 24-Jun-15 14:09pm

Try to use Cells instead of Rows ...

Maciej Los 24-Jun-15 16:34pm

Issue description does not correspond to code sample. Please, be more specific and provide more details.

Larminces 11-Aug-15 4:36am

First regarding the DataTable, how exactly are you exporting it to excel file?
What I was thinking is if these cell value's ("tel:" and "email:") come from database then you could just ignore that DataTable's record when doing an export.
For example you can check out this article about both importing and exporting of DataTable into an Excel, it uses this .NET's excel library.

Second regarding the iteration, you can use the same library to read your excel file with C# and then do an intuitive iteration (just like you do with every other .NET's collection). Here is a diagram of the excel file's model on which you would do your iteration.

2 solutions

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)

Shashank Bisen · Answer 1 · 2015-06-25T00:48:00

here you go

pre requisite- Install AccessDatabaseEngine 2007 or 2007

try
{
string path; // your file path 

oledbConn =
    new OleDbConnection(
        @&amp;quot;Provider=Microsoft.ACE.OLEDB.12.0;Data Source=&amp;quot; + path
        + &amp;quot;;Extended Properties=&amp;#39;Excel 12.0;HDR=YES;IMEX=1;&amp;#39;;&amp;quot;);

oledbConn.Open();
var cmd = new OleDbCommand();

var ds = new DataSet();
cmd.Connection = oledbConn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = &amp;quot;SELEet1$]&amp;quot;; Name of sheet
var oleda = new OleDbDataAdapter(cmd);
oleda.Fill(ds);

foreach (DataRow row in ds.T??les[0].Rows)
{
    // TODO
}
catch (Exception ex)
{
    // log it
}
finally
{
    oledbConn.Close();
}

suresh shewale · Answer 2 · 2015-06-24T17:29:00

Solution 1

You can also use oledb to read/write cell by cell values instead of using interop(office component).

Posted 24-Jun-15 17:29pm

suresh shewale