Esempio n. 1
0
    private void ToExcel()
    {
        int columnCount = m_dataGridMarks.ColumnCount;

        using (ExcelWorker excel = new ExcelWorker())
        {
            excel.SetText(1, columnCount, GetExcelText());
            excel.WrapText(1, 1, m_dataGridMarks.RowCount,
                           columnCount, true);
            excel.SetColumnWidth(1, 1, 20);
            excel.WriteDataGrid(m_dataGridMarks);
            excel.Orientation90(2, 2, 1, columnCount - 1);
            excel.SkipRow();
            excel.SetText(columnCount - 2, 1, "Всего");
            excel.SetText(columnCount - 1, 1, GetSumSkips().ToString());
            excel.SetText(columnCount, 1, GetSumDisrespectSkips().ToString());
            excel.WriteDataGrid(GetMarksCountDataDrid());
            excel.Visible = true;
        }
    }