Advertisement
Guest User

Excel Interop C# Demo - Essigwurst

a guest
Jan 23rd, 2017
343
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.55 KB | None | 0 0
  1. using Excel = Microsoft.Office.Interop.Excel;
  2.  
  3. public static void Main(string[] args)
  4. {
  5.     Excel.Application MyExcel = new Excel.Application();
  6.     MyExcel.Visible = true;
  7.     Excel.Workbook MyWorkbook = null;
  8.  
  9.     object Missing = System.Reflection.Missing.Value;
  10.  
  11.     MyWorkbook = MyExcel.Workbooks.Open(Template);
  12.  
  13.     Excel.Sheets MySheets = MyWorkbook.Worksheets;
  14.     Excel.Worksheet MyWorksheet = (Excel.Worksheet)MySheets.get_Item("WorksheetName");
  15.  
  16.     MyWorksheet.SaveAs(Path + "Document.xlsx");
  17.  
  18.     MyWorkbook.Close(false, Missing, Missing);
  19.     MyExcel.Quit();
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement