Instead of instantiating a new instance, check for an existing one: try { Microsoft.Office.Interop.Excel.Application app = System.Runtime.InteropServices.Marshal.GetActiveObject(“Excel.Application”); } catch { // Excel is not running. }
Leave the parameter value as a missing value for the Row.Add Function object oMissing = System.Reflection.Missing.Value; // get your table or create a new one like this // you can start with two rows. Microsoft.Office.Interop.Word.Table myTable = oWordDoc.Add(myRange, 2,numberOfColumns) int rowCount = 2; //add a row for each item in a collection. foreach( string s … Read more
I use this function to find and replace. you can specify any of the options. private void FindAndReplace(Microsoft.Office.Interop.Word.Application doc, object findText, object replaceWithText) { //options object matchCase = false; object matchWholeWord = true; object matchWildCards = false; object matchSoundsLike = false; object matchAllWordForms = false; object forward = true; object format = false; object matchKashida … Read more
I have created an utility method that tries to detect if a given office document is protected by a password or not. Here are the list of advantages: supports Word, Excel and PowerPoint documents, both legacy (doc, xls, ppt) and new OpenXml version (docx, xlsx, pptx) does not depend on COM or any other library … Read more
I had to get around something like your problem a while back. foreach (Object _obj in _explorer.CurrentFolder.Items) { if (_obj is MailItem) { MyMailHandler((MailItem)_obj); } } Hope that helps. The issue here is that _explorer.CurrentFolder.Items can contain more objects than just MailItem (PostItem being one of them).
You need to add a COM reference in your project to the “Microsoft Excel 11.0 Object Library“ – or whatever version is appropriate. This code works for me: private void AddWorksheetToExcelWorkbook(string fullFilename,string worksheetName) { Microsoft.Office.Interop.Excel.Application xlApp = null; Workbook xlWorkbook = null; Sheets xlSheets = null; Worksheet xlNewSheet = null; try { xlApp = new … Read more
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment. If you are building a solution that runs in a server-side … Read more
(All of my advice is adapted from this answer about Excel interop.) There are a few important things here: 1) Never use 2 dots on the same line. Also consider an indexer as a dot Good Word.Documents d = wordApp.Documents; Word.Document aDoc = d.Open(/*…*/); BAD Word.Document aDoc = wordApp.Documents.Open(/*…*/); 2) Release all of your pointers. … Read more
When you create a file, eg C:\Temp\MyWordDoc.doc and write data to it using a FileStream and StreamWriter, you’re actually writing information to a text file. The doc or docx file extension causes Microsoft Word to open the file, but it is NOT in Word format, its just plain text. You need to use the MS … Read more
To set a range to text: xlYourRange.NumberFormat = “@”; You can also prefix a value you put in a cell with an apostrophe for it to format it as text: xlYourRange.Value = “‘0123456”; To set a range to number xlYourRange.NumberFormat = “0”; Obviously if you want to set the format for the entire column then … Read more