Introduction - If you have any usage issues, please Google them yourself
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