Backgroundworker for excel works fine at test environment but non responsive after publishing

Question

0.00/5 (No votes)

See more:

Dear friends.
I am generating a excel file at server to be downloaded for client.
I am using backgroundworker and it works fine while testing at my local computer
Once published I can see IIS Woeker Process(32) at server running.
But nothing happens

What I have tried:

C#

namespace SCQA
{
    public partial class TestMaster : System.Web.UI.Page
    {
        BackgroundWorker bgView = new BackgroundWorker();

        protected void Page_Load(object sender, EventArgs e)
        {
        }

        protected void btnBackGround_Click(object sender, EventArgs e)
        {
            bgView = new BackgroundWorker();
            bgView.WorkerSupportsCancellation = true;
            bgView.DoWork += new DoWorkEventHandler(bw_DoWork);
            bgView.WorkerReportsProgress = true;            
            bgView.RunWorkerAsync();
        }

        private void bw_DoWork(object sender, DoWorkEventArgs e)
        {
            Excel.Application xlApp;
            Excel.Worksheet xlWorkSheet;
            xlApp = new Excel.Application();
            xlWorkSheet = new Excel.Worksheet();
            Excel.Workbook xlWorkBook = xlApp.Workbooks.Add("C:\\Model.xlsx");
            xlWorkSheet = xlWorkBook.ActiveSheet;
            xlApp.DisplayAlerts = false;
            try
            {
                var _with1 = xlWorkSheet;
                _with1.Cells[1, 1] = "SCQA OVER TIME on - " + DateTime.Now.ToString("dd/MMM/yyyy");

            }
            catch (Exception ex) { }

            string fInfo = "D:\\SCQA_DOC\\ModelOut.xlsx";
            xlWorkBook.SaveAs(fInfo, xlWorkBook.FileFormat, Type.Missing, Type.Missing, false, false, Excel.XlSaveAsAccessMode.xlExclusive, false, false, Type.Missing, Type.Missing, Type.Missing);
            xlWorkBook.Close();
            xlApp.DisplayAlerts = true;
            releaseObject(xlApp);
            releaseObject(xlWorkBook);
            releaseObject(xlWorkSheet);
            //Button5_Click(null, EventArgs.Empty);        
            Response.Write("alert('Completed')");
        }
    }
}

Posted 18-Sep-17 23:31pm

vivianpinto

Updated 19-Sep-17 4:24am

Graeme_Grant

v2

Add a Solution

Comments

Graeme_Grant 19-Sep-17 7:10am

IIS may be blocking access to the app. Please look at the link about remote debugging to see what is actually happening on the server.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2017-09-18T23:41:00

C#

try
{
	var _with1 = xlWorkSheet;
	_with1.Cells[1, 1] = "SCQA OVER TIME on - " + DateTime.Now.ToString("dd/MMM/yyyy");

}
catch (Exception ex) { }

Any reason why you have this in production code???

If something does not work, you need to start debugging. Visual Studio has a remote debugging feature. you can even set breakpoints and step through the code. Read more here: Remote debugging in Visual Studio | Microsoft Docs[^]

Also, have you considered that Excel may not be installed on your web server?

UPDATE

Running excel on a web server may be very problematic even if you can resolve your issue. Typically, web servers can have single, tens, hundreds, thousands, etc of simultaneous connections. The excel client is not designed with this purpose in mind. You would be better off:
1. finding a third-party paid or free library that can work with excel files;
2. simply generate CSV files that can be downloaded and imported into Excel;
3. use an Office 365 API and use it to generate your files. Office 365 is designed to handle these types of workloads.

Dave Kreskowiak · Answer 2 · 2017-09-19T04:24:00

You're using Excel Interop in a web application. First, in order for that to even have a chance of working, Office has to be installed on the server.

But, you can't do that. Office applications are non-reentrant, meaning if two web requests come in and both do something with Excel at the same time, Excel will crash or do things that are very unexpected and just about impossible to reproduce.

Also, some operations in Excel require an actively logged-in user at the console on the server in order to work because they put up their own dialog boxes. On a web server, that user will never be logged in to respond to dialogs. These dialogs will NOT show up on the client machines. Excel will hang, forever waiting for input that will never arrive.

You cannot use Office Interop in a web application. You MUST rewrite this code to do the operations to workbooks using a library, such as the OpenXML SDK, ClosedXML, or some other library.

vivianpinto · Answer 3 · 2017-09-19T03:05:00

Got it Graeme. Thanks for your suggestion.
I tried it in another I get this error.

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).

 protected void Button1_Click(object sender, EventArgs e)
        {
            Excel.Application xlApp;
            Excel.Workbook xlWorkBook;
            Excel.Worksheet xlWorkSheet;
            object misValue = System.Reflection.Missing.Value;
            xlApp = new Excel.Application();
            xlWorkBook = xlApp.Workbooks.Add(misValue);
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

            for (int i = 1; i <= 100; i++)
                for (int j = 1; j < 100; j++)
                    xlWorkSheet.Cells[i, j] = i + "  : " + j;
            Response.ContentType = "application/vnd.ms-excel";
            Response.AppendHeader("Content-Disposition", "attachment; 
            filename=translationText.xlsx");
            Response.Write("<table>");
            for (int i = 1; i <= 100; i++)
            {
                Response.Write("<tr>");
                for (int j = 1; j < 100; j++)
                {
                    Response.Write("<td>" + i + "  : " + j + "</td>");
                }
                Response.Write("</tr>");
            }
            Response.Write("</table>");
            Response.Flush();
            Response.End();

            xlWorkBook.Close(true, misValue, misValue);
            xlApp.Quit();

            releaseObject(xlWorkSheet);
            releaseObject(xlWorkBook);
            releaseObject(xlApp);
}

Backgroundworker for excel works fine at test environment but non responsive after publishing

3 solutions

Solution 1

Solution 4

Solution 3

Add your solution here

Preview 0