Calling F9 function in Excel

[NiteshR]

Hi,

Does anyoe know how to call the F9 key function (Calculate Sheet) using C#?

Thanks.

[SammyB]

Hi,

Does anyoe know how to call the F9 key function (Calculate Sheet) using C#?

Thanks.

xlSheet.Calculate();

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel; // Add a reference to Microsoft.Office.Interop.Excel.dll
namespace ExcelInterop
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            // Object for missing (or optional) arguments.
            object oMissing = System.Reflection.Missing.Value;
            // Create an instance of Microsoft Excel, make it visible,
            // and open Book1.xls.
            Excel.ApplicationClass xlApp = new Excel.ApplicationClass();
            xlApp.Visible = true;
            Excel.Workbooks xlBooks = xlApp.Workbooks;
            Excel._Workbook xlBook = null;
            xlBook = xlBooks.Open("c:\\book1.xls", oMissing, oMissing,
                oMissing, oMissing, oMissing, oMissing, oMissing, oMissing,
                oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
            // Calculate
            Excel.Sheets xlSheets = xlBook.Worksheets;
            Excel._Worksheet xlSheet = xlSheets[1] as Excel._Worksheet;   //Could be a Chart
            xlApp.Calculate();    //or
            if (xlSheet != null) xlSheet.Calculate();            
            // Quit Excel and clean up.
            System.Runtime.InteropServices.Marshal.ReleaseComObject(xlSheets);
            xlSheets = null;
            System.Runtime.InteropServices.Marshal.ReleaseComObject(xlSheet);
            xlSheet = null;
            xlBook.Close(true, oMissing, oMissing);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(xlBook);
            xlBook = null;
            System.Runtime.InteropServices.Marshal.ReleaseComObject(xlBooks);
            xlBooks = null;
            xlApp.Quit();
            System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);
            xlApp = null;
        }
    }
}
 

[oohay251]

you can use things like System.Windows.Forms.SendKeys

Win32 Library's SendInput and SetForeGroundWindow type calls using "Using Win32 and Other Libraries" from the .Net documentation.

[SammyB]

you can use things like System.Windows.Forms.SendKeys

Win32 Library's SendInput and SetForeGroundWindow type calls using "Using Win32 and Other Libraries" from the .Net documentation.

Oo hey, good call. It does sound like that is what Nitesh wanted to do. So, tell us, Nitesh, what are you trying to do? Here is more on SendKeys from Microsoft, http://msdn2.microsoft.com/en-us/lib...48(vs.80).aspx