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);
}
