Styjun

/api/sitecore is not working in CD server

What is the highest level of accuracy in motion control a Victorian society could achieve?

How can a ban from entering the US be lifted?

What is the difference between an "empty interior" and a "hole" in topology?

Is this car delivery via Ebay Motors on Craigslist a scam?

Can you take the Dodge action while prone?

Boss furious on bad appraisal

What is the shape of the upper boundary of water hitting a screen?

Does the force of friction helps us to accelerate while running?

Was I wrongfully denied boarding for having a Schengen visa issued from the second country on my itinerary?

Is it possible to spoof an IP address to an exact number?

Is this standard Japanese employment negotiations, or am I missing something?

What can a novel do that film and TV cannot?

Is there a standard definition of the "stall" phenomena?

Is conquering your neighbors to fight a greater enemy a valid strategy?

How can I effectively map a multi-level dungeon?

How to play a D major chord lower than the open E major chord on guitar?

What is it called when the tritone is added to a minor scale?

What's the difference between a type and a kind?

Do Goblin tokens count as Goblins?

What's the big deal about the Nazgûl losing their horses?

How can select a specific triangle in my Delaunay mesh?

What are some bad ways to subvert tropes?

Is there a way to change the aspect ratio of a DNG file?

C# Powershell code not executing on Windows 7

How do I calculate someone's age in C#?What is the difference between String and string in C#?Hidden Features of C#?Cast int to enum in C#How do I enumerate an enum in C#?What are the correct version numbers for C#?How do I get a consistent byte representation of strings in C# without manually specifying an encoding?Determine installed PowerShell versionPowerShell says “execution of scripts is disabled on this system.”How do you comment out code in PowerShell?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

Powershell code executed through my C# application is executing perfectly on Windows 10, but won't even run on Windows 7. Neither does it get beyond Process.WaitForExit()

I've tried using Powershell (System.Management.Automation) itself inside the code.
I've also set 'set-executionpolicy remotesigned' and it runs using a powershell script (.ps1), but not when using it in my C# code as shown below.

 Process p = new Process();
 p.StartInfo.FileName = "powershell";
 p.StartInfo.RedirectStandardInput = true;
 p.StartInfo.UseShellExecute = false;
 p.StartInfo.CreateNoWindow = true;
 p.Start();

 using (StreamWriter sw = p.StandardInput)
 
 if (sw.BaseStream.CanWrite)
 
 string pdfName = fileName.Substring(0, fileName.Length - new FileInfo(fileName).Extension.Length) + ".pdf";

 sw.WriteLine("$Exl = New-Object -ComObject Excel.Application");
 sw.WriteLine("$Doc = $Exl.Workbooks.Open("" + fileName + "")");
 sw.WriteLine("$Doc.ExportAsFixedFormat([Microsoft.Office.Interop.Excel.XlFixedFormatType]::xlTypePDF, "" + pdfName +"")");
 sw.WriteLine("$Doc.Close($False)");
 sw.WriteLine("[gc]::Collect()");
 sw.WriteLine("[gc]::WaitForPendingFinalizers()");
 sw.WriteLine("$Exl.Quit()");
 sw.WriteLine("[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Exl)");
 sw.WriteLine("Remove-Variable Exl");
 
 
 p.WaitForExit();

On Windows 10, the script successfully converts an Excel file to pdf, but on Windows 7 - the script doesn't even open Excel to convert the file.

c# powershell

share|improve this question

asked Mar 25 at 19:48

Ian NIan N

1

• 
  
  
  

  
  4
  

  
  
  
  
  
  

  
  
  I'm curious why you're invoking powershell to do that instead of just using Excel interop directly.
  
  – itsme86
  Mar 25 at 19:51
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  What version of System.Management.Automation have you linked to in the project? By default Windows 7 only has PowerShell v2; if you referenced a later assembly that might be why it never runs.
  
  – briantist
  Mar 25 at 19:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  maybe can catch exception to see the issue?
  
  – urlreader
  Mar 25 at 20:09
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @itsme86 I'm asking myself the same question. It works, thank you. Only thing is, i'm still wondering why the powershell script is executing fine on Win10 but not on Win7?
  
  – Ian N
  Mar 25 at 20:38
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm glad it works. Not sure about the Win7 powershell problem. Is @briantist onto something maybe?
  
  – itsme86
  Mar 25 at 20:41
  

  
  
  
  

 | 
show 5 more comments

0

Powershell code executed through my C# application is executing perfectly on Windows 10, but won't even run on Windows 7. Neither does it get beyond Process.WaitForExit()

I've tried using Powershell (System.Management.Automation) itself inside the code.
I've also set 'set-executionpolicy remotesigned' and it runs using a powershell script (.ps1), but not when using it in my C# code as shown below.

 Process p = new Process();
 p.StartInfo.FileName = "powershell";
 p.StartInfo.RedirectStandardInput = true;
 p.StartInfo.UseShellExecute = false;
 p.StartInfo.CreateNoWindow = true;
 p.Start();

 using (StreamWriter sw = p.StandardInput)
 
 if (sw.BaseStream.CanWrite)
 
 string pdfName = fileName.Substring(0, fileName.Length - new FileInfo(fileName).Extension.Length) + ".pdf";

 sw.WriteLine("$Exl = New-Object -ComObject Excel.Application");
 sw.WriteLine("$Doc = $Exl.Workbooks.Open("" + fileName + "")");
 sw.WriteLine("$Doc.ExportAsFixedFormat([Microsoft.Office.Interop.Excel.XlFixedFormatType]::xlTypePDF, "" + pdfName +"")");
 sw.WriteLine("$Doc.Close($False)");
 sw.WriteLine("[gc]::Collect()");
 sw.WriteLine("[gc]::WaitForPendingFinalizers()");
 sw.WriteLine("$Exl.Quit()");
 sw.WriteLine("[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Exl)");
 sw.WriteLine("Remove-Variable Exl");
 
 
 p.WaitForExit();

On Windows 10, the script successfully converts an Excel file to pdf, but on Windows 7 - the script doesn't even open Excel to convert the file.

c# powershell

share|improve this question

asked Mar 25 at 19:48

Ian NIan N

1

• 
  
  
  

  
  4
  

  
  
  
  
  
  

  
  
  I'm curious why you're invoking powershell to do that instead of just using Excel interop directly.
  
  – itsme86
  Mar 25 at 19:51
  
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  What version of System.Management.Automation have you linked to in the project? By default Windows 7 only has PowerShell v2; if you referenced a later assembly that might be why it never runs.
  
  – briantist
  Mar 25 at 19:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  maybe can catch exception to see the issue?
  
  – urlreader
  Mar 25 at 20:09
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @itsme86 I'm asking myself the same question. It works, thank you. Only thing is, i'm still wondering why the powershell script is executing fine on Win10 but not on Win7?
  
  – Ian N
  Mar 25 at 20:38
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I'm glad it works. Not sure about the Win7 powershell problem. Is @briantist onto something maybe?
  
  – itsme86
  Mar 25 at 20:41
  

  
  
  
  

 | 
show 5 more comments

Powershell code executed through my C# application is executing perfectly on Windows 10, but won't even run on Windows 7. Neither does it get beyond Process.WaitForExit()

I've tried using Powershell (System.Management.Automation) itself inside the code.
I've also set 'set-executionpolicy remotesigned' and it runs using a powershell script (.ps1), but not when using it in my C# code as shown below.

 Process p = new Process();
 p.StartInfo.FileName = "powershell";
 p.StartInfo.RedirectStandardInput = true;
 p.StartInfo.UseShellExecute = false;
 p.StartInfo.CreateNoWindow = true;
 p.Start();

 using (StreamWriter sw = p.StandardInput)
 
 if (sw.BaseStream.CanWrite)
 
 string pdfName = fileName.Substring(0, fileName.Length - new FileInfo(fileName).Extension.Length) + ".pdf";

 sw.WriteLine("$Exl = New-Object -ComObject Excel.Application");
 sw.WriteLine("$Doc = $Exl.Workbooks.Open("" + fileName + "")");
 sw.WriteLine("$Doc.ExportAsFixedFormat([Microsoft.Office.Interop.Excel.XlFixedFormatType]::xlTypePDF, "" + pdfName +"")");
 sw.WriteLine("$Doc.Close($False)");
 sw.WriteLine("[gc]::Collect()");
 sw.WriteLine("[gc]::WaitForPendingFinalizers()");
 sw.WriteLine("$Exl.Quit()");
 sw.WriteLine("[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Exl)");
 sw.WriteLine("Remove-Variable Exl");
 
 
 p.WaitForExit();

On Windows 10, the script successfully converts an Excel file to pdf, but on Windows 7 - the script doesn't even open Excel to convert the file.

c# powershell

share|improve this question

asked Mar 25 at 19:48

Ian NIan N

1

 Process p = new Process();
 p.StartInfo.FileName = "powershell";
 p.StartInfo.RedirectStandardInput = true;
 p.StartInfo.UseShellExecute = false;
 p.StartInfo.CreateNoWindow = true;
 p.Start();

 using (StreamWriter sw = p.StandardInput)
 
 if (sw.BaseStream.CanWrite)
 
 string pdfName = fileName.Substring(0, fileName.Length - new FileInfo(fileName).Extension.Length) + ".pdf";

 sw.WriteLine("$Exl = New-Object -ComObject Excel.Application");
 sw.WriteLine("$Doc = $Exl.Workbooks.Open("" + fileName + "")");
 sw.WriteLine("$Doc.ExportAsFixedFormat([Microsoft.Office.Interop.Excel.XlFixedFormatType]::xlTypePDF, "" + pdfName +"")");
 sw.WriteLine("$Doc.Close($False)");
 sw.WriteLine("[gc]::Collect()");
 sw.WriteLine("[gc]::WaitForPendingFinalizers()");
 sw.WriteLine("$Exl.Quit()");
 sw.WriteLine("[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Exl)");
 sw.WriteLine("Remove-Variable Exl");
 
 
 p.WaitForExit();

share|improve this question

asked Mar 25 at 19:48

Ian NIan N

1

share|improve this question

asked Mar 25 at 19:48

Ian NIan N

1

asked Mar 25 at 19:48

Ian NIan N

1

asked Mar 25 at 19:48

Ian NIan N

1