Enterprise Services Integration

Using ASP.NET to create a word document to disk

2010-06-09T15:04:32.313-04:00

Hi all,

I am building an application that I want to do the following in its simple form.

1. Website loads up and there is a button that says create word document.
2. Click the button and the word document is created and stored on the hard drive in the web application folder.

I found some code on the net that will generate a word document but when you click the button and run the code it opens a prompt box asking you where to save the file. I do not want to be prompted but to have it write the file to disk automatically. I have done this with text files before. Of course later on i can set all these values as to where the file should be saved in the web.config file.

Here is the sample code that prompts you where to save the file.

protected void btnGenerateDocument_Click(object sender, EventArgs e)
    {
        HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.Charset = "";


        HttpContext.Current.Response.ContentType = "application/msword";


        string strFileName = "GenerateDocument" + ".doc";
        HttpContext.Current.Response.AddHeader("Content-Disposition", "inline;filename=" + strFileName);


        StringBuilder strHTMLContent = new StringBuilder();


        strHTMLContent.Append(" <h1 title='Heading' align='Center' style='font-family:verdana;font-size:80%;color:black'><u>Document Heading</u> </h1>".ToString());
        strHTMLContent.Append("<br>".ToString());
        strHTMLContent.Append("<table align='Center'>".ToString());
        strHTMLContent.Append("<tr>".ToString());
        strHTMLContent.Append("<td style='width: 100px;background:#99CC00'><b>Column 1</b></td>".ToString());
        strHTMLContent.Append("<td style='width: 100px;background:#99CC00'><b>Column 2</b></td>".ToString());
        strHTMLContent.Append("<td style='width: 100px;background:#99CC00'><b>Column 3</b></td>".ToString());
        strHTMLContent.Append("</tr>".ToString());
        strHTMLContent.Append("<tr>".ToString());
        strHTMLContent.Append("<td style='width: 100px'>a</td>".ToString());
        strHTMLContent.Append("<td style='width: 100px'>b</td>".ToString());
        strHTMLContent.Append("<td style='width: 100px'>c</td>".ToString());
        strHTMLContent.Append("</tr>".ToString());
        strHTMLContent.Append("<tr>".ToString());
        strHTMLContent.Append("<td style='width: 100px'>d</td>".ToString());
        strHTMLContent.Append("<td style='width: 100px'>e</td>".ToString());
        strHTMLContent.Append("<td style='width: 100px'>f</td>".ToString());
        strHTMLContent.Append("</tr>".ToString());
        strHTMLContent.Append("</table>".ToString());
        strHTMLContent.Append("<br><br>".ToString());
        strHTMLContent.Append("<p align='Center'> Note : This is dynamically generated word document </p>".ToString());




        HttpContext.Current.Response.Write(strHTMLContent);


        HttpContext.Current.Response.Write (strHTMLContent);




        HttpContext.Current.Response.End();
        HttpContext.Current.Response.Flush();
    }

I am basically going to eventually pull a record from a database and then using the source from a word document in the code behind and place those fields in there and generate the document. This document would then be in a folder where peopel can reach them and open when they wish to.

Could not load file or assembly 'office, Version=14.0.0.0

2013-05-14T19:43:06.25-04:00

Hello,

I have an ASP.NET application (created using VS 2012) that is creating Excel files. I've set a refernce to Microsoft.Office.Interop.Excel.dll and it works fine on my PC. However, when I publish it to the server, it doesn't work:

Could not load file or assembly 'office, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

I've installed the Visual Studio 2010 Tools for Office Runtime from here:

http://www.microsoft.com/en-us/download/details.aspx?id=35594

Yet it still giving me the same error. What could be the problem?

Thank you.

Cannot create ActiveX component - Excel 2010 issue

2013-04-24T15:52:11.22-04:00

Hello everyone,

We have an application using "excel dcom", and it was working fine (In dcomcnfg, I configured appropriate rights). But from today, i have the error "Cannot create ActiveX component." . I'm using Windows Server 2008 R2 x64 with Excel 2010 x64.

I tried to uninstall, then install excel, I also rebooted the server, check the rights , set dcom rights to default, and change them to the right one (I need that IIS_IUSRS and IUSR are able to execute), I also changed to interactive to launching users (I have an other error " microsoft excel cannot open or save any more documents because there is not enough available memory")

I checked the process, when I launch the command on the application, the excel process is stared, but i still have the "Cannot create ActiveX component"

So i'm now a little bit desperate :( So i'm requesting help here

Thanks in advance

how to find the word document is readonly or not?

2013-05-14T09:57:56.3-04:00

Hi,

How to find out the given word document is read-only or not using c#.

I am not talking about the read-only property of the (right click the document and you can enable or disable the read only checkbox) this one. i am talking about the read-only property, that while creating the word document you can make it as read only protected and now i want to access that one.

Please let me know if anybody knows about it.

but i tried the following

FileInfo info = new FileInfo(path);
info.IsReadOnly = false;
StreamWriter writer = new StreamWriter(path);
writer.WriteLine("This is an example.");
writer.Close();
info.IsReadOnly=true;

but it did not worked.

Thanks,

Burepalli V S Rao.

Microsoft.office.interop.excel, while exporting to excel store number as text ?

2013-05-13T09:40:11.02-04:00

Microsoft.office.interop.excel, while exporting to excel , how can i store a number like "0015200" as text in excel cell

Get HTML text from database and out into MS Word C#

2013-05-06T18:37:42.927-04:00

I have a table in a database that contains a field, which has text formatted in HTML in it. For example, <p>This is a <b>test.</b></p>

I want to insert this text into MS word. I'm not using the HTMLformat... way. I am using the Microsoft.Office.Interop.Word._Application oWord; way. Is there a way to set the .Text property to equal the text? So it pulls out of the database as:

<p>This is a <b>test.</b></p> but in MS word should be inserted as:

This is a test.

http://forums.asp.net/t/1224223.aspx/1

I want code similar to this:

object TemplatefileName = Server.MapPath("Template") + "\\High.doc";
            object novalue = System.Reflection.Missing.Value;
            Word.Table oTable;             Word.ApplicationClass objWord = new Word.ApplicationClass();
            Word.Document objWordDoc = objWord.Documents.Add(ref TemplatefileName, ref novalue, ref novalue, ref novalue);
            objWordDoc.Activate();
            objWordDoc.Application.Visible = true;

Not this:

Protected Overrides Sub Render(ByVal writer As System.Web.UI.HtmlTextWriter)
        Dim strBody As New System.Text.StringBuilder("")



        strBody.Append("&lt;html " & _
                        "xmlns:o='urn:schemas-microsoft-com:office:office' " & _
                        "xmlns:w='urn:schemas-microsoft-com:office:word'" & _
                        "xmlns='http://www.w3.org/TR/REC-html40'&gt;" & _
                        "<head><title></title>")



        'The setting specifies document's view after it is downloaded as Print Layout

        'instead of the default Web Layout. For the Header & Footer to be visible,

        'this mode is required.

        strBody.Append("<!--[if gte mso 9]>" & _
                                         "<xml>" & _
                                         "<w:WordDocument>" & _
                                         "<w:View>Print</w:View>" & _
                                         "<w:Zoom>90</w:Zoom>" & _
                                         "<w:DoNotOptimizeForBrowser/>" & _
                                         "</w:WordDocument>" & _
                                         "</xml>" & _
                                         "<![endif]-->")



        'we can tweak the MsoFooter class that is referenced by the footer, as required

        strBody.Append("<style>" & _
                                        "<!-- /* Style Definitions */" & _
                                        "p.MsoFooter, li.MsoFooter, div.MsoFooter" & _
                                        "{margin:0in;" & _
                                        "margin-bottom:.0001pt;" & _
                                        "mso-pagination:widow-orphan;" & _
                                        "tab-stops:center 3.0in right 6.0in;" & _
                                        "font-size:12.0pt;}" & _
                                        "p.MsoHeader, li.MsoHeader, div.MsoHeader" & _
                                        "{margin:0in;" & _
                                        "margin-bottom:.0001pt;" & _
                                        "mso-pagination:widow-orphan;" & _
                                        "tab-stops:center 3.0in right 6.0in;" & _
                                        "font-size:12.0pt;}")

Open XML SDK Mail merge into one document

2013-04-29T06:17:23.707-04:00

Hi,

I need to be able to create a mail merge and rather than creating 100 documents it should only create one word document with all the mail merges in it... does any one have any samples on this? any resource material.. (c#.. mvc)

I have found samples on how to create mail merges with multiple documents, but I am only looking for all the mail merges to be merged into one document, so it is easier for the user to just download this one document to print rather than print each one..

thanks in advanced

Mail merge

2013-04-15T03:16:31.24-04:00

Hi guys,

I have a template letter in word.. I need to create a mail merge from a SQL database.. and then return the generated letters as one document to the user...

I am using MVC 4

any recomedations? any sample code? best practices?

Thanks in advance

Event 1000 & 1026 Errors

2013-04-29T17:04:43.89-04:00

I have a windows command line application that retrieves information from a SQL database. This information is then used to populate a new Excel workbook and saves it as an xls file. The application works as specified from the command line. However, when I try executing the same application through an ASP.NET webpage on the web server, it executes part way and the Excel process becomes orphaned.

The only information I have to go on from the event viewer are the following errors.

1st Error: (#1000 Application Error)

Faulting application name: xl.exe, version: 1.0.0.0, time stamp: 0x5159c582

Faulting module name: KERNELBASE.dll, version: 6.1.7601.17651, time stamp: 0x4e211319

Exception code: 0xe0434352

Fault offset: 0x0000b9bc

Faulting process id: 0x5bc

Faulting application start time: 0x01ce315fe8ce455b

Faulting application path: D:\Inetpub\www\build\report\xl.exe

Faulting module path: C:\Windows\syswow64\KERNELBASE.dll

Report Id: 279d396c-9d53-11e2-863b-6ad9cec2af31

2nd Error: (#1026 .NET Runtime)

Application: xl.exe

Framework Version: v4.0.30319

Description: The process was terminated due to an unhandled exception.

Exception Info: System.Runtime.InteropServices.COMException

Stack:

at System.RuntimeType.ForwardCallToInvokeMember(System.String, System.Reflection.BindingFlags, System.Object, Int32[], System.Runtime.Remoting.Proxies.MessageData ByRef)

at Microsoft.Office.Interop.Excel.PageSetup.set_PaperSize(Microsoft.Office.Interop.Excel.XlPaperSize)

at AdvOffice.AdvExcel.InitializeWorksheet(Microsoft.Office.Interop.Excel.Worksheet)

at ExcelCheckList.ScoreSheet..ctor(Boolean, Boolean, System.String, Int32)

at STP.Program.Main(System.String[])

Please note that these errors do not appear when executing the same app from the command line.

Any suggestions on how to suppress these errors so that my application can execute is much appreciated.

How to Set Background Image in word

2013-04-26T14:11:54.227-04:00

Hi Anyone please me how to set Background Image in word .My problem is we are using Xslt and generating Word document But i need to set a background image for the douments.

Below my detailed example ...

http://social.msdn.microsoft.com/Forums/en-US/worddev/thread/dbaa153b-6978-463c-b419-1fd55441446f/

Word Mail Merge With Asp .Net

2013-04-19T14:16:40.503-04:00

Hi all,

I need to develop more than 300 covering letter for my project. And it will be time consuming job. So i planned to design covering letter by easiest way. If i use crystal report, that may be risk to design and future alteration. I wish to do this by easiest way. How to use Word Mail Merge from asp .net? My idea is passing input to word mail merge from asp .net form and open that predesigned document with given input related data by clicking button. If any other concept exists,please refer me.

How to create a .xlsx in asp.net

2013-02-23T18:41:09.533-05:00

I'm able to create .xls. I unable to create .xlsx file using asp.net. could you help someone on the same.

thanks in advance.

Connecting MQ Client channel definition table (CCDT ) vs HostChannel and QueueName

2013-04-15T13:42:16.053-04:00

.Net Application connecting to IBM MQ Client channel definition table (CCDT ) vs HostChannel and QueueName.

Thanks

how to send email from Outlook 2007 using System.Net.HttpWebRequest

2013-04-24T08:57:11.613-04:00

how to send email from Outlook 2007 using System.Net.HttpWebRequest in vb.net 2005

Please help its urgent

Thanks in Advance

</div> </div>

PDF to Word converter in VB ( and versa)

2013-04-20T18:00:49.983-04:00

Hello everyboy hope all is good,

Im beginner in visual basic but i have little backgroud i hope every expert here help me with this
becasue im a IT administrator and i need this software really urgent,

I need a software to convert from PDF ->Word and Word -> PDF not change the Extension
i know it's simple software to be made by searching in the internet,
i have tried some of them (codes) but all are just trying to change the Extension.

i need your help guys, Need the codes to be work in Visual studio 2010 Ultimate,

have a nice day,

Ahmed.

How to merge Two Different Excel sheets?

2011-03-17T23:58:44.63-04:00

Hi,

How do i write a programme to merge Two different excel docs(Columns are different in two sheets) into one excel sheet?

For instance, Excel1.xslx has a and b columns

Excel2.xslx has c and d columns

Now i want to combine those two excel documents and create excel 3 with a,b,c,d columns

Merging Multiple Excel files (exports from Reporting Services)

2010-10-01T22:47:47-04:00

So we have Office 2007 on our system and I'm trying to use Excel Interop to take a number of Excel files, which are exports from Reporting Services, and combine them into one large workbook. I'm using the code below which works fine to get all the information from all the files into one workbook but the colors of things goes absolutely haywire. Anyone know why my colors are getting all out of wack?

protected void MergeFiles(string destinationFile, string[] sourceFiles, string guid)
        {
            try
            {
                //1. Validate folder,
                //2. Instantiate excel object
                //3. Loop through the files
                //4. Add sheets
                //5. Save and enjoy!

                object missing = System.Reflection.Missing.Value;
                Microsoft.Office.Interop.Excel.ApplicationClass ExcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
                ExcelApp.Visible = false;

                //Create destination object
                Microsoft.Office.Interop.Excel.Workbook objBookDest = ExcelApp.Workbooks.Add(missing);

                foreach (string filename in sourceFiles)
                {
                    if (File.Exists(filename))
                    {
                        //create an object
                        Microsoft.Office.Interop.Excel.Workbook objBookSource = ExcelApp.Workbooks._Open
                        (filename, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing
                        , Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

                        //Browse through all files.
                        foreach (Microsoft.Office.Interop.Excel.Worksheet sheet in objBookSource.Worksheets)
                        {
                            sheet.Copy(Type.Missing, objBookDest.Worksheets[objBookSource.Worksheets.Count]);
                        }

                        objBookSource.Close(Type.Missing, Type.Missing, Type.Missing);
                        objBookSource = null;

                    }
                }
                objBookDest.SaveAs(destinationFile, Microsoft.Office.Interop.Excel.XlFileFormat.xlExcel8, Type.Missing, Type.Missing, Type.Missing, Type.Missing, XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
                objBookDest.Close(Type.Missing, Type.Missing, Type.Missing);

                objBookDest = null;
                ExcelApp = null;

            }
            catch (System.Exception e)
            {
                //Catch
            }
        }

How to merge two excel files into one with their sheet names?

2011-09-27T11:38:32.417-04:00

Hi,

For merging of two excel sheet, I am using below code.

using System;
using Excel = Microsoft.Office.Interop.Excel;
using System.Reflection;


namespace MergeWorkBooks
{
    class Program
    {
        static void Main(string[] args)
        {
            Excel.Application app = new Excel.Application();

            app.Visible = true;
            app.Workbooks.Add("");
            app.Workbooks.Add(@"c:\MyWork\WorkBook1.xls");
            app.Workbooks.Add(@"c:\MyWork\WorkBook2.xls");


            for (int i = 2; i <= app.Workbooks.Count; i++)
            {
                int count = app.Workbooks[i].Worksheets.Count;

                app.Workbooks[i].Activate();
                for (int j=1; j <= count; j++)
                {
                    Excel._Worksheet ws = (Excel._Worksheet)app.Workbooks[i].Worksheets[j];
                    ws.Select(Type.Missing);
                    ws.Cells.Select();

                    Excel.Range sel = (Excel.Range)app.Selection;
                    sel.Copy(Type.Missing);

                    Excel._Worksheet sheet = (Excel._Worksheet)app.Workbooks[1].Worksheets.Add(
                        Type.Missing, Type.Missing, Type.Missing, Type.Missing
                        );

                    sheet.Paste(Type.Missing, Type.Missing);

                }


            }

        }
    }
}

This code is working good for me for merging excel workbook. But at the time of merging I am not getting the excel sheet names. Here I need that when the excel is merging at the same time the sheet names should also go to the merged excel sheet. So please help me out on this. Its urgent. Thanks In Advance...

Merge two different excel files into one excel file in c#

2010-11-02T07:58:08.397-04:00

Hi;

I simply want to merge two excel files into another excel file. I guess i should use Intertor for that but i don't know how to use it, never use it before. May anyone help please... Thanks!

How to merge sheets from multiple excel files into one .xls file?

2009-03-05T05:23:52.197-05:00

I have several excel spreadsheet fils, each of them contains multiple work sheets that may storing images or data.

How could I merge all of these work sheets to just one .xls file and keep their original layout and style using asp.net?

Thanks in advance.