手机网站版面设计,制作微信小程序的教程,做网站需要写配置文件吗,中国制造网国际站在用Excel作报表的时候#xff0c;可能需要操作单元格的边框和填充颜色和纹理等操作#xff0c;下面的代码说明如何设置选中的单元格的填充纹理和边框try{ThisApplication new Excel.Application();ThisWorkbook ThisApplication.Workbooks.Open(z:\\Book1.xls… 在用Excel作报表的时候可能需要操作单元格的边框和填充颜色和纹理等操作下面的代码说明如何设置选中的单元格的填充纹理和边框 try { ThisApplication new Excel.Application(); ThisWorkbook ThisApplication.Workbooks.Open(z:\\Book1.xls, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); ThisApplication.DisplayAlerts false; xlSheet (Excel.Worksheet)ThisWorkbook.Worksheets.get_Item(1); Excel.Range range xlSheet.get_Range(G4,H5); range.Value 123; Excel.Style st ThisWorkbook.Styles.Add(PropertyBorder, Type.Missing); range.Interior.Pattern Excel.XlPattern.xlPatternCrissCross; range.Borders.Weight 2; range.Borders.get_Item(XlBordersIndex.xlEdgeRight).LineStyle Excel.XlLineStyle.xlContinuous; range.Borders.get_Item(XlBordersIndex.xlEdgeBottom).LineStyle Excel.XlLineStyle.xlContinuous; range.Borders.get_Item(XlBordersIndex.xlEdgeTop).LineStyle Excel.XlLineStyle.xlContinuous; range.Borders.get_Item(XlBordersIndex.xlDiagonalDown).LineStyle Excel.XlLineStyle.xlLineStyleNone; range.Borders.get_Item(XlBordersIndex.xlDiagonalUp).LineStyle Excel.XlLineStyle.xlLineStyleNone; range.Borders.get_Item(XlBordersIndex.xlInsideHorizontal).LineStyle Excel.XlLineStyle.xlLineStyleNone; range.Borders.get_Item(XlBordersIndex.xlInsideVertical).LineStyle Excel.XlLineStyle.xlLineStyleNone; range.Borders.get_Item(XlBordersIndex.xlEdgeLeft).LineStyle Excel.XlLineStyle.xlDot; range.Borders.get_Item(XlBordersIndex.xlEdgeLeft).Color System.Drawing.ColorTranslator.ToOle(Color.Red); ThisWorkbook.SaveAs(z:\\Book2.xls, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { ThisWorkbook.Close(Type.Missing, Type.Missing, Type.Missing); ThisApplication.Workbooks.Close(); ThisApplication.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(ThisWorkbook); System.Runtime.InteropServices.Marshal.ReleaseComObject(ThisApplication); ThisWorkbook null; ThisApplication null; GC.Collect(); this.Close(); } 转载于:https://www.cnblogs.com/fmxyw/archive/2008/09/09/1287848.html
