How To View/review Excel File In Browser
Oct 20, 2010
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.
View 1 Replies
Similar Messages:
May 23, 2010
I 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.
View 4 Replies
Mar 18, 2011
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.
View 5 Replies
Feb 15, 2010
Is that a way to edit excel file on browser and then save it on server?
View 5 Replies
Mar 20, 2013
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>
View 1 Replies
Mar 8, 2011
how to view the pdf file in the browser
View 6 Replies
Feb 18, 2011
I have one doubt, Is it possible to view an Excel file in Asp.net web page like viewing a pdf file. Not using gridview, just need to open the excel in a web page.
View 9 Replies
May 27, 2010
I've a view which display all data. I'm using ViewData, for loop etc.. on the view, to show the data. It may sound weird, but is it possible to write view to disk as a file instead of showing in the browser. The reason is that, business wants functionality to send the same view file as email attachment to the user.
View 3 Replies
Jan 18, 2010
i have someecords in grid i want ot export in excel file . i use code like below
protected void btnExportDB_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Page.EnableViewState = false;
Response.Charset = "";
Response.AddHeader("Content-Disposition", "inline;filename=voucher.xls");
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
grdMembers.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
on use this code on button click event.. file is generating but when i use same file for import in to database It gave me Error : External table is not in the expected format. For prob. of Format Type for Excel.
View 2 Replies
Apr 25, 2010
[Code]....
i have successfully showed data using puting directpath in to a textbox(e.g, filename=TextBox1.Text;). but the code above is not working. i dont know why.
View 1 Replies
Feb 27, 2010
I have huge excel files that I have to open from web browser. It takes several minutes to load huge file. Is it possible to open a single worksheet (single tab) at a time from excel file that contains many worksheets? I have to do this using C# / asp.net MVC
View 5 Replies
Apr 6, 2014
i 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?
View 1 Replies
Jun 11, 2013
I need to auto fit the dropdown width to auto fit with the cell in excel using c#.net.
I have exported the dropdown to the excel using c#.
when the column width of the cell is increated, the width of the dropdown should be auto fit to the width of the cell.
View 1 Replies
Apr 1, 2010
when I used a code of exporting gridview into excel this code worked for a new website which is without masterpage.
my code:
public override void VerifyRenderingInServerForm(Control control) { }
protected void BtnGenerateReport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();.....
Now the same code when I copy it in my project having masterpage . there is no compiler error but it is genereating excel file withno data in it but in fact there is data in the grid view at runtime.
View 2 Replies
Jan 12, 2010
I need to remove the password protection from an uploaded excel file. I have been doing this directly with the Excel assemblies (ASP.NET/C#) and then I tried with the ooxmlcrypto, both worked, but the problem is that I can not deploy either of those solution because of the dependencies.
I mean, my sysadmin does not want us installing Excel on the server and, as I have been searching for some alternatives, I can not find one.
My question is: is there a way to put the necessary dlls in the server without installing Excel or the Office suite?
I found this: Office 2007 Primary Interop Assemblies redistributable package but still, it requires a Microsoft Office Product.
View 2 Replies
Feb 25, 2011
I need to open a excel in web browser when click a button.how to do that in asp.net
View 4 Replies
Feb 14, 2010
Need to navigate to Excel spread sheet and display in the browser.
how could I do that ?
View 5 Replies
Jul 21, 2010
I need display navigation in my website with ASP.NET 4 components. Navigation use XmlSiteMapProvider and file hierarchy as XML file. Because my website is a CMS I am looking for a solution able to store hierarchy in DataBase or in some sort of Business Logic. I found out SQL Site Map Provider, which seems a workaround to store hierarchy in SQL. [URL]
View 1 Replies
Jun 14, 2010
Is there any javascript to disable "export to microsoft excel option" on right click in browser. though it can be done using web.config
View 1 Replies
Mar 15, 2010
Is this piece of code where I lock a part of the function correct? Or can it have use drawbacks when multiple sessions ask concurrently for the same Exam? Purpose is that client that first asks for the Exam will assemble it, all next clients will get the cached version.
public Exam GetExamByExamDto(ExamDTO examDto, int languageId)
{
Log.Warn("GetExamByExamDto");
lock (LockString)
{
if (!ContainsExam(examDto.id, languageId))
{
Log.Warn("Assembling ExamDto");
var examAssembler = new ExamAssembler();
var exam = examAssembler.createExam(examDto);
if (AddToCache(exam))
{
_examDictionary.Add(examDto.id + "_" + languageId, exam);
}
Log.Warn("Returning non cached ExamDto");
return exam;
}
}
Log.Warn("Returning cached ExamDto");
return _examDictionary[examDto.id + "_" + languageId];
}
I have a feeling that this isn't the way to do it.
View 4 Replies
Dec 29, 2010
I work on a intranet site of management review,to insert the markes I have files for each module.I want only the
professor of module has the rightaccess to his file.How ?
View 1 Replies
Feb 3, 2010
I'm exporting the GridView to Excel. It works fine and I receive a prompt to Save/Open/Cancel the file although I need the file to be saved automatically in the provided (passed to the Export function) location and opened in the same browser window where the Gridview was.
View 2 Replies
May 7, 2015
How can i display in web browser directly from the database varbinary Office Files (Word, Excel, PowerPoint, and many others like Images), like this example in PDF [URL] ....
View 1 Replies
Mar 26, 2016
Below is the page and file is in local drive.
<asp:GridView runat="server" ID="gvDetails" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" />
[Code].....
View 1 Replies
Jun 29, 2010
I wanted to get a code review of my methods for creating a simple list/gallery display in ASP.NET. I am looking for specific ideas on how I might approach this same task differently. My goals are simplicity, rapid development, and ease-of-use.
The task: Create a simple image list view (gallery) for a folder in ASP.NET web forms.
How I Did It: I created the image controls on the fly and add them to a placeholder template. I added line breaks using literals controls too. Finally, I add a query string to the page for the "paging".
What other ways would one recommend to do this? I had considered to use a grid or listview. My goal was to do this really quickly.
View 1 Replies
