public CellInfo(ExcelDocument document) { BackColor = ExcelColor.Automatic; ForeColor = ExcelColor.Automatic; Font = document.DefaultFont; this.Document = document; }
public static void ExportToExcel(DataGridView DataGV, string Name) { ExcelDocument document = new ExcelDocument(); document.UserName = "******"; document.CodePage = CultureInfo.CurrentCulture.TextInfo.ANSICodePage; document.ColumnWidth(0, 120); document.ColumnWidth(1, 80); document[0, 0].Value = Name; document[0, 0].Font = new System.Drawing.Font("Tahoma", 10, System.Drawing.FontStyle.Bold); document[0, 0].ForeColor = ExcelColor.DarkRed; document[0, 0].Alignment = Alignment.Centered; document[0, 0].BackColor = ExcelColor.Silver; int i = 1;//стрічка int j = 0;//колонка foreach (DataGridViewRow r in DataGV.Rows) { j = 0; foreach (DataGridViewCell c in r.Cells) { //document.Cell(i,j).Format document.WriteCell(i, j, c.Value == null ? "" : c.Value.ToString()); j++; } i++; } SaveFileDialog saveFileDialog1 = new SaveFileDialog(); saveFileDialog1.FileName = Name; saveFileDialog1.DefaultExt = "xls"; saveFileDialog1.ShowDialog(); FileStream stream = new FileStream(saveFileDialog1.FileName, FileMode.Create); document.Save(stream); stream.Close(); System.Diagnostics.Process.Start(saveFileDialog1.FileName); }
internal Cell(int row, int column, ExcelDocument document) { this.document = document; cellInfo = document.GetCellInfo(row, column); }