Description: 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
File list (Check if you may need any files):
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
.....
Download