WriteGraphMetricColumnsToWorkbook() public method

public WriteGraphMetricColumnsToWorkbook ( GraphMetricColumn graphMetricColumns, Microsoft workbook ) : void
graphMetricColumns GraphMetricColumn
workbook Microsoft
return void
コード例 #1
0
        WriteGraphMetricsToWorkbook
        (
            Microsoft.Office.Interop.Excel.Workbook oWorkbook,
            GraphMetricColumn [] aoGraphMetricColumns
        )
        {
            Debug.Assert(oWorkbook != null);
            Debug.Assert(aoGraphMetricColumns != null);

            GraphMetricWriter oGraphMetricWriter = new GraphMetricWriter();

            oGraphMetricWriter.WriteGraphMetricColumnsToWorkbook(
                aoGraphMetricColumns, oWorkbook);

            oGraphMetricWriter.ActivateRelevantWorksheet(aoGraphMetricColumns,
                                                         oWorkbook);
        }
コード例 #2
0
        WriteGraphMetricColumnsToWorkbook
        (
            GraphMetricColumn [] aoGraphMetricColumns
        )
        {
            Debug.Assert(aoGraphMetricColumns != null);
            AssertValid();

            Microsoft.Office.Interop.Excel.Application oApplication =
                m_oWorkbook.Application;

            GraphMetricWriter oGraphMetricWriter = new GraphMetricWriter();

            oApplication.ScreenUpdating = false;

            try
            {
                oGraphMetricWriter.WriteGraphMetricColumnsToWorkbook(
                    aoGraphMetricColumns, m_oWorkbook);

                if (m_bActivateRelevantWorksheetWhenDone)
                {
                    // Let the user know that graph metrics have been calculated.

                    oGraphMetricWriter.ActivateRelevantWorksheet(
                        aoGraphMetricColumns, m_oWorkbook);
                }
            }
            catch (Exception oException)
            {
                oApplication.ScreenUpdating = true;

                ErrorUtil.OnException(oException);

                this.Close();
                return;
            }

            oApplication.ScreenUpdating = true;
        }
コード例 #3
0
    WriteGraphMetricColumnsToWorkbook
    (
        GraphMetricColumn [] aoGraphMetricColumns
    )
    {
        Debug.Assert(aoGraphMetricColumns != null);
        AssertValid();

        Microsoft.Office.Interop.Excel.Application oApplication =
            m_oWorkbook.Application;

        GraphMetricWriter oGraphMetricWriter = new GraphMetricWriter();

        oApplication.ScreenUpdating = false;

        try
        {
            oGraphMetricWriter.WriteGraphMetricColumnsToWorkbook(
                aoGraphMetricColumns, m_oWorkbook);

            if (m_bActivateRelevantWorksheetWhenDone)
            {
                // Let the user know that graph metrics have been calculated.

                oGraphMetricWriter.ActivateRelevantWorksheet(
                    aoGraphMetricColumns, m_oWorkbook);
            }
        }
        catch (Exception oException)
        {
            oApplication.ScreenUpdating = true;

            ErrorUtil.OnException(oException);

            this.Close();
            return;
        }

        oApplication.ScreenUpdating = true;
    }