title: How to unhide an excel sheet through c# without using interop
body: <p>My server guy is not ready to install office</p>
  
  <p>I have written the following code in my form. It works fine from my machine but when I upload on the net; it does not work. This requires the <strong>interop dlls</strong> but the server guy is not ready to install office on the server. can any one help me as I need to <strong>unhide sheet from excel</strong>.</p>
  
  <p>using excel;</p>
  
  <pre><code>        Excel.Application excelApp = new Excel.Application();
  
          string myPath = @fileLocation;
          excelApp.Workbooks.Open(myPath, Missing.Value, Missing.Value,Missing.Value, Missing.Value,Missing.Value, Missing.Value,Missing.Value, Missing.Value,Missing.Value, Missing.Value,Missing.Value, Missing.Value);//,Missing.Value, Missing.Value);
  
          //Get the first sheet.
          Excel.Worksheet objSheet = (Excel.Worksheet)excelApp.ActiveWorkbook.Sheets["abc"];
  
          //Unhide the worksheet.
          objSheet.Visible = Excel.XlSheetVisibility.xlSheetVisible;
          //Save As the Excel file.
          excelApp.ActiveWorkbook.Save();
  </code></pre>