Excel Workbook in IE

Jerry J

I am sending Excel reports to web clients. Excel opens in internet explorer
displaying multiple sheets. It is pretty simple to do and works well. To do
it, a client clicks a link to an ASPX page that first generates Excel.htm
files (query string contains parameters for the specific reports) then uses
Response.Write() to stream and Excel workbook file back to the client. The
Workbook file, internally contains links to the Excel.htm files that were
just created.

The Excel workbook file that is sent back to the client looks similar to this:

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta name="Excel Workbook Frameset">
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Name of Sheet 1</x:Name>
<x:WorksheetSource HRef="sheet1.htm"/>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Work sheet 2</x:Name>
<x:WorksheetSource HRef="sheet2.htm"/>
</x:ExcelWorksheet>
</x:ExcelWorkbook>
</xml>
</head>
</html>
When IE receives the above HTML text (the workbook definition) excel
automatically looks for and retrieves sheet1.htm and sheet2.htm.

It all works great!

My problem is if there is more then one client hitting the server at the
same time. If this happens, then one of the clients might be trying to
generate the sheet.htm files when another one is retrieveing them. I would
have no problem using an Application.Lock if I could know when any one client
is done retrieving the files.

Can someone give me a solution?

I would appreciate it.

--
Jerry J

Nov 19 '05 #1

Subscribe Post Reply

3795

Marina

As soon as your page is done Response.Write 'ing, you should be able to
release the lock. After that it is traveling to the client's PC.

"Jerry J" <Je****@discussions.microsoft.com> wrote in message
news:4E**********************************@microsof t.com...

I am sending Excel reports to web clients. Excel opens in internet
explorer
displaying multiple sheets. It is pretty simple to do and works well. To
do
it, a client clicks a link to an ASPX page that first generates Excel.htm
files (query string contains parameters for the specific reports) then
uses
Response.Write() to stream and Excel workbook file back to the client.
The
Workbook file, internally contains links to the Excel.htm files that were
just created.

The Excel workbook file that is sent back to the client looks similar to
this:

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta name="Excel Workbook Frameset">
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 9">
<xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Name of Sheet 1</x:Name>
<x:WorksheetSource HRef="sheet1.htm"/>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Work sheet 2</x:Name>
<x:WorksheetSource HRef="sheet2.htm"/>
</x:ExcelWorksheet>
</x:ExcelWorkbook>
</xml>
</head>
</html>
When IE receives the above HTML text (the workbook definition) excel
automatically looks for and retrieves sheet1.htm and sheet2.htm.

It all works great!

My problem is if there is more then one client hitting the server at the
same time. If this happens, then one of the clients might be trying to
generate the sheet.htm files when another one is retrieveing them. I
would
have no problem using an Application.Lock if I could know when any one
client
is done retrieving the files.

Can someone give me a solution?

I would appreciate it.

--
Jerry J

Nov 19 '05 #2

by: Mr. Smith | last post by:

Hello all, My code can successfully open, write to, format and save several worksheets in a workbook then save it by a given name, close and quit excel. My problem is that if I try and do it...

Microsoft Access / VBA

reading from text file to excel file

by: mail2atulmehta | last post by:

Hi, I do not know if this is right place for this, but i need some help. I have a text file, whose values are seprated by a delimiter. I want to open this file in excel, ( not import it) . I have...

C / C++

C# Aplpication talking to Excel Add-In

by: Matthew Wieder | last post by:

I have the following requirements: Build a stand-alone C# application that asks the user to click in a cell in an Excel spreadsheet, and then displays the address of that cell in the C#...

C# / C Sharp

populate a excel sheet from text file

by: dgoel | last post by:

Hi, I Have a text file & I want to open it in excel sheet ( withou importing). I have written code for it, but it is not opening exce sheet. It opens the text file, but does not create a excel...

C# / C Sharp

Save each sheet in an Excel workbook to separate files

by: javzxp | last post by:

Hi I'd like to use C# to open an existing Excel workbook and save each worksheet it contains into a new Excel file. The name of each new Excel file should be the name of the worksheet copied...

C# / C Sharp

using EXCEL SHEET with ASP.NET

by: pmud | last post by:

Hi, I need to use an Excel Sheet in ASP.NET application so that the users can enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever the USER ENETRS needs to go to the...

ASP.NET

Excel

by: Sam | last post by:

Hi All, I posted this message few days ago. No one has answered so far. I just would like to know if it is possible to do or not. Even if you can not tell me how to do this, maybe you know which...

Visual Basic .NET

Excel automation???

by: Alain \Mbuna\ | last post by:

Hi everybody. In my program I have some data that is calculated after some input from the user. I have written some code that opens an Excel workbook, with 5 worksheets and the calculated data...

Visual Basic .NET

Python crash when trying to generate an Excel worksheet with VBA macros

by: dan_roman | last post by:

Hi, I developed a script with a nice interface in Tkinter that allows me to edit some formulas and to generate an Excel worksheet with VBA macros within it. The script runs perfectlly in Office...

Python

Using Excel With Python

by: liam_jones | last post by:

I'm very new to Python, well IronPython to precise, and have been having problems when using Excel. The problem I'm having is the closing of my Excel object. I'm able to successfully quit the...

Python

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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...

Windows Server

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

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,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Excel Workbook in IE

Similar topics