private void PrepareData() { _aLogBookForm = new FrmExcel ( true, new PrintDgv()) { TopMost = true, StartPosition = FormStartPosition.CenterScreen }; _aLogBookForm.Show(); }
private void ExportToExcel(DataTable calendarData) { if (calendarData != null) { var aprintdialog = new PrintDgv(); try { string currentLocation = AppDomain.CurrentDomain.BaseDirectory + "LogFileExports\\"; Directory.CreateDirectory(currentLocation); string aFileLocation = DataTableToExcel.MyDataTableExtensions.ExportToExcel ( calendarData, currentLocation); try { var afrmExcel = new FrmExcel(); afrmExcel.ctrlExcel1.RetrieveWorkbook ( aFileLocation, aprintdialog); afrmExcel.Show(); } catch (Exception e) { MessageDialog.Show ( "ExportToExcel: Excel file could not be Opened!\n", e.Message, MessageDialog.MessageBoxButtons.Ok, MessageDialog.MessageBoxIcon.Error, e.Message + "\r\n\r\n" + e.StackTrace ); } } catch (Exception e) { MessageDialog.Show ( "ExportToExcel: Excel file could not be Opened!\n", e.Message, MessageDialog.MessageBoxButtons.Ok, MessageDialog.MessageBoxIcon.Error, e.StackTrace ); } } }
private void GetSetFileType( string extension, string selectedFilePath) { if (!IsImageFile.IsRecognisedImageFile(selectedFilePath)) { FrmExcel aFrmExcel; FrmWord aFrmWord; switch (extension) { case "xlsx": aFrmExcel = new FrmExcel(selectedFilePath); aFrmExcel.Show(); break; case "xla": aFrmExcel = new FrmExcel(selectedFilePath); aFrmExcel.Show(); break; case "xls": aFrmExcel = new FrmExcel(selectedFilePath); aFrmExcel.Show(); break; case "xlam": aFrmExcel = new FrmExcel(selectedFilePath); aFrmExcel.Show(); break; case "doc": aFrmWord = new FrmWord(selectedFilePath); aFrmWord.Show(); break; case "docx": aFrmWord = new FrmWord(selectedFilePath); aFrmWord.Show(); break; case "txt": aFrmWord = new FrmWord(selectedFilePath); aFrmWord.Show(); break; case "rtf": aFrmWord = new FrmWord(selectedFilePath); aFrmWord.Show(); break; } } else { var aPricture = new FrmPricture(selectedFilePath); aPricture.Show(); } }