文件名称:GemBox.ExcelLite
- 所属分类:
- C#编程
- 资源属性:
- [Windows] [Visual.Net] [Basic/ASP] [源码]
- 上传时间:
- 2012-11-26
- 文件大小:
- 2mb
- 下载次数:
- 0次
- 提 供 者:
- lclc*****
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
导出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
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
ExcelLi
gemb
GemBox
ExcelLite
dll
GemBox
ExcelLite
rar
using
ExcelFile
ExcelWorkshe
using
GemBox
ExcelLite
导出Excel
using
GemBox
ExcelLi
GemBox
ExcelLite
ExcelLite
GemBox
ExcelLi
gemb
GemBox
ExcelLite
dll
GemBox
ExcelLite
rar
using
ExcelFile
ExcelWorkshe
using
GemBox
ExcelLite
导出Excel
using
GemBox
ExcelLi
GemBox
ExcelLite
(系统自动生成,下载前可以参看下载内容)
下载文件列表
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
.....
................\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
.....