Hi,
Does anyoe know how to call the F9 key function (Calculate Sheet) using C#?
Thanks.
3  2822  
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;
-
}
-
}
-
}
-
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.
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 Sign in to post your reply or Sign up for a free account.
Similar topics
by: Bob Murdoch |
last post by:
I have an ASP application that calls a COM function to create a custom
report as an Excel file. This works in a synchronous fashion, as long as
the report does not take too long to create. If...
|
by: Gal merom |
last post by:
I would like to run a function of one access file from another
access/excel file, How can i do that?
For example: I want to write a procedure in Excel VB that will call
another function in an...
|
by: Rob Kellow |
last post by:
Hello,
I'm working on an application for use within my company on our intranet that will be used to gather some information and store some of the info in a SQL Server database and the rest of the...
|
by: cr113 |
last post by:
I just upgraded from Office 2000 to Office 2003. My VB.NET Excel macro
calls don't work any longer.
Here is how I make my Excel macro call from VB.NET:
Dim objExcel as Excel.Application
...
|
by: jobxyz |
last post by:
Hi
I am trying to call the excel function linest from VB using automation.
the call
Slope1 =
Excel.WorksheetFunction.Index(Excel.WorksheetFunction.LinEst(y, x),1)
works fine as long as x...
|
by: Gunther |
last post by:
Hi,
I have tried the example from the KB article 817248
(http://support.microsoft.com/kb/817248/en-us) in Visual Basic AND in C# with
..NET Framework 2.0:
<ComClass(ComClass1.ClassId,...
|
by: RB Smissaert |
last post by:
Made a C++ dll with MS VC6 and trying to call the dll from Excel VBA.
This is the code in the .cpp file:
#include "stdafx.h"
#include <string>
#include <math.h>
using namespace std;
|
by: Jaime Leivers |
last post by:
Here's a median function in access that you can call in any query. You
could change this to any excel function you wanted. Most people can
find the windows help file that says how to call an excel...
|
by: keirnus |
last post by:
Hello once again...
I made a function in Excel. The function does some error checking within the Excel file.
To be easy for me, I want my code in MS Access to simply call the function in Excel....
|
by: djanarda |
last post by:
Hi,
I am newbie to c# coding. I am trying to call the MS-Excel Correl() in my C# code. From a decently comprehensive search on google I found that there is a Excel Interop COM library which could...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
