473,395 Members | 1,571 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Creating xls files on users pc

The MSDN KB article 189198
(http://support.microsoft.com/default.aspx?scid=kb;en-
us;189198) describes how to create a spreadsheet with info
from a database. Is there a way to create the spreadsheet
on the users computer instead of on the web server? I want
to prevent a whole lot of xls files from being created and
stored on the server.

Jul 19 '05 #1
2 1369
CJM
Create the XLS as described in the article, then stream it to the client.

http://www.darkfalz.com/Scripts_Details.aspx?pstID=1098

Chris

"Luis" <an****@webmail.co.za> wrote in message
news:1c****************************@phx.gbl...
The MSDN KB article 189198
(http://support.microsoft.com/default.aspx?scid=kb;en-
us;189198) describes how to create a spreadsheet with info
from a database. Is there a way to create the spreadsheet
on the users computer instead of on the web server? I want
to prevent a whole lot of xls files from being created and
stored on the server.

Jul 19 '05 #2
You can actually skipped the whole ADODB.Stream part as in this case the OP
doesn't want to create any files on the server. Just output an HTML table
and change the ContentType to Excel:

http://support.microsoft.com/?kbid=301044

--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsserv...y/centers/iis/
http://mvp.support.microsoft.com/
http://www.iisfaq.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://www.tryiis.com
"CJM" <cj*******@newsgroups.nospam> wrote in message
news:uU**************@TK2MSFTNGP09.phx.gbl...
Create the XLS as described in the article, then stream it to the client.

http://www.darkfalz.com/Scripts_Details.aspx?pstID=1098

Chris

"Luis" <an****@webmail.co.za> wrote in message
news:1c****************************@phx.gbl...
The MSDN KB article 189198
(http://support.microsoft.com/default.aspx?scid=kb;en-
us;189198) describes how to create a spreadsheet with info
from a database. Is there a way to create the spreadsheet
on the users computer instead of on the web server? I want
to prevent a whole lot of xls files from being created and
stored on the server.


Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Robin Tucker | last post by:
Hi there, I have a database on my test machine that will need to be installed on users machines. I would like to create the database with the given schema on the users machine and also with...
0
by: deploying visual basic .net application | last post by:
Hi There, I'm trying to create a setup for a Windows application to install my application I developed using Visual basic .net. I'm using Visual Studio .net Professional. When I use the Set up...
9
by: Maziar Aflatoun | last post by:
Hi everyone, I like to export some data from the database and allow my users to store this file to their harddrive as a .txt file. Does anyone know how I would go about doing that? (without...
5
by: Jerry Camel | last post by:
I'm trying to create a file depot that will hold files for 24 hours and then kill them. Basically a temporary place for people to post something that will automatically notify the person that it's...
15
by: David Thielen | last post by:
Hi; My ASP.NET app (C# calling J# under .net 2.0) creates a png file in a subdirectory to display as part of the created page. However, the bitmap will not display due to a security violation. ...
5
by: laredotornado | last post by:
Hi, I'm using PHP 4.3. There is a section of my application in which I'd like users to be able to download a custom file. The file would be different for each user, so I was planning on...
4
by: Coleen | last post by:
Hi All :-) I'm not sure where to post this, but my organization is looking for a good software application that is not terribly expensive that allows you to create documentationand help files and...
6
by: Pep | last post by:
Firstly, I'm not sure if this is the right group for this query, so please forgive me if I am wrong. My problem is that most users I distribute my software to cannot install it on their systems...
4
by: mopiforu | last post by:
HI, I am creating a web server in which user will upload a file, in my cgi script using the upload method i am getting the file handle and writing the file in my hard drive, later am using the...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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...
0
Oralloy
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,...
0
jinu1996
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...
0
tracyyun
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...
0
agi2029
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,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.