using System;
using System.Reflection;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
using System.IO;



namespace WindowsForms_Excel
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // Excel-Instanz erzeugen und sichtbar schalten
            Excel.Application excelBlatt = new Excel.Application();
            excelBlatt.Visible = true;

            string fileName;
            object refmiss = Missing.Value;


            OpenFileDialog opf_dlg = new OpenFileDialog();
            DialogResult dlg = opf_dlg.ShowDialog();
         //   fileName = opf_dlg.FileName;
            //  für Test
            fileName = Path.Combine(Application.StartupPath, "Exceltest.xls");

            Excel.Workbook workbook;
            // Excel-File öffnen
            try
            {
                workbook = excelBlatt.Workbooks.Open(fileName,refmiss, refmiss, refmiss, refmiss, refmiss, refmiss, refmiss, refmiss, refmiss, refmiss, refmiss, refmiss, refmiss, refmiss);
            }
            catch (System.Runtime.InteropServices.COMException ce)
            {
                MessageBox.Show("Fehler beim Öffnen", ce.Message);
            }

public void SearchReplace()
        {
            Microsoft.Office.Interop.Word.Find findObject = Microsoft.Office.Interop.Word.Application.Selection.Find; 


            
            findObject.ClearFormatting();
            findObject.Text = "7.5";
            findObject.Replacement.ClearFormatting();
            findObject.Replacement.Text = "7.05";

            object replaceAll = WdReplace.wdReplaceAll;
            findObject.Execute(ref MISS, ref MISS, ref MISS, ref MISS, ref MISS,
                ref MISS, ref MISS, ref MISS, ref MISS, ref MISS,
                ref replaceAll, ref MISS, ref MISS, ref MISS, ref MISS);
        }

/// <summary>
        /// Numerische TextBox-Prüfung.
        /// </summary>
        /// <param name="obj">Übergabewert der auf Numerik geprüft wird.</param>
        /// <param name="tbx">Instanz der Textbox, für die Datenvisualisierung.</param>
        public void NumerischeTextboxPrüfung(object obj, TextBox tbx)
        {
            bool canConvert = false;
            double dblWert = -999.0;
            int iWert = -999;
            

            if (obj is double)
            {
                canConvert = double.TryParse(tbx.Text, out dblWert);
            }
            if (obj is Int32)
            {
                canConvert = Int32.TryParse(tbx.Text, out iWert);
            }
            if (!canConvert)
            {
                errorProvider.SetError(tbx, "Bitte nur einen Zahlenwert eingeben !");
                tbx.BackColor = Color.Red;
                numerischerFehler = true;       // numersiches Fehlerflag setzen
            }
            if (canConvert)
            {
                errorProvider.SetError(tbx, "");
                errorProvider.Clear();
                tbx.BackColor = Color.GreenYellow;
            }

        }