Stack Overflow
Stack Overflow

Questions tagged [xll]

An Excel Add-In written in C and compiled in native Windows DLL format for high performance.

An XLL file is a high-performance add in for Excel written in a compiled language, usually C, and compiled as a native, binary Windows DLL, which is loaded into the same process as Excel for extremely fast performance. Like other Excel add-ins, XLLs can provide new worksheet functions and/or can provide macro-like procedural code initiated from the user interface. They can use Excel's high-speed C API to access any of the functionality of Excel.

An XLL is just a DLL with a different file extension. It must implement several special functions which provide the glue to connect it to Excel.

Official documentation and other links:

Excel 2010 SDK

196 questions
13
votes
1 answer

XLL Excel addin in unmanaged C++

I have a few mathematical simulations in unmanaged C++ and now I need to integrate them with Excel (so that it is possible to call the functions from Excel and get the values back). I don't want to use any VBA, so I guess I have to implement an XLL…
Grzenio
  • 35,875
  • 47
  • 158
  • 240
11
votes
2 answers

How to deploy an Excel XLL Add-In and automatically register the Add-In in Excel

I have developed an Excel XLL using ExcelDNA and C#. I am at the point where I would like to begin testing the deployment, but cannot find much information that actually provides steps that work. My project was developed as a Class library with…
Lee Z
  • 802
  • 2
  • 13
  • 39
9
votes
2 answers

Unregister a XLL in Excel (VBA)

I am just discovering the world of programming XLLs for Excel using XLW under Visual C++ 2010 and everything has been smooth so far using the template provided with the XLW package, I have a few questions: I found out that I can register an XLL by…
Steve06
  • 741
  • 2
  • 15
  • 32
8
votes
1 answer

Trying to build an XLL "This program cannot run in DOS mode"

I've been trying to build a simple XLL that will just create a process with a hard coded command line. Here is my code: #include "pch.h" BOOL APIENTRY DllMain( HMODULE hModule, DWORD ul_reason_for_call, …
C. Cristi
  • 569
  • 1
  • 7
  • 21
8
votes
1 answer

Automatic update of (Excel-DNA) XLL with Excel opened

I am developing an Excel XLL Add-In using Excel-DNA and C#. The Add-In is called MyAddIn.xll. The Add-In has been saved to the users local machines, and it has been installed/added to Excel by the following procedure: Excel Options --> Add-Ins -->…
Samuel
  • 157
  • 2
  • 9
8
votes
3 answers

Convert ASCII character to x11 keycode

I have a small program that takes input in the form of ascii characters. I need to be able to convert these to keycodes for use with x11 functions. Is there a xlib function to do this or another library? Or will a large switch case work best?
a sandwhich
  • 4,352
  • 12
  • 41
  • 62
7
votes
2 answers

Is there a way to get the text and cursor position from the formula bar in Excel?

I'd like to get the current (possibly uncommitted) text out of the formula bar in Excel (from an addin in-process). All "usual" techniques don't work, like GetWindowText(...), etc. As for cursor position: GetCaretPos actually works (returns the x,y…
Steve
  • 438
  • 3
  • 10
7
votes
3 answers

How to disable Excel 2010 feature/bug which stops calculation on selection of any cell?

I am working on an excel sheet in which, with the help of an xll addin, I am trying to update the data. I press Ctrl+Alt+F9 to start the calculations, but the calculation stops at any keypress or cell selection. Is there a way to override this…
Varun Mahajan
  • 7,037
  • 15
  • 43
  • 65
7
votes
5 answers

Calling Excel/DLL/XLL functions from C#

I have a particular function in an Excel addin(xll). The addin is proprietary and we do not have access to the source code. However we need to call some functions contained within the addin and we would like to call it from a C# program. Currently,…
BlueTrin
  • 9,610
  • 12
  • 49
  • 78
6
votes
3 answers

Calling Specific Win32 API from Delphi - Why do Exceptions Fly Without an "asm pop..."?

I'm using Delphi to make an XLL add-in for Excel, which involves making a lot of calls to the Excel4v function of xlcall32.dll. However, as I'm guessing very few Delphi experts here have worked with that specific API, I'm hoping that the problem…
MB.
  • 7,365
  • 6
  • 42
  • 42
5
votes
2 answers

Creating XLL Excel add-in for Windows 7/64 bit (cross-compiling on Windows XP/32)

I'm not a skilled Windows programmer, but I created and have been maintaining an XLL add-in for 32-bit Windows XP / Excel for many years. I'd now like to create a Windows 7/64 bit version and am having trouble - I can't even get the Generic.xll…
user2326756
  • 51
  • 1
  • 5
4
votes
2 answers

Unpack contents from Excel .XLL file built with Excel-DNA

I don't know if you know excel-dna project, it's a project that help to integrate .net assembly and language in excel addins. My problem is that I want to unpack a dll from an xll file (excel-dna is able to pack resources inside xll). I donwloaded…
Dragouf
  • 4,676
  • 4
  • 48
  • 55
4
votes
1 answer

Setting Excel Number Format via xlcFormatNumber in an xll

I'm trying to set the number format of a cell but the call to xlcFormatNumber fails leaving the cell number format as "General". I can successfully set the value of the cell using xlSet. XLOPER xRet; XLOPER xRef; //try to set the format of cell…
fran
  • 365
  • 1
  • 3
  • 19
4
votes
1 answer

Excel Add-in: Assignment in for loop causes segmentation fault but line-by-line assignments work. Why?

I just tested a toy Excel add-in project, cross building the XLL with mingw32 tool chains. Here is my code: //testXLL.c #include "windows.h" #include "xlcall.h" #define MEMORYSIZE 65535000 char vMemBlock[MEMORYSIZE]; int vOffsetMemBlock =0; LPSTR…
user3148104
  • 43
  • 3
4
votes
1 answer

Build an add-in and UDF for all the Excel versions

One data provider wants to develop an Excel add-in, these are the requirements: 1) it can be installed on desktop. It adds one menu and buttons in Ribbon, and it also provides some specific functions (to get real-time data, like Bloomberg…
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
1
2 3
…
13 14