Parsing an excel file and reading a cell

Question

I got an excel file. I have uploaded the screenshot. I need to write a .NET application (console application) to parse the excel file. You can see a cell titled "Function Name". My .NET app should find that particular cell and read the contents in that column such as Template, InstanceFromTemplate, Task and so on. If it reads Task, it should call CreateTask function like Task(); If it reads InstanceFromTemplate, it should call InstanceFromTemplate function like TaskInstanceFromTemplate();

I have written code for those functions. I only need help on how to parse the excel sheet, go to that particular column, read the cells containing function names under that column and call that appropriate function. Any help would be appreciated.

Algorithm is like

open excel file
search for a header cell titled Function Name
Read the first cell under the header cell
If the first cell reads , call function (code for GetAllTemplate function is already there) Only need to call it afte finding it
If the second cell , call function.
Last cell under the header cell Function Name is reached. So, exit

COLD TOLD · Accepted Answer · 2012-06-15 05:04:24Z

4

Based on the Description on what you are trying to do you should really use LINQ to Ecxel plugin I think it simple way to solve your problem

http://code.google.com/p/linqtoexcel/

answered Jun 15, 2012 at 5:04

COLD TOLD

13.6k3 gold badges37 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kane Over a year ago

Nice, I didn't know of this library - will definitely use it in future projects. Thanks

leppie Over a year ago

I also only found this library during this week :)

Kane · Accepted Answer · 2012-06-15 05:05:18Z

4

I strongly suggest using a library like Excel Data Reader and work with the data in managed code. The CodePlex site has a good example of doing what you need.

answered Jun 15, 2012 at 5:05

Kane

16.8k11 gold badges67 silver badges95 bronze badges

Comments

jlnorsworthy · Accepted Answer · 2012-06-15 05:05:15Z

1

There are a handful of tutorials here that should get you started:

http://csharp.net-informations.com/excel/csharp-excel-tutorial.htm

answered Jun 15, 2012 at 5:05

jlnorsworthy

3,98231 silver badges35 bronze badges

Comments

Mana · Accepted Answer · 2015-07-08 10:25:05Z

1

Extra notes for future reference. Just wanted to point out that, working with interops are messy. Your best bet would be to use libraries.

answered Jul 8, 2015 at 10:25

Mana

1,9299 gold badges40 silver badges57 bronze badges

1 Comment

Mangesh Over a year ago

This should be a comment.

Francesco Baruchelli · Accepted Answer · 2012-06-15 06:22:31Z

Using Excel interop you can do it this way. I supposed that the function names are pointing to functions that are defined in your excel workbook, otherwise you have to change that part to use reflection (but in this case you'd need a receiver for the methods, and I don't see one in the question).

        object hmissing = System.Reflection.Missing.Value; 

        Xls.Application App = new Xls.ApplicationClass();
        App.Visible = true;
        Xls.Workbook wb = App.Workbooks.Open(@"c:\tmp\cartel1.xls", hmissing, hmissing, hmissing, hmissing, hmissing, hmissing,
            hmissing, hmissing, hmissing, hmissing, hmissing, hmissing, hmissing, hmissing);
        Xls.Worksheet ws = (Xls.Worksheet)wb.ActiveSheet;
        Xls.Range rng = ws.UsedRange;
        Xls.Range hdr = rng.Find("Function Name", hmissing, hmissing, hmissing, hmissing, Microsoft.Office.Interop.Excel.XlSearchDirection.xlNext, hmissing, hmissing, hmissing);
        string hdrAdd = hdr.get_Address(hmissing, hmissing, Microsoft.Office.Interop.Excel.XlReferenceStyle.xlA1, hmissing, hmissing);
        string[] pcs = hdrAdd.Split('$');
        string col = pcs[1];
        int row;
        int.TryParse(pcs[2], out row);
        string methName;
        row++;
        while ((methName = App.get_Range(col + row.ToString(), hmissing).get_Value(hmissing) as String) != null)
        {
            App.Run(methName.Split('.')[1], hmissing, hmissing, hmissing, hmissing, hmissing, hmissing, hmissing,
                hmissing, hmissing, hmissing, hmissing, hmissing, hmissing, hmissing, hmissing, hmissing, hmissing,
                hmissing, hmissing, hmissing, hmissing, hmissing, hmissing, hmissing, hmissing, hmissing, hmissing,
                hmissing, hmissing, hmissing);
            row++;
        }

Collectives™ on Stack Overflow

Parsing an excel file and reading a cell

5 Answers 5

2 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related