private void ContextMenu_export_grfstk(object sender, System.EventArgs e)
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.DefaultExt = "xls";
dlg.Filter = "Excel |*.xls";
dlg.InitialDirectory = ic.iniC.pathSaveExcelAppointment;
dlg.FileName = "*.xls";
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
// clear book
C1XLBook _book = new C1XLBook();
XLSheet sheet = _book.Sheets.Add("stock" + DateTime.Now.ToString("dd-MM-") + DateTime.Now.Year.ToString());
ic.SaveSheet(grfStk, sheet, _book, false);
_book.Sheets.SelectedIndex = 0;
// save the book
_book.Save(dlg.FileName);
if (File.Exists(dlg.FileName))
{
//Process p = new Process();
//p.StartInfo.FileName = dlg.FileName;
//p.Start();
string argument = "/select, \"" + dlg.FileName + "\"";
Process.Start("explorer.exe", argument);
}
}
private void BtnExcel_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
if (grfRptName.Row == 1 && grfRpt.Rows.Count > 0)
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.DefaultExt = "xls";
dlg.Filter = "Excel |*.xls";
dlg.InitialDirectory = ic.iniC.pathSaveExcelAppointment;
dlg.FileName = "*.xls";
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
// clear book
C1XLBook _book = new C1XLBook();
//_book.Clear();
//_book.Sheets.Clear();
// copy grids to book sheets
//foreach (TabPage pg in _tab.TabPages)
//{
// C1FlexGrid grid = pg.Controls[0] as C1FlexGrid;
XLSheet sheet = _book.Sheets.Add("pharmacy");
ic.SaveSheet(grfRpt, sheet, _book, false);
//}
// save selected sheet index
if (_book.Sheets.Count >= 1)
{
_book.Sheets.SelectedIndex = 1;
}
// save the book
_book.Save(dlg.FileName);
Application.DoEvents();
Process.Start("explorer.exe", dlg.FileName);
}
}
