ASP. Net daily development notes ---- export to excel

using Aspose.Cells;


public void btnExcel_Click(object sender, EventArgs e)
{
    
       Workbook workbook = new Workbook();
        workbook.Worksheets.Clear();
        workbook.Worksheets.Add("sheet1");

       Worksheet worksheet = workbook.Worksheets[0];
        Cells cells = worksheet.Cells;

        MergeCell(cells, " Content ", int, int, int, int, workbook);// If you need to merge cells, add this sentence  cells.Merge( Start with the line , From which column  , Merge several lines  , Merge several columns  );

-------------------- Loop of merged cells -------------------------
         for (int i = 0; i <  There are several columns ; i++)
        {
    
            for (int j = 0; j <=  A total of rows have been merged ; j++)
            {
    
                cells[j, i].SetStyle(CreateStyle(workbook));
                cells.Columns[i].Width = 15;// Set the width of each cell 
            }
        }
--------------------------------------------------------------------
------------------- Loop without merging ---------------------------------
       for (int i = 0; i < 23; i++)
        {
    
            cells[0, i].SetStyle(CreateStyle(workbook));
            cells.Columns[i].Width = 15;// Set the width of each cell 
        }
----------------------------------------------------------------------
      int rowIndex = The index of the row where the data starts ;
      IList<>  Data source collection = ;

       foreach (var item in  Data source collection )
        {
    
            MergeCell(cells, item. data 1, rowIndex, 0, 1, 1, workbook);
            MergeCell(cells, item. data 2, rowIndex, 1, 1, 1, workbook);
            rowIndex++;
        }
       string exportFileName = HttpUtility.UrlEncode(" Generate excel Name " + DateTime.Now.ToString("yyyyMMddHHmm") + ".xlsx");
        workbook.Save(exportFileName, FileFormatType.Xlsx, SaveType.OpenInExcel, Response);
        Response.End();
}

--------  Copy available 
    /// <summary>
    ///  merge cell 
    /// </summary>
    /// <param name="cells"> Cell </param>
    /// <param name="value"> Displayed value </param>
    /// <param name="rBegin"> The first few lines begin </param>
    /// <param name="cBegin"> Which column begins </param>
    /// <param name="rCount"> How many rows are merged </param>
    /// <param name="cCount"> How many columns are merged </param>
    public void MergeCell(Cells cells, string value, int rBegin, int cBegin, int rCount, int cCount, Workbook workbook)
    {
    
        cells.Merge(rBegin, cBegin, rCount, cCount);
        cells[rBegin, cBegin].PutValue(value);
        cells[rBegin, cBegin].SetStyle(CreateStyle(workbook));
    }



    /// <summary>
    ///  Set the style 
    /// </summary>
    /// <param name="workbook"></param>
    /// <returns></returns>
    private Aspose.Cells.Style CreateStyle(Workbook workbook)
    {
    
        Aspose.Cells.Style style = workbook.Styles[workbook.Styles.Add()];
        style.HorizontalAlignment = TextAlignmentType.Center;
        style.VerticalAlignment = TextAlignmentType.Center;
        style.IsTextWrapped = true;
        style.Font.IsBold = true;
        style.Font.Size = 11;
        style.Font.Color = System.Drawing.Color.Black;
        style.Pattern = BackgroundType.Solid;
        style.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;
        style.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;
        style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;
        style.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;
        return style;
    }