C#利用Aspose在同一个Excel文件中创建多个sheet

代码如下:

        private void DataGridViewExportSheet(Aspose.Cells.Worksheet sheet, DataGridView dataGridView)
        {
            int irows = dataGridView.RowCount;
            int icols = dataGridView.ColumnCount;

            for (int i = 0; i < icols; i++)
            {
                if (dataGridView.Columns[i].Visible)
                {
                    string fldName = dataGridView.Columns[i].HeaderText;
                    sheet.Cells[0, i].PutValue(fldName);
                }
            }

            for (int i = 0; i < irows; i++)
            {
                for (int j = 0; j < icols; j++)
                {
                    if (dataGridView.Columns[j].Visible)
                    {
                        if (dataGridView.Rows[i].Cells[j].Value != null)
                        {
                            sheet.Cells[i + 1, j].PutValue(dataGridView.Rows[i].Cells[j].Value.ToString());
                        }
                    }
                }
            }
        }

调用方法:

  new Aspose.Cells.License().SetLicense(new MemoryStream(Convert.FromBase64String(Key)));
  workbook = new Aspose.Cells.Workbook();
  Aspose.Cells.Worksheet sheet = workbook.Worksheets[0];
  sheet.Name = "基本信息";
  DataGridViewExportSheet(sheet, dgvzkxx);
  workbook.Save(strpath);

 

C#利用Aspose在同一个Excel文件中创建多个sheet

上一篇:window上VirtualBox扩容虚拟机


下一篇:使用 Kotlin 协程 + Fuel 调用 REST API