Click here to Skip to main content

Submit your article

Office Interop

Office-Interop

Great Reads

Excel Pixelating Image Creator

by simonp_ca

Use Excel worksheet's cells as pixels to render real image (for fun and experiment)

A Simple Way to Export DataGridViews/Lists to Excel

by Pasan Eeriyagama

This article focuses on a Very simple and Robust way to export Data to EXCEL

How to Check Whether Outlook is Installed in the System or Not

by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

After the tip on Excel, Word and Powerpoint, here we will explore the trick to verify whether Outlook is installed in the client's system or not by C#.

Outlook PST Email Extraction

by ChadFolden1

Extract Microsoft Outlook messages from a PST into a folder structure

Latest Articles

Excel Pixelating Image Creator

by simonp_ca

Use Excel worksheet's cells as pixels to render real image (for fun and experiment)

How to Add a Pivot Table to a Spreadsheet Using Excel Interop and C#

by B. Clay Shannon

The most straightforward way to add a Pivot Table to an Excel sheet based on data already on the sheet, using Excel Interop and C#

Outlook PST Email Extraction

by ChadFolden1

Extract Microsoft Outlook messages from a PST into a folder structure

How to Check Whether Outlook is Installed in the System or Not

by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

After the tip on Excel, Word and Powerpoint, here we will explore the trick to verify whether Outlook is installed in the client's system or not by C#.

All Articles

Office Interop

Excel Pixelating Image Creator

30 Aug 2017 by simonp_ca

Use Excel worksheet's cells as pixels to render real image (for fun and experiment)

Office-Automation

Write a standalone C# app with the ability to call any VBA macro for office automation?

1 Dec 2023 by Maciej Los

Couldn't it be better to re-write all macros from VBA to C#? Whatever you want to do with Excel data, you can do it in C#. Take a look at EPPlus library[^]. This library is powerful, elastic. You don't need to have an Office installed on your...

Office-Automation

Write a standalone C# app with the ability to call any VBA macro for office automation?

1 Dec 2023 by Andre Oosthuizen

Yes, it is possible in C#, VB.NET and some others as well. The below is for C# to reference your question - You can pick up on all of the basics as a starting point at - How to access Office interop objects | Tutorial[^] Some code to point you...

Office-Automation

InfoPath window change event

4 Dec 2011 by toby31

Found it:private void ThisAddIn_Startup(object sender, System.EventArgs e){ InfoPath._Application3 iApplication = (InfoPath._Application3)this.Application; events = (InfoPath.ApplicationEvents)iApplication.Events; events.WindowActivate += new...

Office-Automation

How to check whether Addin (SaveAsPDFandXPS.exe) is installed on a machine?

25 Jan 2012 by YKK Reddy

Hi,I placed the question and solved it myself immediately so that if any other person who is facing the same problem can find it.i have done lot of research and finally found the solution which iam going to share with you. Here it goes,When "SaveasPdfandXPS.exe" addin is installed on...

A Simple Way to Export DataGridViews/Lists to Excel

1 Nov 2012 by Pasan Eeriyagama

This article focuses on a Very simple and Robust way to export Data to EXCEL

Office-Automation

Worksheet.Cells[x,y].Value=NUL...

12 Nov 2012 by SynergiAios

Hi community of Code Project,im having a seroius trouble with reading data of an xls with the office.interop.excel.My big problem is, that i read a cell in an xls, where content is defentily. When u open this xls with excel directly u can see that the value of the cell is "101". But when...

Worksheet.Cells[x,y].Value=NUL...

13 Nov 2012 by HGH-Developers

You should use as string only if you are sure of the type of Value.To get a string from any kind of value in the cell, you can use the ToString() method.For an Excel Cell, you may have a .Text property or something similar.Pascal

Worksheet.Cells[x,y].Value=NUL...

13 Nov 2012 by Richard MacCutchan

I have managed to download your spreadsheet file (no idea what happened yesterday), and it contains the sequence 101, 102, ... in cells [1, 5], [1, 7] etc. I am able to access each of these values successfully with the following short code sequence:Excel._Worksheet xlWorksheet =...

How do I install "MS Office 12.0 Object Library" without installing MS Office

8 Feb 2013 by CHill60

Not really, you'll need to find an alternative way of manipulating the excel file or use a different format or mechanism.There's fair bit of stuff out there to help - have a look at http://code.google.com/p/excellibrary/[^]orHow to generate Excel in C program using BIFF8...

Outlook 2007 Add-In Does Not Load on Outlook 2013

8 Aug 2013 by virusstorm

Office 2007 and 2010 came with the VSTO for their respective versions and 2010 was backwards compatible. With 2013, you need to install the 2010 or 2007 VSTO on the machine or update your project to VSTO 2013. Keep in mind the object factory model changed extensively since 2013 making it a fun...

Is there an alternative to Microsoft.Office.Interop.Excel.Application?

18 May 2015 by ilostmyid2

It may be a class from Telerik. It must not be assumed that Office is installed. So, I've to use another class with the same features or similar.

Is there an alternative to Microsoft.Office.Interop.Excel.Application?

18 May 2015 by Leo Chapiro

Yes, you can use for example another one API:Open XML SDK 2.5 for Office[^]

Office 2021 won't let my assign data cells to an excel bar chart x-axis

13 Jul 2022 by Graeme_Grant

I've expanded the ExcelHelper class from my last answer[^] to help with this answer: public class ExcelHelper { public ExcelHelper(string path) { _path = path; _workbook = _excel.Workbooks.Open(path); ...

Write a standalone C# app with the ability to call any VBA macro for office automation?

1 Dec 2023 by Peter Abbasi

Hey everyone, Noob here who -- not necessarily because it's the best solution but more so just to learn and this is my idea of fun -- wants to write a super simple C# standalone app that (a) displays a list of macros I've written in VBA and (b)...

Office-Automation

Microsoft Interop: How to get the Currently Created Process Id Name

29 Sep 2011 by sabbi26

Hi,I created an object forMicrosoft.Office.Interop.Excel.Workbook xlBook;by using this Object, I called the method xlBook.Open(path,missing....);when this open method gets called, it creates one excel.exe listing in the task manager.My task is, I need to get the process Id when...

Microsoft Interop: How to get the Currently Created Process Id Name

29 Sep 2011 by koolprasad2003

http://social.msdn.microsoft.com/forums/en-US/netfxbcl/thread/1185699b-4afc-40f9-8947-360da540db50[^]

How to find the range of currently selected cells in an excel worksheet

13 Oct 2011 by iris.frigole

Hello everyone! This must be quite easy, but I have been struggling for a while now (and yes, I googled but could not make sense of what I found).My procedure receives an excel workbook as input parameter. I need to find the currently selected cell range...My only line of code so...

How to find the range of currently selected cells in an excel worksheet

13 Oct 2011 by E.F. Nijboer

What you are looking for is actually just what you would expect... and that is Selection http://msdn.microsoft.com/en-us/library/aa196885%28v=office.11%29.aspx[^]In vb.net it is a property of Application. This is because Excel is single user and therefor can have only one selection at a...

InfoPath window change event

4 Dec 2011 by toby31

I am currently working on an InfoPath ribbon using VSTO. I am using components that change at run time taking into consideration the content of the document. The problem is that when i open multiple documents the information in the ribbon is the same in every documen.From what i read the...

Office-Automation

How to open Excel file in C# Winform Application with Read Only protection?

17 Jan 2012 by saravanan6

I have opened Excel file in my C# Winform Application adding reference to Microsoft.Office.Interop.Excel.dll and using DSO FRAMER CONTROL.But i want to open my excel file with read only protection.I have sucessfully done this for WORD Application like...

How to open Excel file in C# Winform Application with Read Only protection?

18 Jan 2012 by Programm3r

Your question has been answered on stackoverflow: Answer on stackoverflow[^]Answer:Quote:Call theOpen method with third parameter (ReadOnly) = true.See MSDN documentation :Workbooks.Open Method [^]ReadOnlyOptional Object. True to open the workbook in read-only mode.

How to check whether Addin (SaveAsPDFandXPS.exe) is installed on a machine?

25 Jan 2012 by YKK Reddy

Hi All, i am facing a problem while checking the availability of the Microsoft Add-in SaveAsPDFandXPS.exe is installed? I am adding this file in Installer. My installer checks whether this Add-in is already installed. If not, it installs from the installer. Can anyone tell me how can...

How to access method decalre in ThisAddin from RibbonControl Button Click Event?

23 May 2012 by TRK3

Sounds like you want to use a static class or static member function:http://msdn.microsoft.com/en-us/library/79b3xss3(v=vs.80).aspx[^]

How to access method decalre in ThisAddin from RibbonControl Button Click Event?

29 May 2012 by Tejas Vaishnav

Finally i found the solution for this.what i do for this is to access the mail item and use mail items send() method so it will fire Application_Item Send event automatically.like this.private void btnProtect_Click(object sender, RibbonControlEventArgs e){ //FormFactory is...

How to generate word document in windows server 2003?

17 Jun 2012 by javedhakim

I had written a function to generate a word document by using the Office Interop Word object. My code is as shown below. It is working fine in my local system. But when i try to run it from window server 2003 it is not working. It keeps loading at Word.Document wordDoc = wordApp.Documents.Open...

How to generate word document in windows server 2003?

18 Jun 2012 by javedhakim

I also tried wrapping the code in a try catch statement. Still nothing happens. Is there any other alternative for my function? Could you please help me?

Unable to cast COM object of type 'Microsoft.Office.Interop.Word.ApplicationClass'

18 Jul 2012 by Bernhard Hiller

Your code snippet is a chaos. What's wordControl? Where is it declared? And what about wd = wordControl.ActiveDocument?If that is not Nothing, why don't you use it in your ForEach clause?For Each HeaderFooter In wd.StoryRanges

add bookmark as file in the treeview and open it on double click

4 Oct 2012 by arshad alam

0 down vote favorite i am creating a add-ins for Microsoft Word. i have a tree-view control where i am generating Folder, files and File's bookmarks in hierarchical structure.For this i am using these code :void GetTree(string strSearchPath) { ...

Office-Automation

create and open the word document and bring it to front

4 Oct 2012 by arshad alam

i am creating a word add-in in c#, i am creating a document, inserting a hyperlink and trying to bring it front. but newly created document does not come in front. it goes to back of the current window. Below are the code :Word.Document newNoteDoc = new Word.Document(); object...

Office-Automation

How do I install "MS Office 12.0 Object Library" without installing MS Office

8 Feb 2013 by SalCon

I am developing on a server where MS Office cannot be installed as per policy(but I do have Admin rights). The program is required to open an excel file ,refresh its data sources and save it. As office is not installed on this server I cannot add the Office\Excel references to my project.Is...

Mouse Hover over any icon of Paste Options in Excel 2010 crashes

11 Feb 2013 by Virendra_ec10

Hi Gurus,We have an Excel addin that is written in C++ and with this addin Excel crashes when we copy anything from the sheet and tried to paste by using any Paste options in Office 2010. Basically it crashes immediately once we try to hover the mouse over any of the Paste options of Office...

Office-Automation

Convert word to pdf in vb.net

4 Apr 2013 by cyanceenu

Hi..There are word documents in physical path on server.Now, I just need to read them and download to the client machine by converting them to PDF format.My program is in VB.NetAny guidance and help is well appreciated..Thanks in advance.Sri

Convert word to pdf in vb.net

4 Apr 2013 by Sergey Alexandrovich Kryukov

Please see my past answers:Convert Office-Documents to PDF without interop[^],Need a rather unique WPF text editor control[^],Hi how can i display word file in windows application using c#.net[^],Read a word file without using Interop.word dll...Do not want to install word in...

Convert word to pdf in vb.net

4 Apr 2013 by _Amy

Refer the links below:DynamicPDF Converter for .NET supported file types[^]Converting Microsoft Word Document to PDF format using OpenOffice.org (Portable)[^]See similar threads: VSTO + word 2007 + SaveAs PDF[^]Convert Word doc to pdf with Office 2003 and vb.net[^]Or you can use...

Microsoft Interop: How to get the Currently Created Process Id Name

8 Apr 2013 by Maciej Los

Excel application has interesting property: Hwnd[^], which returns a number indicating the top-level window handle of the Microsoft Excel window.When you catch the handle to Excel application, you can use Process.GetProcessById()[^] to Excel application.

How to develop Outlook Plugin for Office 2013

25 Jul 2013 by Sampath Lokuge

For that you have to use VS 2012.Check below mentioned links for more info.Creating Your First Application-Level Add-in for Outlookhttp://msdn.microsoft.com/en-us/library/vstudio/cc668191(v=vs.110).aspx[^]SOF...

Office-Automation

how to send email using word mailmerge in C#

2 Aug 2013 by praveen_07

//Load Document Document document = new Document(); document.LoadFromFile(@"D:\template\Fax.doc"); //Data information string[] filedNames = new string[]{"Contact Name","Fax","Date"}; string[] filedValues = new string[]{"John Smith","+1 (69)...

how to send email using word mailmerge in C#

2 Aug 2013 by Gishisoft

This is the function code to solve your problem in c#mailMerge = doc.MailMerge; foreach (Word.MailMergeField f in mailMerge.Fields){ // Extract the name of the MergeField starting from the 11 character // and looking for the first space after the name // (this means...

Outlook 2007 Add-In Does Not Load on Outlook 2013

6 Aug 2013 by Vikas Baisla

Hi all,We have built a VTSO office add-in using Visual Studio 2008 (C#,vsto 2.0 runtime) targeting office 2007 as the minimum version. Works fine on 2007 and 2010 version of outlook, word, excel and power point. It is also working on 2013 version of word, excel and power point but do not...

ocw11.exe for office 2010 - 64 bit

17 Oct 2013 by Harshada J.

I have developed application in visual studio 2005 and office 2003, which uses Microsoft Office Spreadsheet Component, AxMicrosoft.Office.Interop.Owc11.AxSpreadsheetI deployed my app on win 7 (32 bit) and office 2010 (32 bit). So to make it work I had to install office 2003 web components...

ocw11.exe for office 2010 - 64 bit

18 Oct 2013 by Dave Kreskowiak

You can NOT mix 32 and 64-bit code in the same process. When you installed the 32-bit OWC11 components, that's exactly what you tried to do.You really have no choice but to abandon OWC. There is no 64-bit version and there are no plans to develop the library any further. This was back in...

ocw11.exe for office 2010 - 64 bit

21 Oct 2013 by Harshada J.

solved. I changed the platform from “Any CPU” to “x86” for entire solution. It worked very well.Method -Right click on solution -> Properties -> configuration Properties -> configuration manager -> Active Solution Platform -> change Any CPU to new and then select X86

Difference between MSFT Office 2010 & 2013

3 Dec 2013 by ptam52

I hooked GdipRecordMetafile flat function in GDIPLUS.DLL, and changed the referenceHdc, frameUnit, frameRect before calling the original SDK one. My aim is to make whoever creating an enchanced meta file to generate a PNG bitmap with frame units of MetafileFrameUnitGdi (GDI compatible .01 MM...

How to convert a Power Point 2013 to HTML?

19 Dec 2013 by sud1608

In Office 2013 there is no "Save as HTML" feature neither the power point can be convert by using office.interop dll as it gives error.The interop was working fine till the time server had office 2010 but know same code is giving error, as Office 2013 has removed this feature.Please can...

Insert Smart Art in ms Office PPT slide, through c# interop dlls

17 May 2017 by PBGuy

Hie,I have trouble inserting SMART ART in powerpoint through c# code. Error is shown, when I try to add smart art to the slide,I triedPowerPoint.Shape shape = objSlide.Shapes.AddSmartArt(objSlide.Application.SmartArtLayouts[3], 10, 125);Do I need to reference additional dlls? I...

Office-Automation

Microsoft powerpoint 2010 Add in - populate chart with database values

11 Feb 2014 by PBGuy

Hi,I need to create and later update charts in powerpoint slide, on clicking a button from task pane in powerpoint presentation. I was able to create custom ribbons and task panes and interact with slides in the presentation. I was unable to find the ways to populate a chart with data...

Office-Automation

System.Runtime.InteropServices...

20 Feb 2014 by PBGuy

Hi,Error:System.Runtime....

Office-Automation

System.Runtime.InteropServices...

20 Feb 2014 by Bernhard Hiller

What do you expect with the presentation to happen? There is no screen attached to the session of IIS on the server, it won't be opened on the client computer, and the user won't see it!In your case, IIS might not have access rights to the file on the level of the file system.Microsoft...

Office-Automation

Getting Data from DB to Excel

4 Apr 2014 by Divakar Raj M

I am trying to get values from a DB in my local system to Excel Sheet. This is my codeprivate void button1_Click(object sender, EventArgs e) { Microsoft.Office.Interop.Excel.Application Text_To_Excel = new Microsoft.Office.Interop.Excel.Application(); ...

How Do I Read Content From A Ms Word Text Box

19 Apr 2014 by Wamuti

//after activating the documentforeach(Microsoft.Office.Interop.Word.Range newRange in doc.StoryRanges){ //Pick the object you want to process nrwRange.Select(); //Select the text in the Text Box in Word document. string textInTextBoxFromMSWordDocument =...

Hide a PowerPoint Slide using VSTO

29 May 2014 by Shilpa Palkar

Hi All,I am developing a Powerpoint addin. I need to hide a slide before the user sends his presentation to the printer, as the specific slide should not be printed, as per business requirements.But I am unable to find any such property for the Slide interface.Could you guide me as...

Hide a PowerPoint Slide using VSTO

2 Jun 2014 by Phil J Pearson

You need to create one or more PrintRanges that include only the slides you want to print (i.e. exclude the slide[s] you want to hide) and then call PrintOut.See http://msdn.microsoft.com/en-us/library/office/ff744973(v=office.15).aspx[^]

How to change the color sheme of Word?

2 Jul 2014 by _Sahar

How can I change the colorsheme of Microsoft Word programmatically using C#?I'm on Word 2010, I pass one of theme enums:ActiveDocument.DocumentTheme.ThemeColorScheme.Colors(MsoThemeColorSchemeIndex.ms‌oThemeDark1);But colorSheme doesnot change. Where am I doing wrong?

How to change the color sheme of Word?

6 Jul 2014 by _Sahar

const string OfficeCommonKey = @"Software\Microsoft\Office\14.0\Common"; const string OfficeThemeValueName = "Theme"; const int ThemeBlue = 1; const int ThemeSilver = 2; const int ThemeBlack = 3; using...

How Do I Split A *.Pptx File In Multiple Slide Using Visual Studio 2013 By The Help Of C# ?

31 Jul 2014 by nits23

Here are the sample codes which is working on *.ppt file but not working on *.pptx file. OpenFileDialog opObject = new OpenFileDialog(); opObject.Filter = "Office Documents(*.doc,*.xls,*.pptx)|*.doc;*.xls;*.pptx"; if (opObject.ShowDialog() == DialogResult.OK)...

How to resolve this issue :-RPC server is unavailable. (Exception from HRESULT: 0x800706BA) error is causing comexception .

20 May 2015 by nits23

I am splitting the powerpoint presentation into multiple slides at that time this rpc error is coming , i already googled but not able to understand the cause of the problem. please help...!! private void splitpptintomultipleslide(string path) { string...

Web Application, C# managing more than one Excel at a time to consolidate and release.

7 Oct 2014 by Sasmi_Office

Dear Friends'I have one process in which i have to generate 7 Reports and Export in Excel format.Once generation complete i have to consolidate this all Excel data in one single Excel file with required format change and Response to user.All done on Web base application created using...

web_application

How Can I Get Only The Headings And Their Subheadings From Word File In C#

12 Jan 2015 by Member 11255065

I want to get all the headings along their sub-headings separately from a word file programmatically Using c# for example i have following content :HEADING 1 XYZheading 2heading 3HEADING 1 ABCHEADING 1 DEFheading 2 lorem ispumso my code should return me:Heading 1...

Office-Automation

How do I set data range to powerpoint chart by using c#

17 Mar 2015 by Member 11534624

I am working on a project which can create a new powerpoint through c# window application.I meet some problems during insert a chart into a slide.when you want to insert a chart into a slide, there is a default data source for you, I already realize change the data in the excel, but I can't...

How to read vertically merged cells from word table using interop in asp.net

28 May 2015 by Phreakuency

The only way that we have found is to do var myDictionary = new Dictionary();var cell = myTable.Cell(1, 1);while(cell != null){ // Cache the line myDictionary[cell.ColumnIndex] = cell.Range.Text; // The second part is so we don't display if we just...

How to retrieve VBProject properties without Interop methodology in C#?

8 Jun 2015 by Sergey Alexandrovich Kryukov

If by "VBProject" you mean VB.NET project, there is nothing related to "interop". If you mean the properties of the resulting assembly, there is also nothing related to "interop", because the assembly is managed. And all the terms you mentioned "late binding", "macro" are also totally...

How Do I Continue After A VBA Error?

13 Jul 2015 by scottl2k7

I have a program that's a bit of a hack, but it's an internal tool, and it works 99% of the time. It runs via Windows Scheduler, and it:1) Downloads a spreadsheet from our intranet site2) Executes a VBA method in the spreadsheet to update the data using our internal SharePoint...

How Do I Continue After A VBA Error?

13 Jul 2015 by Sergey Alexandrovich Kryukov

Unfortunately, VBA does not have exception handling found in modern technologies for decades; but VBA is rather retardant thing than old. You can only use OnError statements:http://www.cpearson.com/excel/errorhandling.htm[^],https://support.microsoft.com/en-us/kb/141571[^].—SA

How to add a cusotucontrol to word document [ C# Word addin ]

26 Sep 2015 by Maciej Los

You did not provide enough information. Nevertheless...Please, refer this: Adding Controls to Office Documents at Run Time[^]

custom-controls

How to add a cusotucontrol to word document [ C# Word addin ]

28 Sep 2015 by Member 11991359

You can use:var newContentControl = currentRange.ContentControls.Add();newContentControl.SetPlaceholderText(null, null, "Empty");newContentControl.Title = elementType.ToString();You must set the range to the location where you want to insert the content control or use...

custom-controls

Inlineshape = inlineshapes.addpicture() ; referring to any word file, not to my created interop.word.application

6 Mar 2016 by Member 12372262

My task is to open a word file, on a button1 click, and add an image to that word file at cursor position on button2 click so on button_click events I write:private void button1_Click(object sender, EventArgs e){Microsoft.Office.Interop.Word.Application WordApp = null; WordApp = new...

Using C# outlook interop, how do I find "rules in error" and fix them?

29 Jul 2017 by Brian C Hart

Hi everyone, I am encountering the situation that I am sure lots of people have encountered when they've backed up their files, documents, and settings, and then wiped the hard drive, reinstalled Windows and reinstalled Office and all that and restored all files and settings. I have done this...

MS-word apis: how to reliably store and restore the contents of a content control?

11 May 2021 by Juliett Kilo

Hi, In our VSTO document-level add-in we have to reliably store the contents of RichText ContentControls in a persistable form, for later restoration in its original form. As the documentation of both Interop and VBA APIs seems to tell, this...

Office-Automation

My excel range keeps counting through rows

23 May 2021 by Herboren

Initially, I could not get the values from a spreadsheet that only has 2 columns and 2 rows, but I can get them now, but the range function is continuous. I have a textbox in my form to which the cursor stops blinking. I take this as a sign that...

My excel range keeps counting through rows

23 May 2021 by Wendelius

Not sure if I understand your question correctly, but if you wonder why the function loops through all rows, it's because you have two nested loops and you break only from the first then the value is null. If you only want to go through the...

Combine revisions from multiple authors into a single document docx from .NET code

9 Dec 2021 by OriginalGriff

While we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for...

how to send email using word mailmerge in C#

1 Aug 2013 by keerth516

I tried these two ways to send mailmerge document but didnt work for me. object oFilename = @"D:\Title.doc"; // word template myWordApp.Visible = false; string path = txtBrowse.Text;//datasource path which is excel object oPath = path; ...

How to Check Whether Outlook is Installed in the System or Not

5 Dec 2013 by Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

After the tip on Excel, Word and Powerpoint, here we will explore the trick to verify whether Outlook is installed in the client's system or not by C#.

Outlook PST Email Extraction

30 Mar 2016 by ChadFolden1

Extract Microsoft Outlook messages from a PST into a folder structure

Office-Automation

DataSet to Excel File Conversion using ExcelLibrary

15 Jan 2012 by Robby Tendean

ExcelLibrary implementation sample to convert DataSet to Excel file in VB.NET

How to Add a Pivot Table to a Spreadsheet Using Excel Interop and C#

27 Jul 2016 by B. Clay Shannon

The most straightforward way to add a Pivot Table to an Excel sheet based on data already on the sheet, using Excel Interop and C#

DataSet to Excel File Conversion using ExcelLibrary

1 Feb 2012 by Robert Hutch

Hi,another alternative is this Excel C# / VB.NET component that has limited free version that can be used in commercial applications and unlimited professional version.Here is an Excel VB.NET code how to export DataSet to Excel:Dim ef = New ExcelFile()For Each dataTable As...

How to access method decalre in ThisAddin from RibbonControl Button Click Event?

23 May 2012 by Tejas Vaishnav

I have develop one Custom addin for Outlook.and i have put some custome button on Outlook Ribbon bar also.now what is my problem is, i want to call one method declared on ThisAddin class (which is by default created by Addin), from by custom button's(which is placed on RibbonBar) Click...

Unable to cast COM object of type 'Microsoft.Office.Interop.Word.ApplicationClass'

17 Jul 2012 by VAIBHAV PANDYA

Hello,I am trying to find and replace tags on the word Document which loaded on windows form.to use the word.Range i declared`Dim wd As Object = New Word.DocumentDim wa As Object = New Word.Applicationwd = wordControl.ActiveDocument wa = wd.ApplicationDim HeaderFooter As...

How to develop Outlook Plugin for Office 2013

15 Sep 2016 by Yesudasan Moses

Hi friends,I have developed one Plugin for Outlook in Visual Studio 2010 using C#. It works perfectly in 2007, but not working in 2013.How can I develop Plugins for 2013. What tools should I use ???

Office-Automation

How to resolve this issue :-RPC server is unavailable. (Exception from HRESULT: 0x800706BA) error is causing comexception .

20 May 2015 by nits23

First of all i used these code in two different system in one system had installed MS office 2013 installed and in other MS 2010 :-in 2013 i am having this issue So i try with in other system with 2010 the issue was not there but my code was not in good shape so i refactored the code now my...

How do I create an organization chart in visio(2010) with c#?

16 Nov 2012 by Abhishek Pant

hi,this tutorial may help you to Build an Organization Chart In Visio 2010[^] and Creating VISIO Organigrams using C#[^]VisioAutomation makes it easier for developers to control Visio from .NET languages.(acts as a API) VisioAutomation[^]

How can be disable popup this email can not send without a label

5 Dec 2022 by Member 15418280

we are getting prompt window every time when we are sending mail this email can not send without a label how can restrict this pop up not to come what setting we need to do What I have tried: how can be disable popup this email can not send...

How to generate word document in windows server 2003?

18 Jun 2012 by javedhakim

From the code which I have given in my above post, I am trying to achieve word automation under asp.net 4 and in windows server 2003 R2 Standart x64 Edition. I searched in google but I could not find any solution. I even tried the solutions from following threads but nothing is working for...

How do I create an organization chart in visio(2010) with c#?

16 Nov 2012 by AmirHashemZadeh

i have a windows form application for creating organization chart in visio 2010 and i want create orgChart based on my data in my application but for creating orgChart i need a API or a solution for that.thanks in advanced.amir

Erorr in powerpoint viewer

5 Mar 2013 by Darsh_Basha

Hi i get this error while running my web application (are you missing an assembly reference?)C:\Documents and Settings\mostafa\My Documents\Visual Studio 2008\search_last\search\App_Code\Office.cs1 33 98 searchand i added using Microsoft.Office;using...

Replace text using string generated from the found text

7 Apr 2013 by johhosoe48

I need to add correct stress accents to every word in a Word document. I have a script called "DoAccentuate" which determines the correct accentuation for any word that is input. However, I don't know how to capture the currently selected found word, process it with my DoAccentuate script, and...

Error : Requested object is not available in Mail merge word while trying to send email

31 Jul 2013 by keerth516

HI, I am trying to send the mailmerge document as email.I am novice in this topic .could you please let me what went wrong and its correction to get the required result.Title.doc is my template and am using excel as datasource.I am trying to send email to mailmerge doc to emailid mentioned...

Office-Automation

Getting Data from DB to Excel

4 Apr 2014 by Peter Leow

Go thru this tutorial: How to export SQL data to excel using Microsoft.Interop.Office.Excel and C# [^]

How Do I Read Content From A Ms Word Text Box

11 Apr 2014 by Wamuti

Hi all.I am looking for a way to read the text inside a word document text box. The best i have is a red underlined code:doc.Shape( This is embarrassing but it is all i got after days of research. Please assist me as i am now totally stuck.

How to read vertically merged cells from word table using interop in asp.net

22 May 2015 by Murali Krishna Babu

Hi,We have a requirement to read Word documents which is like template. This word document is having multiple tables. We can able to read normal tables but application is throwing exception if a table is having vertically merge cells.Can some body help with the code.Thanks in...

How to retrieve VBProject properties without Interop methodology in C#?

8 Jun 2015 by Meenakshi Kabali

Hi, I have created winform application - to retrieve active excel application details fro desktop. Currently i am using Microsoft.Office.Interop.Excel to get all excel file properties. I am looking for methodology to retrieve all excel file properties without using Interop. I...

Add Track Changes and comments in MS Word using ASP.NET C#

5 Jul 2015 by zlristovski

Hello,I can create and open Word document using C#. I am able to insert some new text, but now I am trying to insert track changes and comments on this document.I've tried with some libraries but this was unsuccessful. Is anybody faced with this type of problem or know some libraries...

How to add a cusotucontrol to word document [ C# Word addin ]

23 Sep 2015 by Jeff Lyu

I make a word addin to print vouchers. that contains a custom control called BarcodeWithZXing. the BarcodeWithZXing is written by C# and build to a Dll file. the addin reference to that. the question is :how to add the BarcodeWithZXing to document. I try the method...

custom-controls

Insert Smart Art in ms Office PPT slide, through c# interop dlls

17 May 2017 by abdul subhan mohammed

Just change word to powerpoint, hope this will help you! public static bool InsertSmartArtShape(IQuestion question, string filename, SmartArtShapes _smartArtShape) { WordInterop.Application wordApplication = GetOrCreateWordApplication(question.ObjectStore); ...

Office-Automation

Combine revisions from multiple authors into a single document docx from .NET code

9 Dec 2021 by Member 15462608

It is necessary to agree on a contract between the two parties - organizations. Each party works with its own copy of the original document. Several employees of one party jointly edit “Copy 1”. At the same time, several employees of the other...

Office 2021 won't let my assign data cells to an excel bar chart x-axis

16 Jul 2022 by PaulaJoannAllen

I am creating a bar chart with two columns and an x-axis that I want to set from a column of dates to the x-axis labels. I can not see a way to do it, although, in Office 2010, I was able to. What I have tried: Tried to set series3 to it....

Office 2021 won't let my assign data cells to an excel bar chart x-axis

16 Jul 2022 by PaulaJoannAllen

I made a new excel file with the chart in it, and I was now able to set the names on the x-axis.