예제 #1
0
 public FrmExcel(string selectedFilePath)
 {
     InitializeComponent();
     var aprintdialog = new PrintDgv();
     ctrlExcel1.RetrieveWorkbook
         (
             selectedFilePath,
             aprintdialog);
 }
예제 #2
0
        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
                        );
                }
            }
        }
예제 #3
0
        public FrmExcel(
            bool showDateTime,
            PrintDgv aprintdialog)
        {
            InitializeComponent();
            string aGet =
                "SELECT '' ,`LWG_START` AS Date,  `LWG_CATEGORIES` AS Details, `LWG_INCOME` AS Income, `LWG_MILLEAGE` AS Mileage,  `LWG_MOT_EXPS` AS Mot_Exps, `LWG_PPSA` AS PPSA, `LWG_HP` AS HP, `LWG_TELEPHONE` AS Tel,  `LWG_PLH` AS PLH, `LWG_SUBS` AS Subs, `LWG_CLEANING` AS Cleaning, `LWG_MISC` AS Misc, `LWG_DRAWINGS` AS Drawings, `LWG_BIKE` AS Bike,`LWG_OTHER` AS Other, `LWG_ADD_INFO` AS Additional_Info FROM `LWG_DIARY`"
                +
                " WHERE (`LWG_START` BETWEEN '" + GlobalSettings.ADateFrom + "' AND '" + GlobalSettings.ADateTo + "')";
            var dgv = new DataGridView();
            dgv = MySqlConnec.GetSetUpdateQueryData
                (
                    MySqlConnec.ConDataBase,
                    aGet,
                    dgv);

            if ((((DataTable) (dgv.DataSource)).Rows.Count <= 0))
            {
                return;
            }
            try
            {
                string currentLocation = AppDomain.CurrentDomain.BaseDirectory + "LogFileExports\\";
                Directory.CreateDirectory(currentLocation);
                ((DataTable)(dgv.DataSource)).Columns[1].DataType = typeof(string);
                string aFileLocation = DataTableToExcel.MyDataTableExtensions.ExportToExcel
                    (
                        (DataTable) (dgv.DataSource),
                        currentLocation);

                try
                {
                    ctrlExcel1.RetrieveWorkbook
                        (
                            aFileLocation,
                            aprintdialog);

                }
                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
                    );
            }
        }
예제 #4
0
 public void RetrieveWorkbook(
     string xlfile,
     PrintDgv aprintdialog)
 {
     aPrintdial = aprintdialog;
     dataGridView1.DataSource = Data(xlfile);
     var dgvstyle = new DataGridViewCellStyle
                    {
                        Format = "dd/MM/yyyy"
                    };
     dataGridView1.Columns[1].DefaultCellStyle = dgvstyle;
     if (dataGridView1.Columns.Count > 0)
     {
         dataGridView1.Columns[0].Visible = false;
     }
 }