Web Forms :: Is There A Way To Edit Excel File On Browser And Then Save It On Server
Feb 15, 2010Is that a way to edit excel file on browser and then save it on server?
View 5 RepliesIs that a way to edit excel file on browser and then save it on server?
View 5 RepliesWhat I am doing seems to be saving the Excel file in a text format. All I am trying to do is save the Excel file (xls) on my web server. Below is the code that "fetches" it now but doesn't save it in the proper format.
[Code]....
i want to export an excel from my web application and want to save it on Web Server, but i am not able to save it on web server, i am able to do it on my local machine, but on web server it's not working.
View 1 RepliesI am executing the following T-SQL code, which runs successfuly according to message I see at end of its execution, but the file c:cptest.txt is never created. I have checked for this file and it doesn't exist. what is the issue here?
EXEC MASTER..xp_cmdshell 'bcp "SELECT top(10) from Person.Address" queryout "C:cptest.txt" -T -c -t,'
I have code to export the grid to excel . i have taken it from [URL] now i want to save excel file directly without asking user to save it or open it at client side. i want to save it on server folder. how to do that .
View 2 Repliesi use this code to export data into word.
Protected Sub Export(sender As Object, e As EventArgs) Handles btn_printexcel.Click
Response.Clear()
Response.Buffer = True
[Code]....
but the export docs will be downloaded into the user computer.
what should i do so that the exported docs is save into the server?
I want how to upload the excel sheet data and that data will save in Sql Server 2008(table).
View 2 RepliesI have a master page, which has menus and submenus, and content pages in my project.
Now in one of the content pages, i need to open a excel file, displaying an Open/save dialog box) should be visible.
I tries using the inline option for Response.AddHeader, but does not display the master page part on the browser.
I want create/show/edit a excel file from my asp.net application. All I want is like the working of Google docs. Is there a way I can implement it? Any dll or can i even use the google docs api for that?
View 4 Replies I am opening excel file in div using IFRAME. Now i want to save the excel file by submit button , which is available on page
<div>
<iframe src="Test.xls" style="height:300px;width:600px">
</iframe>
</div>
<asp:button runat="server" id="submit" />
How to upload the file using iframe
I can place an Excel file in the root directory, use Browse and view an xlsx, xlsm or any other Excel file and it (sometimes) pops up in a browser window with no option to save or do anything other than view the Excel document (you can type in the cells and it gives you the option to save if there are any changes). I'm trying to find out how to do that exact thing client-side.
We have a server that allows a client to upload an Excel file and we want them to be able to review it only. If there is a way to bypass the Open message box that pops, that would be ideal, but just getting it to display in a separate, small browser window would be just what the doctor ordered. The Excel files are varied so the content is always different and not necessarily formatted the same. That removes the ability to go with named ranges and definitions.
Currently with the code we have, users can press a view button to review the file they uploaded for errors but it opens up the full version of Excel and then throws errors because it tries to force a save to a temp file. Not exactly ideal and very confusing to the user. I don't habve the exact code available to me at the moment, but I'm hoping that someone can point me in the right direction.
We have a tab delimited file that we are making available for download. The file extension is txt, but the users want it to open automatically in Excel. The previous developer had used the following code:
[code]....
The ContentType is being set to Excel, but that doesn't seem to have any effect. I am guessing the txt file extension is causing it to be picked up by notepad or the like instead. I have tried just renaming it to a xls extension, which works but Excel complains that I am trying to trick it or it might be a corrupted file.
I have a mail list where i can select many mails and download (with/without opening the mail). During the download process i update the mail status(download/open) and show the content in pdf. In normal browser dialog opens where user can save open or cancel options exits. But if the user cancel then the update process done on the mail should not happen. so i think about doing the update process if the user clicks open or save but how can i identity that client control (i think it depend on the browser)
The issue is present if i download and unopened mail and click cancel button in the dialog box the pdf creation code i have done is in this link
[URL]
which i used to open that dialog in browser to save pdf
I have a requirement to disable save as and print options of file menu of the browser in which my portal opens.For this i have used javascript code which clears the clipboard text.Because of this when my pplication is opened then copy paste wont work on the system.Iam calling this method on load of a startup page and afer clearing the clipboard text iam opening my home page through javascript with no menu bar just like a modal popup iam trying ot open.This is working fine for some browsers but IE7 and firefox users are unable to load the applicatio because of this javascript function.Can anyone suggest me how to overcome this or how to disable save as and print option.My final aim is user shouldnt be able to save or print my application data...
View 5 Repliesi want to save one excel file in sql database in some column and same i want to retrive . for this i am using file upload control to upload a file.
i did follwoing
i defined one column in sql for storing the file with datatype. image
when i am inserting a document in this column "<Binary data>" this value is showing.
and when i trying to retrive this file.In the file "System.Byte[]" text is coming in a cell.
I am storing excel file in database
code to insert a Excel file in database:
Int32 File1Length = this.FileUpload1.PostedFile.ContentLength;
String File1Type = this.FileUpload1.PostedFile.ContentType;
Stream File1Stream;
File1Stream = this.FileUpload1.PostedFile.InputStream;
[Code]....
I tried simple code like this using href element. But it tries to open the sheet.xls in the browser window and says it can't find the file. I want the excel file to be opened in excel (not browser).
<a href="file://domainname/vol1/destinationfiles/sheet.xls" >some excel file</a>
Is it possible to upload and Save Excel file as blob in Sql table through web application?
I do not need to query excel file, just be able to upload and download excel file as is.
I have to create an excel sheet by reading data from the database and save this newly created excel to the server. I know how to create the excel, i do it by creating html table then changing the content header. But how can i save this as an excel file in the server.
View 2 RepliesI have created a pdf file using aspose and need to open it without saving the pdf.Is it possible.
View 1 RepliesI've been searching for various posts on Excel and ASP.Net, and wanted to try and figure out if what I'm attempting has any chance of working. I have a special Excel workbook with a worksheet that has a bunch of calculations and such for various fields that creates an order for his crew. My client uses this Excel worksheet for everything. He's asking me to be able to see online orders (which I have), click a link and have the worksheet be passed down to the client all populated and formatted exactly as is (just adding/editing data).
Is this even possible? I'd have to load this specific .xls file, then open it on the server, save data to various cells, and then do a Save As and then binarystream it down to the client. I'm quite certain there is no version of Excel loaded on the server. So I'm perplexed as to how to accomplish this. Has anyone encountered this situation before and been able to accomplish what's being asked?
Is it possible to edit images using a javascript library and then send the edited image to the server for saving.
Edits will be in real time, means the user can see the edit result in the same time he is editing without the need to refresh the page.
I want a javascript library to do some edits on an image on a webpage 'such as crop, resize, rotate,...' and send send the edited result to the server.
What is the best way to insert and retrieve images like :
In the database in binary form retrieve it with imagehandler, or
In the database by saving the path of the folder of the images and retrieve it, or
by saving the images directly to the folder and retrieve it...
I am creating Excel file from code. This code is working fine in my local server. because it is local iis and local VS. When I deployed in the server. I am not able to see (download) excel to client browser. How can we give access to see excel in client browser?
[Code]....
I have a file on the server that users will have the possibility to download to thieir computer. For example the filepath could look like below. How would it be possible to save this to the desktop or C: etc.. ?
[Code]....
i believe That Saving Files In DataBase is good for Security Issue , But in My Scenario i didnt Care about Secrurity Issue,
i want to ask U guys which Better Save Files into DataBase or save it on Directory on Server, where This Issue Required:
1-(Reduce Load on Server and didnt affect server Memory).
2- Security not important.
if they have the same result i will move to DataBase Saving.