[Geek] reading excel into a web form

    Date: 10/10/05 (Asp Dot Net)    Keywords: database, sql, web

    I have been told we need to make a feature that will
    allow the user to upload an excel spreadsheet (this
    will always be formatted in the same was) to the server
    then on postback link to the spreadsheet and read the
    information from specific cells out into a web form
    which can be checked before submission by web form
    to the sql server database.

    I've never done this before i am fairly sure that i
    can connected to a excel spreadsheet as a datasource
    *hopes with fingers crossed* but can i specify individual
    cells to write from? how difficult is to specify which
    worksheet your wanting information from etc

    I am going to look into it on the web later but if anyone
    has any ideas or has done something similar i'd very
    much appreciate any help with this, I did in the past
    have to attempt connecting to a excel sheet which
    didn't go well.

    Source: http://www.livejournal.com/community/aspdotnet/43534.html

« more confused || Nulls and SQL »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home