Call Spreadsheet by Process.Start Class

Question

0.00/5 (No votes)

See more:

I am having both Ms Office and OpenOffice.
I have Called Excel by "EXCEL.EXE" by using System.process.Start
and now I want to Check if My system doesnot have Ms Office then it should call Spreadsheet.

.xls is my file extension.

Posted 18-Feb-13 21:02pm

MalwareTrojan

Add a Solution

2 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)

S. M. Ahasan Habib · Answer 1 · 2013-02-18T22:32:00

Solution 1

Various way you can check that ms excel is installed or not.
I way is

C#

public bool IsMsExcelInstalled(){
   RegistryKey key = Registry.ClassesRoot;
   RegistryKey excelKey = key.OpenSubKey("Excel.Application");
   return excelKey == null ? false : true;
}

Another way

C#

public bool IsMsExcelInstalled(){
  Type excel = Type.GetTypeFromProgID("Excel.Application");
  return excel !=null;
}

Based on MS Excel installed you now can take decision to run open office.

Posted 18-Feb-13 22:32pm

S. M. Ahasan Habib

Comments

MalwareTrojan 19-Feb-13 4:49am

And now, how can we open that file in OpenOffice Spreadsheet in asp.Net?

.xls in my file extension

S. M. Ahasan Habib 19-Feb-13 4:53am

I never work with OpenOffice spereadsheet. But the way you luch ms excel same way you can lunch OpenOffice. Just you find out what the main executable file name and location, After getting that you send that path to the System.Process.Start methods as argument.

MalwareTrojan 19-Feb-13 5:53am

hey Sorry the Requirement has slidely changed...

I have Called Excel by "EXCEL.EXE" by using System.process.Start
and now I want to Check if My system doesnot have Ms Office then it should call Save in the same file extension format without any option.

.xls is my file extension.

S. M. Ahasan Habib · Answer 2 · 2013-02-19T00:08:00

if excel not instaled then i guess you want to store/download that file. If so then

C#

if (!IsMsExcelInstalled()){
 //assume fileFullName will be the file path which need to store/download.
  var fileInfo = new FileInfo(fileFullName);
            string fileName = Path.GetFileName(fileFullName);
            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName);
            HttpContext.Current.Response.AddHeader("Content-Length", fileInfo.Length.ToString());
            HttpContext.Current.Response.ContentType = "application/octet-stream";
            HttpContext.Current.Response.Flush();
            HttpContext.Current.Response.WriteFile(fileFullName);
            HttpContext.Current.Response.End();
}

You you want to download other file types then you need to change the value of

C#

HttpContext.Current.Response.ContentType

property. for example if you download pdf file then the value will be

C#

HttpContect.Current.Response.ContentType="Application/Pdf"

If it is doc file then
value will be "Application/msword".