How To Stream An Excel 2007 Or Word 2007 File Using C#

Mar 25, 2010

I'm working on a web app and need to stream various files. I can do pdfs, images, and older Office documents. However, when I try to do with 2007 documents, it breaks. Here is my code:

Response.Buffer = true;
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
switch (FileExtension.ToLower())
{
case "pdf":
Response.ContentType = "application/pdf";
break;
case "doc":
Response.ContentType = "application/msword";
break;
case "docx":
Response.ContentType = "application/vnd.ms-word.document.12";
break;
case "xls":
Response.ContentType = "application/vnd.ms-excel";
break;
case "xlsx":
Response.ContentType = "application/vnd.ms-excel.12";
break;
default:
Response.ContentType = "image/jpeg";
break;
}
Response.BinaryWrite(buffer);

The error that I get is:

An invalid character was found in text content. Error processing resource 'http://DomainName/GetFile.aspx.

View 2 Replies


Similar Messages:

DataSource Controls :: How To Export DataTable To Word 2007 / Excel 2007 & CSV

Mar 23, 2010

I am using the below code to Export DataTable to Word,Excel,CSV format & it's working fine. But problem is that this code export to MS Word 2003,Excel 2003 & CSV version. I need to Export my DataTable to MS Word 2007,Excel 2007 & CSV because I am supposed to handle more than 100,000 records at a time and as we know Excel 2003 supports for only 65,000 records.

how to export DataTable or DataSet to MS Word 2007,Excel 2007 & CSV.

[Code]....

View 1 Replies

How To Export A Datatable To MS Word 2007 / Excel 2007 And Csv

Mar 23, 2010

I am using the below code to Export DataTable to MS Word,Excel,CSV format & it's working fine. But problem is that this code export to MS Word 2003,Excel 2003 version. I need to Export my DataTable to Word 2007,Excel 2007,CSV because I am supposed to handle more than 100,000 records at a time and as we know Excel 2003 supports for only 65,000 records.

how to export DataTable or DataSet to MS Word 2007,Excel 2007.

[Code]....

View 1 Replies

Web Forms :: Displaying Word & Excel 2007 Documents?

Jul 22, 2010

I am loading documents into our Oracle database and then retrieving them for the users to view. So far PDF, DOC, XLS, CSV, etc. all perform as expected, however; DOCX, XLSX, etc. files have one annoyingly persistent issue. When the document is downloaded by the user and they open it you get the first in a series of messages: The file 'thefile.docx' cannot be opened because there are problems with the contents. Details: The file is corrupt and cannot be opened. and then: Word found unreadable content in 'thefile.docx'. Do you want to recover the contents of this document? If you trust the source, click Yes. After clicking yes the file opens and all of the content appears correct. Including images, formatting, tracked changeds and comments, equations, etc. I have tried multiple methods along these lines to no avail. I simply want the files to open without the false-positive error messages. I am using VS2010, with the website targeted at .Net Framework 2.0.

objConn =
New
OracleConnection(gstrConnectionString)
objConn.Open()
cmd = New
OracleCommand
cmd.Connection = objConn
cmd.CommandText = "select DOCUMENT_NAME,DOCUMENT_TYPE,DOCUMENT
from DOCUMENT_TABLE where DOCUMENT_ID='"
& strDocumentID & "'"
dr = cmd.ExecuteReader
dr.Read()

View 5 Replies

Databases :: Displaying Word & Excel 2007 XML Documents From ASPX?

Jul 23, 2010

I am loading documents into our Oracle database and then retrieving them for the users to view. So far PDF, DOC, XLS, CSV, etc. all perform as expected, however; DOCX, XLSX, etc. files have one annoyingly persistent issue.

When the document is downloaded by the user and they open it you get the first in a series of messages:

The file 'thefile.docx' cannot be opened because there are problems with the contents.

Details: The file is corrupt and cannot be opened.

and then:

Word found unreadable content in 'thefile.docx'. Do you want to recover the contents of this document? If you trust the source, click Yes.

After clicking yes the file opens and all of the content appears correct. Including images, formatting, tracked changeds and comments, equations, etc.

I have tried multiple methods along these lines to no avail. I simply want the files to open without the false-positive error messages.

I am using VS2010, with the website targeted at .Net Framework 2.0.

objConn =
New
OracleConnection(gstrConnectionString)
objConn.Open()

[Code]....

View 15 Replies

How To Detect A Password In A Word 2003 Or 2007 File

Apr 14, 2010

My users like to upload password-protected Word documents into our custom document management system. I'd like to add a validation to check for the password and refuse the upload if it has a password.

Automating Word - with COM interop - is out of the question because this is a server side application.

View 3 Replies

Web Forms :: Open A Mht File With Word 2000 / 2003 2007

Jan 22, 2010

I open a mht file with the streamreader and I do some handling with the file.

Then I would like te open this content with word (200,2003,2007).

What's the correct content type to use for the Response.WriteFile method ?

As normally a mht file has content type multipart/related ...

The code i use is:

[Code]....

View 2 Replies

Web Forms :: Create Excel 2007 File?

Sep 13, 2010

On Previous version of my application, if I want to export my data from SQL Server to Excel 2003 file, I just retrieve data from the SQL server and then straight away show "Open, Save, Cancel" dialog box to get the data on Excel 2003 Format. Here is the existing code in C#.

public void ExportToExcel(string StrFileName, DataTable dt)
{
if (dt!= null && dt.Rows.Count > 0)[code]....

but when I want to Export to Excel 2007 format with the same. I don't have any Idea to export it.

View 3 Replies

Databases :: How To Get Xml From Excel-2007 File(.xslx) Programmatically

Jan 13, 2010

I need to get the excel data in xml format.

Can anyone share me the code for converting .xlsx file to

xml format?

View 1 Replies

Databases :: Load Data From An EXCEL 2007 File To SQL Server 2008?

May 8, 2010

I want to load the data from an EXCEL 2007 file to SQL Server 2008 database. I am geting following error.

The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.

Following is the complete source code. Kindly any senior member guide me what is the problem in the following code.

[Code]....

View 1 Replies

Msword - Convert Word 2007 Document To Word 2003 Programmatically ?

Apr 15, 2010

any component or library (preferably open source) that would allow me to convert Word 2007 documents to Word 2003 with ASP.NET?

View 3 Replies

.net - Manipulating Word 2007 Document XML In C#

Jan 25, 2011

I am trying to manipulate the XML of a Word 2007 document in C#. I have managed to find and manipulate the node that I want but now I can't seem to figure out how to save it back. Here is what I am trying:

// Open the document from memoryStream
Package pkgFile = Package.Open(memoryStream, FileMode.Open, FileAccess.ReadWrite);
PackageRelationshipCollection pkgrcOfficeDocument = pkgFile.GetRelationshipsByType(strRelRoot);
foreach (PackageRelationship pkgr in pkgrcOfficeDocument)
{
if (pkgr.SourceUri.OriginalString == "/")
[code]...

View 4 Replies

Export Crystal Report To Microsoft Word 2007?

Jun 4, 2010

how to export crystal report to Microsoft Word 2007.what will be the content type of it.I use in VB.NET 2002.

View 1 Replies

VS 2008 - Create Mail Merge Doc Using MS Word 2003/2007?

Apr 13, 2010

I need to create some mail merge documents and was wondering if anyone knew the best way of doing this from asp.net. Currently I have set up .dot template files with bookmarks and then use COM to open these files pass the data and save. I can then stream the file to the users desktop. The issue i have is that to get this working when i release it is by installing Wrord on the server which I would prefer not to do.

way of passing data to word docs and then opening them to the user. The reason why i need to use word, is that the user needs to be able to modify the doc.

View 7 Replies

How To Open Word Document 2007 And Save Format As .xps At Server Side

Nov 3, 2010

How to open word document 2007 and save formate as .xps at server side.

I want the user to open word docx at server side user will click the button to open document which will be execute at server side. I want to show to my client a xps formate of docx which will be converted at server side(from .docx to .xps).

My code is running on local correctly. but at iis5.1 it's not working & giving an exception :-

System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {000209FF-0000-0000-C000-000000000046} failed due to the following error: 80070005.

ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.

To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.

[Code]....

View 1 Replies

C# - Exporting Gridview To Ms Excel 2007?

Jan 17, 2011

I am trying to export grid view data into excel 2007 i.e. xlsx format. but its giving error.

i am using following code

protected void Button1_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;

[Code]....

but not working properly and on opening the file it gives following error "Excel cannot open the file 'ChangeRequestList[2].xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file"

View 1 Replies

Databases :: Reading Data From Excel 2007?

Aug 3, 2010

I am attempting to read data from an uploaded spreadsheet using ACE.OLEDB. The code, which is running fine on dev and test machines for XL2003/2007 reports "Exernal table is not in the expected format" error on connecting on the production server for XL2007 only.The code is

Dim connectionString As String = "provider=Microsoft.Ace.OLEDB.12.0;" _ & "Data Source='" & ImportData.FullName & "';Extended Properties=Excel 12.0;" LogWebActivity.LogThis("Entering POPSUKD, ConStr=" & connectionString, LogWebActivity.LogDetailLevel.DetailAndData) Dim con As New System.Data.OleDb.OleDbConnection(connectionString) LogWebActivity.LogThis("Dimmed con", LogWebActivity.LogDetailLevel.Debugging) Try Dim cmdSelect As New System.Data.OleDb.OleDbCommand("SELECT * FROM [" & WorksheetName & "$]", con) Dim adapter As New System.Data.OleDb.OleDbDataAdapter(cmdSelect) Dim dS As New Data.DataSet LogWebActivity.LogThis(cmdSelect.CommandText, LogWebActivity.LogDetailLevel.Debugging) con.Open() LogWebActivity.LogThis("Opened Connection", LogWebActivity.LogDetailLevel.Debugging) adapter.Fill(dS, WorksheetName) LogWebActivity.LogThis("Filled DataAdapter", LogWebActivity.LogDetailLevel.Debugging) _SKUS = dS.Tables(WorksheetName) LogWebActivity.LogThis("Set SKUS", LogWebActivity.LogDetailLevel.Debugging)

View 1 Replies

Databases :: Programmatically Convert Excel 2007 To CSV?

Feb 11, 2011

I'm really stuck tryign to figure this out. Converting XLS to CSV is no big deal or at least it seems that way. However, trying to go xlsx to csv seems to be more difficult. For grins, I grabbed some code that is supposed to read a sample xlsx file and convert that into a gridview called GridView1. I figure it can't be much different to turn that into CSV.

[Code]....

View 9 Replies

Web Forms :: Exporting Page To Excel 2007

Apr 11, 2012

 I need to export asp.net page toexcel 2007. when i wrote the code as below:

protected void Button2_Click(object sender, EventArgs e) {Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = ""; Response.ContentType = "application/vnd.xls"; System.IO.StringWriter string
Write = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter html
Write = new HtmlTextWriter(stringWrite); div1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString()); Response.End(); } 
publicoverride void VerifyRenderingInServerForm(Control control) {   
} and

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="poprint.aspx.cs" Inherits="print_poprint" EnableEventValidation="false" %>

It displays message as shown

The file you are trying to open is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?

When yes is clicked it opens in excel but in some other format I think for I cannot AUTOSUM or sum the values result always as zero for numbers appears as text as " 222" . even if i try to format cells with numbers it does not works.

View 1 Replies

SQL Reporting :: How To Export RDLC Report To Excel 2007

Mar 24, 2011

I have designed a report in RDLC. I am using Visual Studio 2008 and C#. Below is my code to export the report in excel. It always export the report to xls format which is Excel 2003. Excel 2003 has limited rows upto 65000. When i get rows more than 65000 for example 90000 then the export fails. Excel 2007 has power to handle more than 1000000 rows. I want to export the RDLC report to Excel 2007 to overcome the issue. how by modifying the following code i can export the report to Excel 2007.

byte[] bytes = null;
bytes = viewer.LocalReport.Render("Excel", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename=Rendered Services." + extension);
Response.BinaryWrite(bytes);
Response.Flush();

View 1 Replies

Databases :: Reading And Writing MS Excel (2007) Files?

Mar 4, 2011

Want to create a web based application for reading and writing excel files.

Issue :

1. Want to upload an excel file and store it some location.
2. Read data from excel file, performing some sorting and filtering
3. Write filtered data to new excel file.

View 1 Replies

Web Forms :: Exporting To Excel 2007 (XLSX Format)

Mar 13, 2012

in my web application page i have a option to export to excel . I am able to export the data to Excel but have 2 issues

 1)  i hav ethe option of exporting in .XLS or .XLSX format

i am able to export in .xls format from any system ie the system having office 2007 or 2003

but when i am trying to export in .XLSX format i get error

Microsoft Office Excel---------------------------The file you are trying to open, 'noup.xlsx', is in a different format than specified by the file extension. Verify that the file is not corrupted and that the file extension matches the file format---------------------------Ok---------------------------

2) when exporting i want the excel sheet to be saved with the name thats selected from a dropdown

suppose the dropdown has text selected as CITY

i want the excel sheet as CITY.XLS/.XLSX

i my developemnet system it works fine with below code

string filename = dropdown1.SelectedItem.Text
if (Extension.SelectedValue.ToString() == ".xls")
{

[Code].....

but on production server i get the name of .aspx page

View 1 Replies

Export Data From Excel 2007 Sheet To SQL Server 2005?

Dec 27, 2010

I have a web application (ASP.NET 3.5) that allows the users to upload their own excel sheet. This sheet contains information about items that needs to be inserted to SQL Server 2005.

I already have this functionality, however, it's very slow (it takes almost 20 minutes to finish the request). I need a better way to handle this problem.

The sheet contains information about an item. These properties will be inserted into multiple tables for example (Books, Authors, Titles ... etc ...).

What I'm currently doing is the following:

The user uploads the file. The application opens the file. Read each row and update the database accordingly.

I'm using Microsoft.Office.Interop.Excel

Edit: I'm working with 10.000+ rows per sheet.

View 4 Replies

DataSource Controls :: Get Data Into SQL Server 2008 To Excel 2007

Jan 28, 2010

I've used the Import/Export wizard to get data into SQL from Excel and it works great. When I want to reverse the process, however, I can't. I've gone through the wizard multiple times and I've done what I think is everything to try to get the data out. What am I doing wrong?

View 10 Replies

Databases :: Excel Exporting Of RadGrid In MS Office 2003 With 2007?

Feb 17, 2011

I have a Telerik Radgrid i export the data in RadGrid with gridexporting property of radgrid in Excel 2003 i.e .xls but the problem is that my some client's computers have excel 2003 and some have 2007 when this exported radgrid excel data going to be opened in 2007 this shows some message that due to .xls file going to opened in 2007 but after clicking ok button on message its allowed me to open the file, i just wanted to stop this message.

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved