C# MVC Core Print Excel file using Process(), PDF works fine but Excel keep loading

Question

I am trying to print Excel(.xlsx) file via my web application by clicking a button. Everything works fine on my local, however when I upload to IIS, the moment I click the button. The page will just keep loading.

                string destinationFileWord = filePath;

                Process print = new Process();
                print.StartInfo.FileName = destinationFileWord;
                print.StartInfo.UseShellExecute = true;

                print.StartInfo.CreateNoWindow = true;
                print.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
                print.StartInfo.Verb = "PrintTo";

                print.StartInfo.Arguments = Utility.GetAppSettings("PrinterSettings", "Address1");
                print.StartInfo.WorkingDirectory = Path.GetDirectoryName(destinationFileWord);
                print.Start();

                if (print.HasExited == false)
                {
                    print.WaitForExit(5000);

                }

Does anyone know what might be the problem?

Thank you.

Is the document stored in IIS working directory or in a more traditional such as network drive? — mr.coffee
– mr.coffee, Commented Jan 28, 2019 at 3:16
@mr.coffee thanks for ur reply. it is stored in IIS Working directory. — Sarah
– Sarah, Commented Jan 28, 2019 at 3:16

mr.coffee · Accepted Answer · 2019-01-28 03:23:32Z

1

Your issue is mostly likely the directory mapping. On the server you need to use something like this to get the current working directory.

HttpContext.Current.Server.MapPath("~/")

There are a number of other methods posted in this SO post:

How do I get the current directory in a web service

EDIT

For .NET Core you need to use IHostingEnvironment.ContentRootPath:

How to get root directory of project in asp.net core. Directory.GetCurrentDirectory() doesn't seem to work correctly on a mac

edited Jan 28, 2019 at 3:23

answered Jan 28, 2019 at 3:18

mr.coffee

1,06311 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sarah Over a year ago

Hi Thanks for your reply. But I dont think thats the problem, because I actually had another function to print PDF and it works. What I am trying to say is that there are no problem with finding the filePath or fileName.

Sarah Over a year ago

HI. Turns out it was because of Microsoft Excel, if I change the default app to open .XLSX to LibreOffice then it works. Any idea what might be the probleM

Collectives™ on Stack Overflow

C# MVC Core Print Excel file using Process(), PDF works fine but Excel keep loading

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related