I can see a full set of common operations on C # excel on the Internet, which is comprehensive and well written.
Address: http://hi.baidu.com/kjkj911/blog/item/0ecc3ec7855dd6d4d100600f.html
Private _ Workbook = Null ; Private Worksheet _ worksheet = Null ; Private Excel. Application _ excelapplicatin = Null ; _ Excelapplicatin = New Excel. Application (); _ excelapplicatin. Visible = True ; _ Excelapplicatin. displayalerts = True ; _ Workbook = _ excelapplicatin. workbooks. Add (xlsheettype. xlworksheet); _ worksheet = (worksheet) _ Workbook. activesheet; _ worksheet. Name = "Worksheetname" ; // Open an existing Excel File String Strexcelpathname = appdomain. currentdomain. basedirectory + "Excelsheetname.xls" Excel. workbook workbook = application. workbooks. open (strexcelpathname, type. missing, type. missing, type. missing, type. missing, type. missing, type. missing, type. missing, type. missing, type. missing, type. missing, type. missing, type. missing ); // Read the opened Excel File Excel. worksheet worksheet1 = (Excel. worksheet) Workbook. Sheets [ "Sheetname1" ]; Excel. worksheet worksheet2 = (Excel. worksheet) Workbook. Sheets [ "Sheetname2" ]; // Add a worksheet Worksheet worksheet = (worksheet) Workbook. worksheets. Add (system. type. Missing, system. type. Missing ); // Rowheight "" indicates the first line, and "" indicates the first line and the second line. (Excel. Range) _ worksheet. Rows [ "1:1" , System. type. Missing]). rowheight = 100; // Columnwidth "A: B" indicates the first and second columns, and "A: A" indicates the first column. (Excel. Range) _ worksheet. Columns [ "A: B" , System. type. Missing]). columnwidth = 10; // Excel operation (hold down the frozen field Alt + W and then press F) Excel. range excelrange = _ worksheet. get_range (_ worksheet. cells [10, 5], _ worksheet. cells [10, 5]); excelrange. select (); excelapplication. activewindow. freezepanes = True ; // Borders. linestyle cell border line Excel. Range excelrange = _ worksheet. get_range (_ worksheet. cells [2, 2], _ worksheet. cells [4, 6]); // Cell border line type (line type, dotted line type) Excelrange. Borders. linestyle = 1; excelrange. Borders. get_item (xlbordersindex. xledgetop). linestyle = excel. xllinestyle. xlcontinuous; // Specify the width and color of the box below the cell Excelrange. Borders. get_item (xlbordersindex. xledgebottom). Weight = excel. xlborderweight. xlmedium; excelrange. Borders. get_item (xlbordersindex. xledgebottom). colorindex = 3; // Set the font size Excelrange. Font. size = 15;// Set whether the font contains underscores. Excelrange. Font. Underline = True ; // Set the font type in the cell. Excelrange. horizontalalignment = xlhalign. xlhaligncenter; // Set the cell width Excelrange. columnwidth = 15; // Set the cell background color Excelrange. cells. Interior. Color = system. Drawing. color. fromargb (255,204,153). toargb (); // Add a border to the cell bar Excelrange. borderaround (xllinestyle. xlcontinuous, xlborderweight. xlthick, xlcolorindex. xlcolorindexautomatic, system. Drawing. color. Black. toargb ()); // Automatically adjust the column width Excelrange. entirecolumn. autofit (); // Horizontal text center Mode Excelrange. horizontalalignment = excel. xlhalign. xlhaligncenter; // Text wrap Excelrange. wraptext = True ; // The fill color is lavender. Excelrange. Interior. colorindex = 39; // Merge Cells Excelrange. Merge (excelrange. mergecells); _ worksheet. get_range ( "A15" , "B15" ). Merge (_ worksheet. get_range ( "A15" , "B15" ). Mergecells ); /// <Summary> /// Definition of common colors. /// </Summary> Public Enum Colorindex {colorless =-4142, automatic =-4105, black = 1, brown = 53, Olive = 52, dark green = 51, dark blue = 49, dark blue = 11, indigo = 55, gray 80 = 56, dark red = 9, Orange = 46, dark yellow = 12, Green = 10, Blue = 14, Blue = 5, blue gray = 47, gray 50 = 16, red = 3, light orange = 45, Acid Orange = 43, sea green = 50, water green = 42, light blue = 41, Violet = 13, gray 40 = 48, pink = 7, gold = 44, yellow = 6, fresh green = 4, Green = 8, Sky Blue = 33, merceon = 54, gray 25 = 15, Rose Red = 38, brown = 40, light yellow = 36, light green = 35, light blue = 34, light blue = 37, light purple = 39, white = 2}
-
- Range. numberformatlocal = "@"; // set the cell format to text.
-
-
- Range = (range) worksheet. get_range ("A1", "E1"); // obtain multiple cells in Excel. In this example, the table is used as the Excel header.
-
-
- Range. Merge (0); // cell merge action
-
- Worksheet. cells [1, 1] = "Excel cell assignment"; // Excel cell assignment
-
-
- Range. Font. size = 15; // set the font size.
-
-
- Range. Font. Underline =True; // Set whether the font contains underscores
-
-
- Range. Font. Name = ""; set the font type
-
-
- Range. horizontalalignment = xlhalign. xlhaligncenter; // you can specify the font type in a cell.
-
-
- Range. columnwidth = 15; // you can specify the cell width.
-
-
- Range. cells. Interior. Color = system. Drawing. color. fromargb (255,204,153). toargb (); // you can specify the background color of a cell.
-
-
- Range. Borders. linestyle = 1; // you can specify the Border width of a cell.
-
- Range. borderaround (xllinestyle. xlcontinuous, xlborderweight. xlthick, xlcolorindex. xlcolorindexautomatic, system. Drawing. color. Black. toargb (); // border the cell
-
-
- Range. borders. get_item (Microsoft. office. interOP. excel. xlbordersindex. xledgetop ). linestyle = Microsoft. office. interOP. excel. xllinestyle. xllinestylenone; // you can specify no border as the upper border of a cell.
-
-
- Range. entirecolumn. autofit (); // automatically adjusts the column width.
-
-
- Range. horizontalalignment = xlcenter; // horizontal text center Mode
-
-
- Range. verticalignment = xlcenter // text vertical center Mode
-
-
- Range. wraptext =True; // Text wrap
-
- Range. Interior. colorindex = 39; // fill color is lavender
-
-
- Range. Font. Color = clblue; // font color
-
-
- Xlsapp. displayalerts =False; // When saving the Excel file, save the file directly without the pop-up window.