PDA

Click to See Complete Forum and Search --> : Display only selected items of a cell in an EXcel sheet on webpage

bhavanic
02-20-2008, 09:54 PM
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!
Hack
02-21-2008, 10:14 AM
Welcome to DevX :WAVE:

What are you using to open the sheet? VBScript? ASP? Something else?
bhavanic
02-21-2008, 12:41 PM
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.
Hack
02-21-2008, 12:43 PM
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?
bhavanic
02-21-2008, 10:05 PM
<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.
Hack
02-22-2008, 07:09 AM
This (http://support.microsoft.com/kb/q198703/) should help. :)
bhavanic
02-22-2008, 09:34 AM
Thank you again! but as i said earlier i want only data in the excel sheet to be displayed on web page.
Hack
02-22-2008, 09:42 AM
I understand that, but first you need to open it, and that is what the link in my last post demonstrates.