Objective
As a member of the Project Management Brigade, the most contact in the company is the Excel file, so from the beginning, I want to start with Excel, learn a simple two times to develop, start their own programming road!
Program Interface
Function description
The Open File button allows the user to specify the Excel file to manipulate and displays the file path in a later textbox.
Set the cell button to set the contents of the Excel file according to the program.
Exit the program button to close the form.
Program source Code
1 usingSystem;2 usingSystem.Collections.Generic;3 usingSystem.ComponentModel;4 usingSystem.Data;5 usingSystem.Drawing;6 usingSystem.Linq;7 usingSystem.Text;8 usingSystem.Windows.Forms;9 usingSystem.Reflection;Ten usingMicrosoft.Office.Interop.Excel; One namespaceExcelreadandwrite A { - Public Partial classForm1:form - { the PublicString filename =string. Empty; - PublicForm1 () - { - InitializeComponent (); + } - /// <summary> + ///Open the Excel file, and set the value of the setting cell A /// </summary> at /// <param name= "Sender" ></param> - /// <param name= "E" ></param> - Private voidButton1_Click (Objectsender, EventArgs e) - { - if(Textbox_filename.text! ="") - { in //This is a way to read an Excel file -Microsoft.Office.Interop.Excel.Application app =NewMicrosoft.Office.Interop.Excel.Application (); toWorkbook Wbook =app. Workbooks.Open (filename, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, + Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, type.missing); - theWorksheet Worksheet = (Worksheet) wbook. worksheets[1]; *Worksheet. cells[1,1] ="ID"; $Worksheet. cells[1,2] ="Value";Panax Notoginseng for(inti =2; I < -; i++ ) - { theWorksheet. Cells[i,1] =i.tostring (); +Worksheet. Cells[i,2] = i *i; A } theMessageBox.Show ("has been set up successfully! "); + - //Save and exit an Excel file $ Wbook. Save (); $Worksheet =NULL; -Wbook =NULL; - app. Quit (); theApp =NULL; - }Wuyi Else the { -MessageBox.Show ("file not specified yet! "); Wu } - } About /// <summary> $ ///Close the form - /// </summary> - /// <param name= "Sender" ></param> - /// <param name= "E" ></param> A Private voidButton_quit_click (Objectsender, EventArgs e) + { the This. Close (); - } $ /// <summary> the ///gets the filename of the specified file the /// </summary> the /// <param name= "Sender" ></param> the /// <param name= "E" ></param> - Private voidButton_openfile_click (Objectsender, EventArgs e) in { theOpenFileDialog OFD =NewOpenFileDialog (); theOfd. InitialDirectory ="e:\\"; AboutOfd. Filter="Excel file |*.xlsx"; theOfd. Restoredirectory =true; theOfd. FilterIndex =1; the if(OFD. ShowDialog () = =DialogResult.OK) + { -filename =OFD. FileName; theTextbox_filename.text =filename;Bayi } the } the } -}
Excel action "1" in C #--a way to set the contents of an Excel cell to open an Excel file