Display only selected items of a cell in an EXcel sheet on webpage


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 8 of 8

Thread: Display only selected items of a cell in an EXcel sheet on webpage

  1. #1
    Join Date
    Feb 2008
    Posts
    4

    Question Display only selected items of a cell in an EXcel sheet on webpage

    Hello,

    I am new to this area, i wanted to know how do i display only selected letters from a cell( say first column in excel has names of people--- eg JOHN, i wanted to display only JO on the webpage) of an excel sheet on the web page.

    Please can anybody help, i badly need it!!

    Thanks in advance!

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Welcome to DevX

    What are you using to open the sheet? VBScript? ASP? Something else?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Feb 2008
    Posts
    4
    Thank you for the reply!

    I have to use VBScript, but iam not finding ways to display only data on the web page.
    Instead iam getting codes which opens excel sheet Which iam not intending to do.

  4. #4
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    Well, you can't get anything out of it unless you open it.

    You don't have to show it, but it does have to be open.

    Does the code you have to open it work?
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  5. #5
    Join Date
    Feb 2008
    Posts
    4
    <html>
    <script language=VBscript>
    Dim objExcel,workbook

    Set objExcel = CreateObject("Excel.Application")


    Set workbook = objExcel.Workbooks.Open( "c:\product-performance-2006.xls")
    </Script>
    </html>

    This is what i tried! can you please tell me how to read and display on webpage! can u just provide me with code if possible.

  6. #6
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    This should help.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  7. #7
    Join Date
    Feb 2008
    Posts
    4
    Thank you again! but as i said earlier i want only data in the excel sheet to be displayed on web page.

  8. #8
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    I understand that, but first you need to open it, and that is what the link in my last post demonstrates.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

Similar Threads

  1. Replies: 12
    Last Post: 03-09-2010, 10:51 AM
  2. Replies: 2
    Last Post: 08-16-2003, 12:02 PM
  3. Replies: 0
    Last Post: 06-28-2002, 07:49 PM
  4. Replies: 1
    Last Post: 06-28-2002, 11:39 AM
  5. display excel charts on a webpage
    By fareeda in forum Database
    Replies: 0
    Last Post: 06-26-2002, 04:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center