Stack Overflow
Stack Overflow

Questions tagged [netoffice]

NetOffice is an open source .NET library which offers solutions for Office developers in .NET. .NET Wrapper Assemblies are available for accessing MS Office applications without the need to use VSTO.

Features

  • Office integration without version limitations
  • All features of the Office versions 2000, 2002, 2003, 2007, 2010, 2013 are included
  • Active support in version independent development (please scroll down)
  • Syntactically and semantically identical to the Microsoft Interop Assemblies
  • No training if you already know the Office object model, use your existing PIA code
  • Reduced and more readable code with automatic management of COM proxies
  • Usable with .NET version 2.0 or higher
  • Easy Addin Development
  • No deployment hurdles, no registration
  • No dependencies, no interop assemblies, no need for VSTO
  • Visual Studio Project Templates and Wizards available Photo Gallery
93 questions
1
vote
1 answer

Perform Word mail merge programmatically using NetOffice

I'm trying out NetOffice to perform MS Word mail merge using a template and programatically filling in the merge fields. The examples available here does not really have this scenario. I updated Example 03 in it so that it creates a new document…
Frank Fajardo
  • 7,034
  • 1
  • 29
  • 47
1
vote
1 answer

Debug C# Excel Addin via SharpDevelop on Windows

I am pulling my hair out trying to debug an Excel Addin from SharpDevelop 5.1 which I created via NetOffice 1.7.3. These are the steps I've done so far: - Installed SharpDevelop 5.1 Installed NetOffice 1.7.3 Ran Developer Toolbox.exe and clicked…
bobmarksie
  • 3,282
  • 1
  • 41
  • 54
1
vote
1 answer

Signing office COM Add-in

I've developed an extension based on NetOffice. My office configuration requires applications to be signed by Trusted Publishers. I tried signing the output DLL with signtool.exe, with a valid certificate, but unfortunately, Office says "There is no…
bondar
  • 484
  • 1
  • 3
  • 16
1
vote
1 answer

How to customize Excel Ribbon at runtime

Is there a way to use Netoffice to customize Office/Excel Ribbon at runtime, My concern is that I am trying to make plugin-able addin that adds button to Ribbon based on available action of my plugins. I actually created my tab using XML but I can't…
IdontCareAboutReputationPoints
  • 1,584
  • 21
  • 26
1
vote
1 answer

How can I initialize NetOffice.WordApi objects using a Microsoft.Office.Interop objects?

I have a Microsoft Office Addin Project on Visual Studio. It uses Microsoft.Office.Interop.dll . Within the code logic, I need to use NetOffice.WordApi instead of the regular Interop assemblies. My question is this: Since NetOffice is a wrapper to…
Mohamed A. Abd el fatah
  • 43
  • 7
1
vote
0 answers

How to use SetPlaceholderText which has broken IDL definition with late binding

I want to make office add-in which will be supported by any 2007+ offices. Setting different add-in version for different offices seems impossible, all offices are loading add-in info from same registry key. So I decided to use netoffice. Now…
Atomosk
  • 1,871
  • 2
  • 22
  • 26
1
vote
2 answers

NetOffice Outlook Plugin Deployment

I am using NetOffice to develop an Outlook plugin. This plugin is working on my local machine when (somehow magically) deployed through Visual Studio (If I run the project and then open the Outlook the functionality is there). All fine till here.…
NeverStopLearning
  • 958
  • 11
  • 21
1
vote
1 answer

Adding a row into a sheet using NetOffice

I have a Excel.Workbook book = application.Workbooks.Open(txtPathExcel.Text); Excel.Worksheet mainSheet = (Excel.Worksheet)book.Sheets[1]; How can i add a new row in mainSheet? I can't find any NetOffice functions for it.
NicoJuicy
  • 3,435
  • 4
  • 40
  • 66
1
vote
2 answers

Insert Excel Rows/Columns with ExcelDNA or NetOffice

I am using ExcelDNA to set and get cell values. I can get and set cell values var ref = ExcelReference(2, 2); var val = ref.GetValue(); ref.SetValue(42); is there a way to insert an entire row or column by moving entries to the right or down? I…
Matthew Molloy
  • 1,166
  • 1
  • 10
  • 22
1
vote
2 answers

Excel User Defined Function Locks Invoking Spreadsheet

I am using NetOffice to edit an Excel Spreadsheet. If I call the code from an Excel user defined function it will not let me edit the invoking spreadsheet. Excel.Application excelApplication = Excel.Application.GetActiveInstance(); Excel.Worksheet…
Matthew Molloy
  • 1,166
  • 1
  • 10
  • 22
1
vote
0 answers

Office automation - compress images in ms word addon

I am having some issue trying to compress images from office automation. I can do this manually: Right click image Select "Format Picture" Picture tab Compress button Apply to "All pictures in document" I cannot find this method anywhere in the…
Crudler
  • 2,194
  • 3
  • 30
  • 57
1
vote
1 answer

Will I require MS Excel installed on the server if I am generating Excel file using NetOffice?

I am trying out both NetOffice and NPOI for to use in an ASP.NET project. I am making an ASP.NET web site where on click of a button, I want to generate an Excel file in a password protected state and send it to the client to download it. But I…
Temp O'rary
  • 5,366
  • 13
  • 49
  • 109
1
vote
1 answer

how to get all headings(Not Headers) in a page using NetOffice API?

how to get all headings(Not Headers) in a page using NetOffice API? There is little documentation and I'm struggling to get headings text in a page/document. Can anybody help?
Ahsan
  • 648
  • 1
  • 10
  • 27
1
vote
0 answers

COM type mismatch in .net addin for MS Excel VBE

I've been trying to build the example located here: http://www.mztools.com/articles/2012/MZ2012013.aspx The only difference to the posting is that I'm trying to use the NetOffice COM interop libraries instead of the recommended private interop…
Rossco
  • 1,052
  • 11
  • 24
1
vote
1 answer

Office addin deploy to all users

Actually i create an addin to office with NetOffice. This work well. I create a setup project in VStudio 2010. When I install my addin to current user only this work well but not when I install to All users. In my setup project in User/Machine hive…
Eric Caron
  • 41
  • 2
1 2
3
4 5 6 7