I was wondering if anyone knew how to quickly detect whether there is data in a given worksheet or not, without actually looping through all of the rows/columns of the worksheet to figure this out. I am writing an importer that will import data right into the active worksheet (if it has not been modified), or create a new worksheet and ...
Hi, I would like to know first what is the difference between VSTO Excel 2007 Workbook and VSTO Excel 2007 Add-In. In what scenarios either VSTO excel 2007 workbook or VSTO Excel 2007 Add-In or both is preferred. I would like to learn VSTO Excel 2007 using C# with some good examples and working with the same at high level of usage in...
Hi, Please help me through a C# code that In VSTO excel whereever i selected a cell the respective column gets focussed. I need to get the Column value(which column) and row value(which row no) on excel worksheet wherever i focussed. Please help me to get the same through code. And also i would like to learn VSTO Excel using C#. Sugges...
I've got a great MS Outlook 2003 addin going that adds some features to the context menu. What I am lacking is the ability to get the item I've right-clicked on. So, in .NET (I'm writing in VB.NET but I know C# as well), how would I grab the item I've right-clicked on? I only want to show this particular context menu addition when I'm ...
How to Store Clipboard data into a sample table while working in VSTO Excel using C# Later how to load the data stored into a sample table on to Excel worksheet As i don't want direct from clipboard to Excel. Please help me with the code ...
My requirement of one need: How to get active cells range in an object in a worksheet to copy those active cells range data into an excel or excel range object 3.To bind those excel range object data back to excel worksheet Please help me with the Code using C#. ...
So I've got this context menu working out except that the event behind the actual selection of the menu item seems to fire multiple times. First time I click it, it fires once, then twice, then 3 times. So, in the example I just gave, for 3 clicks it would have fired a total of 6 times (1 + 2 + 3). Why is that? Below is my code on how I...
I've not been able to find a whole lot on this anywhere. Let me start by saying I don't want to use the old Windows Form. I want to add a new WPF Window to my outlook 2007 addin project in visual studio 2008. The WPF Window template however does not show up. I was following this tutorial: http://msdn.microsoft.com/en-us/library/bb41...
One of the groups in my company works on a very large PowerPoint slide deck. Not all of the slides in this deck are relevant to everyone. The purpose of this deck is to have a singular source of material which people can pick and choose slides depending the type of presentation that is needed. The slide deck has a number of pre-define...
I've created an Excel add-in using Visual Studio 2008. It has a ribbon, a bunch of panes and code that adds sheets and ranges and gets information scraped from a web page. When I run it on my dev PC it works perfectly. I used the Publish command to publich it and installed on a Windows XP virtual PC. The installation seemed fine and whe...
How to record user performed actions on 2007Excel VSTO in .ini file using C#. ...
Hi all, I'm working on an Excel add-in and have an issue with ranges. Suppose we have a range on a spreadsheet - A1:D1. A user inserts a column at say column C. My VSTO Range object is still A1:D1 but I'd like it to become A1:E1. UPD: I don't expect this to happen automatically, but I wonder is there a way VSTO would help me to impl...
Hi all, As a simpler way of saying "how to handle resize of range upon insert column/row in Excel via VSTO?": Is there a way in excel VSTO to handle "insert row" or "insert column" event? ...
Hi, I'm trying to replicate this Access VBA code using C#, but am unable to do so. Wondering if anyone else has tried this before and can help. oWB.Worksheets("Signoff").Range("rgSignOffRecTemplate").Value = g_TemplatePath & "Signoff_Rec.XLT" rgSignOffRecTemplate is a "Defined Name" in the Excel template that I'm trying to write to. ...
Hi all, In Office 2007 boxes on the ribbon change their size when window size changes. Here is an example, Styles group box on excel Home ribbon. When window is stretched horizontally, Styles look like this: If we reduce window width a little, Styles will change to this: If width is reduced even further, we'll see this: The qu...
In an Excel formula you can use =ISERR(A1) or =ISERROR(A1) In a VBA macro you can use IsError(sheet.Cells(1, 1)) But using a VSTO Excel Addin project I did not found similar function under the Microsoft.Office.Interop.Excel API. I only want to know if there is an error in the cell, I'm not really interested in the type of error. My c...
I want to create an add-in for Word to convert between Vietnamese character sets but I don't how to scan each character in document and check its font to convert (there are many charsets and fonts in VN) after has converted I want to replace origin character with the converted character. ...
In a VSTO Excel addin the code: Dim XMLDoc As XElement = XElement.Load("XMLFile1.xml") generates a FileNotFound error with the message ("Could not find file 'C:\Users\doug\Documents\XMLFile1.xml'.") It's looking in the My Documents folder but the XML file is located in the VS Projects folder for that project. I have set the XML file'...
What are the methods to destroy Excel COM Interop objects in C#, besides these: object_instance = null; System.GC.collect(); & System.Runtime.InteropServices.Marshal.ReleaseComObject(object); Please suggest only inbuilt techniques, not other tools like bigcannon, etc. ...
I have a background worker. Before I invoke the worker I disable a button and make a gif visible. I then invoke the runworkerasync method and it runs fine until comleteion. On the 'RunWorkerCompleted()' I get a cross thread error. Any idea why? private void buttonRun_Click(object sender, EventArgs e) { if (comboBoxFi...