Object missing = System.Reflection.Missing.Value; //indicates missing I province object
SaveFileDialog Savedialog = new SaveFileDialog () ; Savedialog. Filter = "(*.xlsx) |*.xlsx| (*.xls) |*.xls "; Savedialog. Title = "lead to Excel"; if (savedialog. ShowDialog () = = DialogResult.OK) { Microsoft.Office.Interop.Excel.ApplicationClass App = new Microsoft.Office.Interop.Excel.ApplicationClass ();//microsoft.office.interop.excel.workbook Workbook = App.workbooks._open ("C:/Documents and Settings/ad ministrator/Desktop/windowsforms/windowsforms/20130122.xlsx ", missing, missing, missing, missing, missing, missing, Missing, missing, missing, missing, missing, missing);//"/" is used on the system, and "\" is generally used on the network, so you need to escape with the @ symbol Microsoft.Office.Interop.Excel.Workbook Workbook = App.workbooks._open (system.environment.currentdirectory+ @ "\windowsforms\ Windowsforms\20130122.xlsx ", missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, MI ssing, missing); Microsoft.Office.Interop.Excel.Worksheet Worksheet = (Microsoft.Office.Interop.Excel.Worksheet) workbook. worksheets[1]; Microsoft.Office.Interop.Excel.Range Range = Worksheet.get_range ("A3", "C3"); object[] Objectdata ={"123", "123", "123"}; range. Value2 = objectdata; App.displayalerts = false;//Disable the Save dialog boxWorkbook. SaveCopyAs (Savedialog. FileName); Workbook. Close (missing, missing, missing); App.displayalerts = true; App.Quit (); Gc. Collect (); MessageBox.Show ("Export succeeded! "," Excel ", MessageBoxButtons.OK); }