In office web components u can use Excel through web with almost the same functionality. I have an emergency in finding out if it is possible in asp to save the changes u make to the spreadsheet though web to the original file in the web server.
View RepliesOne 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?
some good detailed documentation (with examples) on programing OWC (Spreadsheet, Pivot Table and Chart controls) using ASP 3.0?
View Replies View RelatedHow do i upload excel files to the server from the client browser without using any third party components. My server runs on NT server. And I am coding in ASP( Vbscript).
View Replies View RelatedI have a dynamically-generated asp web page which uses Office Web Components
to display an Excel bar chart of the user-selected data. The page works
fine, but the users would like to copy-n-paste the displayed bar chart from
the web page and insert it into an email (MS Outlook) or report (MS Word or
MS PowerPoint).
Is there any way of supporting this copy/paste functionality? When you
right-click on the chart in the displayed web page (viewed with MSIE6), you
are only given the pop-up button [About...] which displays the "About
Microsoft Office Web Components" splash window ("Version 9.0.0.8028 SP-3"
etc.)
Currently, the only work-around is to "Print-Screen", trim using Paint, and
then paste into the destination. This is too tedious and beyond the
capabilities of some of the users.
After a user make the search, it returns 100 rows of record on the display page. I want to give an option for the user to save the records as Excel spreadsheet. Like a small icon on the corner, it prompts to save if click.Can anyone teach me how to do it? or have a simple tutorial or code that i can see?
View Replies View RelatedI've got a simple recordset which writes a html table. I've put the following code at the top of my asp page:Code:
response.ContentType = "application/vnd.ms-excel"
response.AddHeader "content-disposition", "inline; filename=filename.xls"
...then done a response.write to write the table.
This should output an Excel file, but it doesn't? It just writes the table to my browser as a standard HTML page. Can anyone see how to solve this problem?
Im creating an Excel file using ASP
Versions : Office 97
The formattting is not working properly in Excel 97, but the same works fine
in Office XP & 2000
Is there any additional code has to be added in my code to get a formatted
output in Excel 97 version?
Since I updated Office 2000 to SP3, my ASP code has failed when executing this function:
(the HPageBreaks.Add line fails)
function insertPageBreak ( xlsObject, strLocation )
with xlsObject
.Range( strLocation ).Select
.ActiveWindow.SelectedSheets.HPageBreaks.Add .Range( strLocation )
end with
end function
Parameters:
xlsObject is a valid object of excel created with:
Set xls = CreateObject("Excel.Application")
strLocation is a string in the form "Axx" where xx is the current row number, e.g. "A54"
I had to uninstall and reinstall Office 2000 without service pack 3 in order for it to work....
I have to allow users to download files after checking users validity and I
cannot give full URL of file to download e.g www.myserver.com/mydoc.doc
I have seen ASP code some where in MSDN where users has to enter URL like
www.myserver.com/mydoc.asp and this will download the doc file.
i want to save asp created records to excel sheet by clicking a link.
link should be in same asp created page .By clicking link ,the populated asp records to be saved like save as option..At the same time i want to see asp records in html format .By clicking the link.
I would like to open existent excel file and save it via ASP, I have to create save button to save opened excel cause I afraid that my user don't know path of saving. How can I do, now I open excel file on IE by <iFrame> and want to get data in <iframe> to save as excel file.
View Replies View RelatedI am developing my application in ASP and there is a requirement to save the output in Excel. One option is to use Content-Disposition header but it prompts user for saving. As per our requirement the output should get automatically saved.
View Replies View RelatedI have a webpage containing a link to a spreadsheet
<a href="somefilename.xls">click</a>
When the link is clicked a spreadsheet opens in internet explorer
using some sort of excel COM object.
I would like to enable the user to edit the spreadsheet and then
save the changes in the existing file. How ever IE only offers
"save as" not "save" and it dosent suggest the original filename.
The users already have write acces to the area where the excel
sheet is published. How do i make IE suggest the original filename
or enable the "save" menu??
Does anyone know of a way to take the records of my database and have it downloaded to an excel worksheet with asp???
View Replies View Relatedi have an ASP page which get data from DataBase. To save it as EXCEL I am using:L
<%response.contentType="application/vnd.ms-excel"%>.
What i want is to stop the user from editing some columns of saved excel file just like we pasword protect an excel.
I need advice about a good Upload component that can also give us the flexability of download and impersonation. If some one knows about a good componenet please do let me know.
Have checked the following ActiveFile, SA-FileUp, and Huge Asp Upload.
Also have used XML and ADO stream to upload the files, this could be perfectlly done in IE as we cannot create an object on the client side using Netscape.
i've bunch of files in a directory which need to be displayed in a html page. is there a way to display those files by order (dateCreated (descending))?
View Replies View RelatedDoes anyone know how to save an export excel file to the server automatically without any prompting and opening of the excel file?
Because I'm doing archiving, I need to let the user click on the archive button and the exported excel file will be saved directly to the server without opening the file.
I am having problems trying to make a form submit information back to itself. The form works fine when I am not using the enctype"multipart/form-data" tag that is used to upload files with the <input type="file"> form component. However I need to upload a file using this form and also pass information back to the ASP page aswell.
<%
txt = request.FORM("COMMENT")
response.write("txt="&txt)
%>
<form name="frm1" id="frm1" action="mytest2.asp" method="POST" enctype="multipart/form-data">
<strong>Select file #1:</strong><br>
<input type="file" size="40" name="FILE1" id="FILE1"><p>
<strong>Comments:</strong><br>
<input type="text" size="40" name="COMMENT" id="COMMENT"><p>
<input type="submit" value="Upload!">
</form>
Is there a script or a simple way(I doubt), to create archive files online without components...only with asp? by "archive files"....I mean .zip files or something similar that can then be de-archived later? It is not important whether the files get compressed or not. Code:
View Replies View RelatedI have an asp page, which displays graphical images.I am using Flipper graph in my application.
There is a link in the asp page "Click to view Image file",On clicking on this link,The graphical image need to be stored(Preferably in the server machine) and has to be opened in a new browser window.
To explain in detail. On clicking of that link"Click to view Image file" a function is called which does the following
1)Save the image file(.gif file) on the server machine
Graph.ImagetoGif("Location to be saved",100,200);
2) Opens the image on a new browser window.
window.open('from location from where the image is to be retreived',100,some more properties) So i need the image file to be saved in the server and retreived from the server.
how to make a box come out and let the user select which directory the user want to save the file to?
View Replies View RelatedI'm trying to do this:
Set fso = CreateObject("Scripting.FileSystemObject")
Set file = fso.CreateTextFile("C:Program FilesTestUploads
es.xml", true)
file.WriteLine(res.xml)
file.Close()
but in IE I only can see progress (in status) bar which never ends and never save anything to the disk. Why?
I have an ASP page where an applicant would keyin his details. Nothing but his resume on line. My problem is that we have a large text wherein the candidate will paste his entire resume for reference. Once he submits it, while viewing if we copy and paste the text to word, the alignment is not there at all.
Could anyone suggest some option to attach the resume and store it in the database and then downloading the resume as it is. Could anyone help me out on this as soon as possible.
Can someone please (i dont even know where to start on this as i am completely incapable of file or image functions at the moment) help me do this:
i want to write a script that will copy an image from an internet page, then save it in a folder with the speficied filename. The url link is like this :
http://ipaddressort/BufferingImage?ImageAdr=123456.
The image is captured by the webcam, of course I can view it in the browser by typing the url, but I want to save it without any popup window or right click, I want to do it in the script.
How the heck would I go about saving an object to file? Put would be perfect, and can basically save everything except objects - how do I save an object if I can't use put?
View Replies View RelatedIs it possible for asp/scripts to create and save it in an image format(gif, jpg)? Say a script that creates an arrow picture.
View Replies View RelatedI want to loop through a recordset and save each records contents as text files and then zip all the text files and promt user to download the zip --- can this be done?? Does anyone have any code?
View Replies View RelatedIs it possible to write asp file which create some text file and then save
in local drive automatically without human interaction?
possible or not auto save file as .html in client pc when this page onload...
View Replies View RelatedI am creating csv file by doing following. So when asp page get load this code run and it create csv file and store in specified location.
How can i open this store file in same window after it get created. I have a name and location of file "whichfn" how can i open into excel format. Code:
i want to write an application in ASP,in this i want to generate an excel file,in which all records will save in that excel file as per i ve given the query after saving records in excel file ,immediately i should get save as dialog box so that i will save that file on my local drive.i don't want to save that file on web, whenever file gets created & records saved,it will show me save as dialog box.
View Replies View Related