I need to write a program that can create an excel file and copy all the data obtains from a database to the excel file. Then save and close the excel file or do all of the above in the backgroud. if you have written similar program or know where I can find the sample code for this feature.
View RepliesI'm trying to create a excel file from set of data. actually I'm using ASP + JScript.
I'm glad to hear your oppinion.
I want to place a Excel workbook on the web server and create a URL
link to it and when the user clicks on it to the URL/vbscript behind
it must launch Excel on the client and open the URL linked Excel
workbook automatically.
Can you please share the code HTMl & VB script snippet that can do
this.
One of my programmers is using Office Web Components in classic ASP to create, fill and format an Excel spreadsheet. Everything is fine except when he creates Merged cells the performance drops dramatically. He has investigated the 'Center Across Cells' alternative but cannot get it working
using Office Web Comonents.
Has anyone come across this problem or even better has a solution?
It works if the file in on the server side, how to use the component (DSOleFile) with the file on the client side? Also how can I calculate the width of the file. (Page set up - Landscape or porrait). Code:
View Replies View RelatedI'd like to create ASP file on ther server side. Can I use
fso.createtextfile("c:folder est.asp")
Do I need to create a folder too?
is it possible to create a xml file and save so that i can upload with asp?
View Replies View RelatedHow can I simply save some data into a flat file (.txt) ? I've some data available and if the user clicks on a button it will save that data into the flat file... The user also need to define the directory (as in VB the common dialog box)...
Is this possible ???
I have Windows 2000 and recently included Internet Information Services. I
then created a simple ASP file and clicked on it. The Open With dialog
appears asking me to select a program. I copied an existing ASP file,
test.ASP from another computer where it runs successfully. When I copied it
to my computer it changed to test.ASP auto file. The other computer runs
Windows XP. I am not sure is this is the issue. I verified the IIS is up
and running on my computer. Is there anything that can be done to correct
this?
I am using ASP code to create a Word document on the server and all is working except for one thing: I need to be able to insert page breaks. My existing style formatting for page breaks does not seem to insert a page break into the Word DOC. Suggestions? Code:
View Replies View RelatedI was wondering if it is possible to create an sql file using asp to back up a tables contents at all?basically I want to make a copy of each table we have on the server into an SQL file so we can move it elsewhere, the server techs want to charge us for the backup copy so I want to get around paying if possible.
View Replies View Relatedi'm using window XP (hope this is not the reason) i cant create a file in my computer but it works on my school server
**********************************************
Set fso = Server.CreateObject("Scripting.FileSystemObject")
Set OutputXMLFile = fso.CreateTextFile("c:xx.htm",true)
**********************************************
everytime i run this method my IE hang(???) so, is it my IIS configuration problem or else.
I want to create pdf file for reports using asp code.
View Replies View RelatedI know this is a lot to ask but if you have time please have a look and see if you can figure out why the following page to create a new ASP page on the fly seems to work but the output page doesn't seem to be there: Code:
View Replies View RelatedSo, is there anyone can post sample code which cab generate the invoice, also it can be viewed by PDF file online.
View Replies View Relatedis it possible to create and asp page that can. zip a file and ate the same time unzip it.
View Replies View RelatedIn Outlook Express, we could schedule event reminder on the calendar. I have seen people doing this on their web site, where they have a list of events and a "Add to my calendar" link to let user to click on. When the link is clicked, the Outlook calendar will pop up with all the event's information in it. Then I can save that event to my Outlook calendar.
I want to give this ability to the people browsing my web site to add our events to their Outlook calendar.
if this was possible to have the users able to create a file into your webroot.
View Replies View Relatedthis is simple script
<%
set fs = CreateObject("Scriptpting.FileSystemObject")
With fs
Set xxx = fs.createfolder("some directory")
End With
Set fs = Nothing
%>
ntfs security all is normal
my problem is next. i have installed Norton Internet Security, and when Norton Internet security is installed then i cant create files using asp scripts in Interet Explorer. how can i create files using asp script trough internet explorer?
I have a stored procedure that creates XML content the way I want it using FOR XML AUTO, ELEMENTS. At least when I run the query anyway. What I want is to use that SP in an ASP page. When opened, I want a dialog box to pop upwith the option to open or save as... to the client's HDD. Here's my header for the page. The recordset is below that. When I open the page, I get the Save As. I want, but no records are saved.
What I'm missing is how to deal with XML and the recordset thereof. It's more of a feed that a recordset. How do I get that feed into a file on the client machine?
<% Response.contenttype = "application/vnd.xml" %>
<% Response.AddHeader "Content-Disposition", "filename=Product.xml" %> .
I have an ASP process that creates 'reports'. At the moment these reports are output to a semi-comma delimmeted text file that I open in XLS. I then run a macro that formats the page correctly for printing.
What I would really like to happen is the ASP page creates either an XLS of ..DOC file that would open in excel (or word) with the contents pre-formatted ready to print. I have been looking, but have been unable to find anything suitable on this. Could someone out there point me in the right direction.
I have a page that creates an xls file based on a field entered from a database recordset. Works great.
I want another one that creates an xls file of all the records in the database by simply clicking a button, then automatically offers the xls file for download. Probably Response.Redirect, but I don't really know the syntax used with that. Code:
I have a script in ASP 3.0 which creates a CSV file on the server. After the
code has run I want it to prompt the user to download the file (via the
browser). I have spent a frustrating hour trying this.
I have uploaded files to a SQL Server DB using Pure ASP Upload, and that was a snap, but what I would like to do is create a link in my recordset from the file name in the database to the actual file that resides in a folder in the database so that when a user clicks on the link, the file will open.
I've done this successfully using another program but it used an ACCESS DB and I want to use it with SQL Server. Plus the ACCESS DB used a field with a data type of Binary.
im creating an asp using the file scripting object but i cant create the file in the local pf of the client, but rather saves on the server folder.
View Replies View RelatedI'm generating one report using ASP file in MS-Excel file. How to take the same report in PDF format.
View Replies View RelatedI need to convert a jpg files sequence (001.jpg, 002.jpg, ... etc.), stored in a directory, to a mpeg file using some programming language. Does anybody know how to do it?
View Replies View RelatedHow to create a text file on other computer in the network by using CreateTextFile method? Using the following code, I cannot create a file. Set fileObj=Server.CreateObject("Scripting.FileSystemObject") set file=fileObj.CreateTextFile("(computer name in the network)asp esting.txt") .
View Replies View RelatedI need to be able to generate/create a html file. I know that probably the best way to do it would be to use PHP or CGI, but my server doesn't support either. Is there a way (and can you point me in the direction of some help) of doing it using ASP?
View Replies View RelatedI have a script that will compact an Access MDB and a copy to a new folder. I would it to give each export a unique file name. I can do this with an absolute file reference but I am struggling to create one using 'Server.MapPath'.
View Replies View RelatedWhat options/methos/properties/functions/objects do I have in order to
create a Function in ASP/VBScript that process/create binary data as an image
file type?
The Function is supoosed to get 2 parameters:
1. The file image content type defined as "image/bmp" , strContentType
2. the file binary data, binDataImageBytes (which is stored in session
vars)
The Function should return/create an Image File , for instance
~tmpImg.BMP
My Question is
How to create a binary Image file type from the session var binary
data ?
I want to Convert Excel Files to CSV files using ASP code CanAny body help me out in this.
View Replies View Relatedi have some difficulty in creating text file, my question is that how can i create a text file on any website through ASP.
View Replies View Related