C # Excel Row Height, column width, merge cells, cell border line, freeze

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 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 opened Excel files. worksheet worksheet1 = (Excel. worksheet) workbook. sheets ["sheetname1"]; excel. worksheet worksheet2 = (Excel. worksheet) workbook. sheets ["sheetname2"]; // Add a worksheet = (worksheet) workbook. worksheets. add (system. type. missing, system. type. missing, system. type. missing, system. type. missing); // rowheight "" indicates the first line, "" 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 Alt + W for frozen fields 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 box width and color excelrange under the cell. borders. get_item (xlbordersindex. xledgebottom ). weight = excel. xlborderweight. xlmedium; excelrange. borders. get_item (xlbordersindex. xledgebottom ). colorindex = 3; // set the font size to excelrange. font. size = 15; // set whether the font contains the underline excelrange. font. underline = true; // sets the excelrange for the font in the cell. horizontalalignment = xlhalign. xlhaligncenter; // sets 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 excelrange to the cell. borderaround (xllinestyle. xlcontinuous, xlborderweight. xlthick, xlcolorindex. xlcolorindexautomatic, system. drawing. color. black. toargb (); // automatically adjusts the column width excelrange. entirecolumn. autofit (); // excelrange in horizontal text center mode. 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, for the color name in Excel /// </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, Blue = 33, merceon = 54, gray 25 = 15, Rose Red = 38, brown = 40, light yellow = 36, light Green = 35, light green = 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, range is used as the Excel header. merge (0); // cell merging 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 an underline range. font. name = ""; set the font type range. horizontalalignment = xlhalign. xlhaligncenter; // set the font range in the cell. columnwidth = 15; // set the cell width range. cells. interior. color = system. drawing. color. fromargb (255,204,153 ). toargb (); // set the background color range of the cell. borders. linestyle = 1; // set the width range of the cell border. borderaround (xllinestyle. xlcontinuous, xlborderweight. xlthick, xlcolorindex. xlcolorindexautomatic, system. drawing. color. black. toargb (); // Add a border range to the cell. borders. get_item (Microsoft. office. interOP. excel. xlbordersindex. xledgetop ). linestyle = Microsoft. office. interOP. excel. xllinestyle. xllinestylenone; // set the upper border of the cell to no border range. entirecolumn. autofit (); // Auto adjust the column width range. horizontalalignment = xlcenter; // range of text horizontally centered. verticalalignment = xlcenter // text vertical center mode range. wraptext = true; // Text wrap range. interior. colorindex = 39; // The fill color is lavender range. font. color = clblue; // font color xlsapp. displayalerts = false; // when you save an Excel file, the Save or not window is not displayed and saved directly.