Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Web Programming > JavaScript > Javascript How-To
| Search | Today's Posts | Mark Forums Read
Javascript How-To Ask your "How do I do this with Javascript?" questions here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Javascript How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 4th, 2005, 05:12 AM
Friend of Wrox
 
Join Date: May 2004
Location: , , .
Posts: 212
Thanks: 0
Thanked 0 Times in 0 Posts
Default Return Data from Excel 97 Range into table

Hi Guys,

Is there any way to do this? I basically need the data from 12 cells (A1:B6) to be returned individually to cells in a table.

TIA
interrupt

__________________
\'sync\' <cr>
The name specified is not recognized as an internal or external command, operable program or batch file.
  #2 (permalink)  
Old March 4th, 2005, 05:39 AM
joefawcett's Avatar
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

Didn't you ask a similar question before, what's changed?

http://p2p.wrox.com/topic.asp?TOPIC_ID=20116


--

Joe (Microsoft MVP - XML)
  #3 (permalink)  
Old March 4th, 2005, 06:26 AM
Friend of Wrox
 
Join Date: May 2004
Location: , , .
Posts: 212
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The excel file will be on a network drive this time Joe, not sure if the code will change?

Thanks
interrupt

  #4 (permalink)  
Old March 4th, 2005, 07:14 AM
joefawcett's Avatar
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

Well you could use the same code and just use a UNC instead of a URL, you wouldn't use the saveRemoteFile function. Remember to escape backslashes if hardcoding the path, e.g a UNC of \\MyServer\MyShare\myFile.xls would be:
Code:
var FILE_UNC = "\\\\MyServer\\MyShare\\myFile.xls";
<snip/>
var oWB = oExcel.workbooks.open(FILE_UNC);
Most modern versions of Excel can cope with UNC syntax.



--

Joe (Microsoft MVP - XML)


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Excel XP and Excel 97 chiefouko Beginning VB 6 9 March 30th, 2007 03:32 AM
Displaying Excel data in a table badgolfer ASP.NET 1.0 and 1.1 Basics 6 January 6th, 2006 04:25 AM
Excel VBA: Select range of data and plot chart? xitu Excel VBA 1 December 23rd, 2003 04:21 AM
excel 97 & pivottable pilmart Excel VBA 1 November 18th, 2003 08:44 AM
Using Excel XP and Excel 97 chiefouko Excel VBA 3 August 27th, 2003 03:24 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.