-
 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?
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
-
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?
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
-
<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.
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
-
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.
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
-
By sathya_k_83 in forum .NET
Replies: 12
Last Post: 03-09-2010, 09: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
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Reply With Quote
Bookmarks