Read EXCEL Files in ASP.NET

Posted on 2012-08-19
Last Modified: 2012-08-21
Hello Guys,
I need a best example for Reading content column wise and row by row.

And at the time of writing the data to excel file. Check the empty cell and fill it with record.

Question by:Manoj Patil
    LVL 69

    Expert Comment

    by:Éric Moreau
    my preferred method of handling Excel files (specially on web servers) is
    LVL 35

    Accepted Solution

    You can use NPOI and it is free:
    How to  read cells:

    Note: 1) You cannot use interop because it is COM based, check reasons here:
    2) Depending on size gembox have a limited free version.
    LVL 19

    Author Comment

    by:Manoj Patil
    What about SSIS (SQL Server 2008 Integration Services) ??
    Is this a better way to accomplish target. ?
    If yes the How can I do this on Web Server which support Dot Net Framework and SQL server?
    LVL 35

    Expert Comment

    by:Miguel Oz
    1) No, it is slower and more $$$ expensive than third party components like NPOI, etc. and besides your question is about reading an Excel file for consume in your application and then write back to Excel file. Right?
    2) No, for this particular task, it is the best way.
    LVL 19

    Author Closing Comment

    by:Manoj Patil
    Thanks for Clarification.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
    More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
    Viewers will learn how to customize the ribbon and quick access toolbar in Excel 2013.
    Viewers will learn how to find and create templates in Excel 2013.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now