Can Excek and HTML talk to each other?

M.L.

I'd like to know if a javascript technology exists that, given a set
of HTML files, would allow me extract cell data from a row in an Excel
or csv file and place it into specified variables within the html
template file. In other words, I'd like to substitute variables within
the HTML file with their corresponding cell/row data. Each row of
Excel data would correspond to a different HTML file.

example:

<html>
<head>
<meta...>
<title>...</title>
</head>
<body>
....
<p>The temperature is <c23> degrees.</p>
....
</body>
</html>

Where the <c23> tag would be replaced with the Excel cell data. Sort
of like a mailmerge between HTML and Excel. Any help appreciated.
Thanks in advance.

Jul 23 '05 #1

Subscribe Reply

1289

Danny

The easier way will be exporting the .xls to a .csv or .xml format, and
yes, is doable very easy, But not with js, is done server sided, PHP or
ASP or Perl can do all that on the server, preprocess it, and Then, serve
the ouput HTML file to the client, quite often done with many records of
all types, I think you can do it directly to an .xls through SQL ODBC
object accessing in PHP or ASP, but is done on the server.
Danny
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Jul 23 '05 #2

Tim Williams

You could use js to automate Excel and extract the relevant info from
an XL file, then write the HTML files to disk.

However, you'd probably be better served using VBA from Excel to do
the same thing.

Tim
"M.L." <me@privacy.net > wrote in message
news:d7******** *************** *********@4ax.c om...

I'd like to know if a javascript technology exists that, given a set
of HTML files, would allow me extract cell data from a row in an
Excel
or csv file and place it into specified variables within the html
template file. In other words, I'd like to substitute variables
within
the HTML file with their corresponding cell/row data. Each row of
Excel data would correspond to a different HTML file.

example:

<html>
<head>
<meta...>
<title>...</title>
</head>
<body>
...
<p>The temperature is <c23> degrees.</p>
...
</body>
</html>

Where the <c23> tag would be replaced with the Excel cell data. Sort
of like a mailmerge between HTML and Excel. Any help appreciated.
Thanks in advance.

Jul 23 '05 #3

Similar topics

5446

HTML & ALL Current Tools are really back to ASSEMBLY language, Whatever happend to Libraries/Functions/Reuse and highlevel stuff ?

by: Mel | last post by:

Are we going backwards ? (please excuse my spelling...) In my opinion an absolute YES ! Take a look at what we are doing ! we create TAGS, things like <H1> etc. and although there are tools (dreamweaver and the like), they are all at the lowest level of programming (something like assembly as oposed to C++ etc.). These tools create "brain-dead" developers that constantly have to plough through tons of tags to do the simplest thing. ...

HTML / CSS

2926

how to modify text in html form from python

by: Philippe C. Martin | last post by:

Hi, I am trying to change the data in a form field from python. The following code does not crash but has no effect as if "form" is just a copy of the original html form. Must I recreate the form order to do that ? My point is for the client to be able to re-read the modified data.

Python

3597

Help on HTML server control vs HTML control

by: serge calderara | last post by:

Dear all, I am new in asp.net and prepare myself for exam I still have dificulties to understand the difference between server control and HTML control. Okey things whcih are clear are the fact that for server control component , code is running on the server side. But if I take as example a Label. I place on a webform an HTM label control and a WebForm label control, I could see that properties are different for

ASP.NET

1013

Intellectual Property Talk at PyCon

by: VanL | last post by:

I will be presenting a talk at PyCon, "The Absolute Minimum an Open Source Developer Needs to Know About Intellectual Property." I want to tailor this talk so that it is interesting to as many attendees as possible. I am familiar with a lot of the internal divisions in the Free Software/Open Source community. My intent is not to advocate for or against any specific position, but rather to promote a common understanding and address...

Python

9522

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10448

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10003

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9046

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6784

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5440

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5566

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4114

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2922

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General