|
-
 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!
-
Welcome to DevX 
What are you using to open the sheet? VBScript? ASP? Something else?
-
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.
-
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?
-
<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.
-
This should help. 
-
Thank you again! but as i said earlier i want only data in the excel sheet to be displayed on web page.
-
I understand that, but first you need to open it, and that is what the link in my last post demonstrates.
Similar Threads
-
By sathya_k_83 in forum .NET
Replies: 12
Last Post: 03-09-2010, 10:51 AM
-
Replies: 2
Last Post: 08-16-2003, 11:02 AM
-
By fareeda in forum Database
Replies: 0
Last Post: 06-28-2002, 06:49 PM
-
Replies: 1
Last Post: 06-28-2002, 10:39 AM
-
By fareeda in forum Database
Replies: 0
Last Post: 06-26-2002, 03: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
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|
Reply With Quote
