哪位能给点owc的资料?

[chenvictor]

我现在能用owc.spreadclass在服务器上生成.xls文件.
但不知道怎么设置边框和调用模板生成.我用的是office 2000的owc 9.0.
哪位能给点owc的资料?或例子.在此先行谢过.
[e-mail]
[e-mail]

[gOODiDEA]

我以前也是这样做的，但是发现owc.spreadclass实现不了设置excel的字体，颜色等功能（也许是我没用对吧）这能转而用Microsoft.Office.Interop.Excel

实现起来没问题，只是要设置asp.net的权限，而且excel进程很难杀

[howbigsea]

我也用Microsoft.Office.Interop.Excel
owc.spreadclass没有使用过

帮不了你了

[kals]

没有用OWC，直接用Excel.DLL
给一段代码你看看

Excel.Sheets sheets =book.Worksheets;
Excel._Worksheet worksheet =(Excel._Worksheet)sheets.get_Item(1);

Excel.Range range;
range =worksheet.get_Range(worksheet.Cells[1,1],worksheet.Cells[1,14]);
range.MergeCells =true;//合并
range.HorizontalAlignment =Excel.XlHAlign.xlHAlignCenter;//居中
range.Font.Bold =true;
range.Font.Size =14;

//画线
Excel.Range range1;
range1 =worksheet.get_Range(worksheet.Cells[2,1],worksheet.Cells[rowIndex,colIndex]);
range1.Borders[Excel.XlBordersIndex.xlDiagonalDown].LineStyle =Excel.XlLineStyle.xlLineStyleNone;
range1.Borders[Excel.XlBordersIndex.xlDiagonalUp].LineStyle =Excel.XlLineStyle.xlLineStyleNone;
range1.Borders[Excel.XlBordersIndex.xlEdgeLeft].LineStyle =Excel.XlLineStyle.xlContinuous;
range1.Borders[Excel.XlBordersIndex.xlEdgeRight].LineStyle =Excel.XlLineStyle.xlContinuous;
range1.Borders[Excel.XlBordersIndex.xlEdgeTop].LineStyle =Excel.XlLineStyle.xlContinuous;
range1.Borders[Excel.XlBordersIndex.xlEdgeBottom].LineStyle =Excel.XlLineStyle.xlContinuous;
range1.Borders[Excel.XlBordersIndex.xlInsideHorizontal].LineStyle =Excel.XlLineStyle.xlContinuous;
range1.Borders[Excel.XlBordersIndex.xlInsideVertical].LineStyle =Excel.XlLineStyle.xlContinuous;

//拉宽表格
Excel.Range range2;
range2 =worksheet.get_Range(worksheet.Cells[1,1],worksheet.Cells[1,1]);
range2.ColumnWidth =25.8;

[smartyyp]

发给你了

[hareqiqi]

owc在哪个命名空间里
能否发点资料给我，谢谢！
[e-mail]