using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using Excel = Microsoft.Office.Interop.Excel;



namespace Testing_Input_to_Excel

{

 public partial class Form1 : Form

 {

 Microsoft.Office.Interop.Excel.Application xlexcel;

 Microsoft.Office.Interop.Excel.Workbook xlWorkBook;

 Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;

 object misValue = System.Reflection.Missing.Value;



 public Form1()

 {

 InitializeComponent();

 }



 private void btnSimpan_Click(object sender, EventArgs e)

 {

 xlexcel = new Excel.Application();

 //xlexcel.Visible = true;

 string path = "D:\\New.xlsx";



 // Open a File

 xlWorkBook = xlexcel.Workbooks.Open(path, 0, true, 5, "", "", true,

 Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);





 xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);



 xlWorkSheet.Cells[1, 1] = "FirstName";

 xlWorkSheet.Cells[1, 2] = "LastName";

 xlWorkSheet.Cells[1, 3] = "JobTitle";

 xlWorkSheet.Cells[1, 4] = "Address";



 int _lastRow = xlWorkSheet.Range["A" + xlWorkSheet.Rows.Count].End[Excel.XlDirection.xlUp].Row + 1;



 xlWorkSheet.Cells[_lastRow, 1] = textBox1.Text;

 xlWorkSheet.Cells[_lastRow, 2] = textBox2.Text;

 xlWorkSheet.Cells[_lastRow, 3] = textBox3.Text;

 //xlWorkSheet.Cells[_lastRow, 4] = textBox4.Text;



 //xlWorkBook.SaveAs("D:\\New.xlsx");

 //xlWorkBook.Save();

 //this.Save();

 //xlexcel.DisplayAlerts = false;

 xlWorkBook.Close(true, misValue, misValue);

 

 

 xlexcel.Quit();

 releaseObject(xlWorkSheet);

 releaseObject(xlWorkBook);

 releaseObject(xlexcel);

 }



 private void releaseObject(object obj)

 {

 try

 {

 System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);

 obj = null;

 }

 catch (Exception ex)

 {

 obj = null;

 MessageBox.Show("Unable to release the Object " + ex.ToString());

 }

 finally

 {

 GC.Collect();

 }

 }

 }

}