Stack Overflow
Stack Overflow

Questions tagged [excel-addins]

Excel add-ins are self-contained programs that extend or add functionality to Microsoft Office Excel.

Microsoft Office Excel add-ins are self-contained programs that extend or add functionality to Excel. By default add-ins are not enabled, and they need to be installed / activated.

Add-ins can be created in multiple ways

  • .xla: a specially saved workbook containing macros for and earlier.
  • .xlam: a specially saved workbook containing macros for current versions of excel.
  • COM: Custom Component Object Model add-ins written in VB6
  • .xll: A DLL add-in using Excel's C API
  • Managed COM addins using or

Visual Studio provides project templates you can use to create application-level add-ins for Microsoft Excel. You can use add-ins to automate Excel, extend Excel features, or customize the Excel user interface.

Links:

1283 questions
-2
votes
1 answer

Excel ActiveX checkbox

I´m looking for insert in a cell dynamically a checkbox button using the new Js-Addin, is that a way to do it? I check the documentation but it doesn't see to be possible, is that another way?
Lucas Gazire
  • 301
  • 5
  • 16
-2
votes
1 answer

How to list all excel file names in specific foldder and total number of row used in each file using Excel VSTO C#

I am new to Excel add-in. I have specific folder where I want Excel add-in to search for any excel file including sub folder and list down all file names and total number of row used in existing excel file where the add-in is running. Any help will…
Bubuhubu
  • 81
  • 9
-2
votes
1 answer

how use Excel COM add-in a VSTO add-in without installing visual studio

how do I get my vsto to work on Excel without the settings of Visual Studio? im trying to add not valid. can you help me a solution for that the file that I have
Indra Royal Silver
  • 23
  • 6
-3
votes
4 answers

How to transform all strings to numbers in a nested array, except actual strings in Javascript?

I am trying to transform all values in a 2D array from strings to numbers, except values that are actually strings (within the Javascript Excel Add-in API) Example: [["1000"],["3.2"],["banana"]] to [[1000],[3.2],["banana]] "1000" -> 1000 "3.2" ->…
Francisco Barroca
  • 118
  • 6
-3
votes
1 answer

How to return value with apostrophe from excel UDF

I have been trying to append ' before a value so that excel cells will recognize the cells as a text value. Is there any way we can append ' with a value from UDF. e.g If I call GetZero() it will return me '0.00 and excel will recognize it as 0.00…
Sourabh Mishra
  • 212
  • 1
  • 10
-3
votes
1 answer

Create excel CustomTaskPane in delphi (add-in)

How to create a simple customtaskpane using Delphi without add-in express and add customtaskpane to excel. Taskpane will have 1 button(close ) procedure TMyAddin.OnConnection(const Application: IDispatch; ConnectMode: ext_ConnectMode; const…
Ranga MK
  • 43
  • 11
-4
votes
1 answer

Set 'Fit All Columns on One Page' via Excel JavaScript API

I'm looking to set the "Fit All Columns on Page" print option via the Excel JavaScript API. It's very similar to this question which uses VBA --> How to set 'Fit all columns on one page' in print tab
FreeSoftwareServers
  • 2,271
  • 1
  • 33
  • 57
1 2 3
…
85
86