文件名称:GemBox.ExcelLite

介绍说明--下载内容均来自于网络,请自行研究使用

导出Excel组件(B/S或C/S都可以用)



using GemBox.ExcelLite //引用文件

ExcelFile excelFile = new ExcelFile()

ExcelWorksheet sheet = excelFile.Worksheets.Add("WolfSpider")

int columns = dataGridView1.Columns.Count

int rows = dataGridView1.Rows.Count

for (int j = 0 j < columns j++ )

{

sheet.Cells[0, j].Value = dataGridView1.Columns[j].HeaderText

}

for (int i = 1 i <= rows i++)

{

for (int j = 0 j < columns j++)

{

sheet.Cells[i, j].Value = dataGridView1[j, i-1].Value

}

}

excelFile.SaveXls("./guyun.xls") //这里的文件名可以任意定义 -Excel export component (B/S or C/S can be used) using GemBox.ExcelLite // reference document ExcelFile excelFile = new ExcelFile () ExcelWorksheet sheet = excelFile.Worksheets.Add ( " WolfSpider" ) int columns = dataGridView1.Columns.Count int rows = dataGridView1.Rows.Count for (int j = 0 j < columns j++) (sheet.Cells [0, j]. Value = dataGridView1.Columns [j]. HeaderText ) for (int i = 1 i < = rows i++) (for (int j = 0 j < columns j++) (sheet.Cells [i, j]. Value = dataGridView1 [j, i-1]. Value )) excelFile.SaveXls ( " ./guyun.xls" ) // here the file name can be defined
(系统自动生成,下载前可以参看下载内容)

下载文件列表

GemBox.ExcelLite

................\GemBox.ExcelLite

................\................\AbstractRange.cs

................\................\AbsXLSRec.cs

................\................\AbsXLSRecords.cs

................\................\Area3dFormulaToken.cs

................\................\AreaErr3dFormulaToken.cs

................\................\AreaFormulaToken.cs

................\................\ArrayFormulaToken.cs

................\................\bin

................\................\...\Debug

................\................\...\.....\GemBox.ExcelLite.dll

................\................\...\.....\GemBox.ExcelLite.pdb

................\................\BinaryOperatorFormulaToken.cs

................\................\BinaryWritable.cs

................\................\BOFSubstreamType.cs

................\................\BoolFormulaToken.cs

................\................\BoundSheetRecord.cs

................\................\BoundSheetSheetType.cs

................\................\BoundSheetVisibility.cs

................\................\Buffer.cs

................\................\CellBorder.cs

................\................\CellBorders.cs

................\................\CellFormula.cs

................\................\CellRange.cs

................\................\CellRangeEnumerator.cs

................\................\CellRecordHeader.cs

................\................\CellStyle.cs

................\................\CellStyleCachedCollection.cs

................\................\CellStyleData.cs

................\................\CellStyleDataIndexes.cs

................\................\ColumnInfoOptions.cs

................\................\ContinueRecord.cs

................\................\ControlFormulaToken.cs

................\................\CsvType.cs

................\................\DBCellRecord.cs

................\................\DefaultRowHeightOptions.cs

................\................\ErrFormulaToken.cs

................\................\ExcelCell.cs

................\................\ExcelCellCollection.cs

................\................\ExcelColumn.cs

................\................\ExcelColumnCollection.cs

................\................\ExcelColumnRowBase.cs

................\................\ExcelFile.cs

................\................\ExcelFillPattern.cs

................\................\ExcelFont.cs

................\................\ExcelFontData.cs

................\................\ExcelLite.cs

................\................\ExcelLongString.cs

................\................\ExcelLongStrings.cs

................\................\ExcelRow.cs

................\................\ExcelRowCollection.cs

................\................\ExcelRowColumnCellCollectionBase.cs

................\................\ExcelRowColumnCollectionBase.cs

................\................\ExcelShortString.cs

................\................\ExcelStringBase.cs

................\................\ExcelStringOptions.cs

................\................\ExcelStringWithoutLength.cs

................\................\ExcelWorksheet.cs

................\................\ExcelWorksheetCollection.cs

................\................\ExternsheetRecord.cs

................\................\ExtSSTRecord.cs

................\................\FillPatternStyle.cs

................\................\FontOptions.cs

................\................\FormulaFunctionInfo.cs

................\................\FormulaFunctionsTable.cs

................\................\FormulaOptions.cs

................\................\FormulaParser.cs

................\................\FormulaRecord.cs

................\................\FormulaToken.cs

................\................\FormulaTokenClass.cs

................\................\FormulaTokenCode.cs

................\................\FormulaTokensFactory.cs

................\................\FormulaTokenType.cs

................\................\FormulaTokenTypeEx.cs

................\................\FunctionFormulaToken.cs

................\................\FunctionVarFormulaToken.cs

.....

相关说明

  • 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
  • 本站是交换下载平台,提供交流渠道,下载内容来自于网络,除下载问题外,其它问题请自行百度更多...
  • 请直接用浏览器下载本站内容,不要使用迅雷之类的下载软件,用WinRAR最新版进行解压.
  • 如果您发现内容无法下载,请稍后再次尝试;或者到消费记录里找到下载记录反馈给我们.
  • 下载后发现下载的内容跟说明不相乎,请到消费记录里找到下载记录反馈给我们,经确认后退回积分.
  • 如下载前有疑问,可以通过点击"提供者"的名字,查看对方的联系方式,联系对方咨询.

相关评论

暂无评论内容.

发表评论

*主  题:
*内  容:
*验 证 码:

源码中国 www.ymcn.org