示例#1
0
        //Botton "Export Data"
        private void button1_Click(object sender, RibbonControlEventArgs e)
        {
            try
            {
                int START_ROW = 9;
                int START_COL = 3;
                Excel.Worksheet active_worksheet = Globals.ThisAddIn.Application.ActiveSheet;

                //Acquire Target Data and Export
                Target TargetData = new Target();
                TargetData.GetData(active_worksheet);
                TargetData.ExportData();

                //Acquire Comparable Data and Export
                for (int col_index = START_COL; active_worksheet.Cells[START_ROW, col_index].Value != null ; col_index ++)
                {
                    Comparable comparable_data = new Comparable();
                    comparable_data.GetData(active_worksheet, START_ROW, col_index);
                    comparable_data.ExportData();
                }

                MessageBox.Show("Successfully export data.");
            }
            catch (Exception exception)
            {
                Debug.WriteLine(exception.ToString());

            }
        }