[生成excel文档即便没有安装微软Excel.docVIP

生成excel文档即便没有安装微软Excel2012-06-28 07:29:00 AM 下载：见/happyfish78/Acey.ExcelX.Setup.zip 介绍 我们经常需要创建Excel文档，你会花很多时间，如何才能简单并且快速的生成Excel文档。 下面我为你们介绍Acey.ExcelX产品。 Acey.ExcelX是基于.NET Framework version 2.0，你能在客户电脑和服务器上生成excel文档即使没有安装微软Excel的情况下. Acey.ExcelX提供支持很多基础功能和高级功能，这些功能能很简单和方便帮开发者操纵内容。 Acey.ExcelX为开发者提供很多C#和VB.NET的Demo能更好的让开发者所理解。 Sample 下面提供一些如何简单使用Acey.ExcelX，更详细的Demo见安装包中Sample。 Example 1 ??? 如何插入值和公式到excel文档中？??? IWorkbook workbook =?ExcelxApplication.CreateWorkbook();//获取一个Worksheet对象集合在Workbook对象中.IWorksheetCollection worksheets =?workbook.Worksheets;//Gets a Worksheet object by using zero-based worksheet index.IWorksheet worksheet = worksheets[0];//Gets a Cell object using cell name.ICell cell = worksheet.Cells[A1];//Sets interger value to the Cell object.cell.Value =?12;//Gets a Cell object using zero-based row and column index.cell = worksheet.Cells[1,?0];//Sets formual to the Cell object.cell.Formula =?=SUM(3,3);//Saves to excel file.?workbook.SaveAs(@D:\book1.xls, FileFormat.Excel97To2003); Exampe 2 ?? 如何能隐藏Row在Excel文档中？?? ? [C#] ??? 1?How to hide row?in?the worksheet?2?[C#]3?//Creates a Workbook object.4?IWorkbook workbook =?ExcelxApplication.CreateWorkbook();5?//Gets a Worksheet object by using zero-based index.6?IWorksheet worksheet = workbook.Worksheets[0];7?//Gets a Row object collection in the Worksheet.?8?IRowCollection rows =?worksheet.Rows;9?//Gets a Row object using zero-based index.10?IRow row = rows[0];11?//Hides the Row object.12?row.IsHidden =?true;13?//Saves to excel file.?14?workbook.SaveAs(@D:\hideRow.xls, FileFormat.Excel97To2003);15?16?or17?//Creates a Workbook object.18?IWorkbook workbook =?ExcelxApplication.CreateWorkbook();19?//Gets a Worksheet object by using zero-based index.20?IWorksheet worksheet = workbook.Worksheets[0];21?//Hides the specified row by using zero-based index.22?worksheet.HideRow(0);23?//Saves to excel file.?24?workbook.SaveAs(@D:\merge.xls, FileFormat.Excel97To2003); Example 3??