Upload Excel file and extract data - asp.net mvc 3

Question

I am wondering how do I extract data out of a 2007 excel file? I am using asp.net mvc 3. My plan is to have a upload section that you choose a file and hit upload. I have no clue after that what kind of format it will be or what I need to do to extract the values out.

Thanks

Matt · Accepted Answer · 2011-02-22 18:43:32Z

12

Once you have the spreadsheet uploaded and you save it to a file on the web server it is quite easy to use LINQ to select the rows from the spreadsheet. Check this out for more info.

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

answered Feb 22, 2011 at 18:43

Matt

1362 bronze badges

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

1 Comment

Kevin LaBranche Over a year ago

Super easy to use and has a nuget package as well.

Sean Hunter · Accepted Answer · 2012-12-13 03:50:02Z

4

The easiest way to read excel spread sheets IMO is to use a DataAdapter and an OleDB connection as shown in this code project sample. The good thing about this is it does not have any dependencies on COM or the MS office libraries.

edited Dec 13, 2012 at 3:50

answered Feb 21, 2011 at 3:55

Sean Hunter

1,0518 silver badges19 bronze badges

Comments

Tom Vervoort · Accepted Answer · 2011-02-21 07:41:04Z

3

For reading Excel files, I learned to love Koogra. It's an open source library that reads both xls and xlsx files, and is very easy to use.

http://sourceforge.net/projects/koogra/

answered Feb 21, 2011 at 7:41

Tom Vervoort

5,1182 gold badges24 silver badges19 bronze badges

Comments

LeftyX · Accepted Answer · 2011-02-21 11:23:34Z

1

I've used NPOI and it's quite simple to use:

Using Xlfile As FileStream = New FileStream(FileName, FileMode.Open, FileAccess.Read)
    Using XLBook As HSSFWorkbook = New HSSFWorkbook(Xlfile)
        Using XLSheet As NPOI.SS.UserModel.Sheet = XLBook.GetSheetAt(0)

            Dim CurrentRow As NPOI.HSSF.UserModel.HSSFRow
                        Dim CurrentCell As NPOI.SS.UserModel.Cell
                        Dim RowEnum As IEnumerator = XLSheet.GetRowEnumerator()

            While RowEnum.MoveNext
                          If (RowEnum.Current IsNot Nothing) Then
                              CurrentRow = TryCast(RowEnum.Current, NPOI.HSSF.UserModel.HSSFRow)
                    Select Case CurrentCell.CellType
                        Case NPOI.SS.UserModel.CellType.STRING
                            ' CurrentCell.StringCellValue
                        Case NPOI.SS.UserModel.CellType.NUMERIC
                            ' CurrentCell.NumericCellValue.ToString()
                    End Select
            End While
        End Using
    End Using
    Xlfile.Close()
End Using

answered Feb 21, 2011 at 11:23

LeftyX

35.6k21 gold badges140 silver badges201 bronze badges

4 Comments

chobo2 Over a year ago

I was looking at and found something called "Excel package" excelpackage.codeplex.com do you know if they still develop this?

LeftyX Over a year ago

@chobo2: Yes, I had tried that one a couple of years ago but then I've given up cause it seems that the project has been abandoned. I would suggest you to try NPOI cause it's really simple and it works. I reads and writes all excel versions.

Pankaj Agarwal Over a year ago

@LeftyX: Is there is any way in NPOI to get all charts in excel sheet.

LeftyX Over a year ago

@PankajAgarwal: I am afraid I can't help. Have never done anything like that. I would suggest you to open a new question, anyway.

Collectives™ on Stack Overflow

Upload Excel file and extract data - asp.net mvc 3

4 Answers 4

1 Comment

Comments

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related