Excel from ASP

Results 1 to 4 of 4

Thread: Excel from ASP

  1. #1
    krishna Guest

    Default Excel from ASP

    Have any one one know how to display Excel spread sheets from <BR>ASP pages ? <BR><BR>Please let me know ASAP! Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Excel from ASP

    you need to choose the MS Excel 3.0 Object Library and reference the Excel Application,Workbook & Worksheet to variables in ASP.<BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: Excel from ASP

    or:<BR>1 Make a dsn to the Excel spreadsheet. The Excel ODBC driver should be loaded; if not, update your MDAC.<BR>2 To get info out:<BR>"select * from `Sheet1$` where Sheet1 is the name of the worksheet (not the file), you must add the dollar sign and enclose in the ` located left of the number 1 on a QWERTY keyboard. You can reference the columns ordinally or by reference if the worksheet has headers<BR>

  4. #4
    Selvi Guest

    Default RE: Excel from ASP

    Hi,<BR><BR>try this one. This displays excel files in browser.<BR><BR> http://asptoday.com/articles/19991011.htm<BR><BR>Selvi.<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts