Stack Overflow
Stack Overflow

Questions tagged [xlw]

XLW is an open source application that wraps the Excel C API in simple C++, C# or VB.NET interfaces which you can use to customize Excel with your own worksheet functions and menu items.

XLW is an open source application that wraps the Excel C API in simple C++, C# or VB.NET interfaces which you can use to customize Excel with your own worksheet functions and menu items.

19 questions
3
votes
1 answer

C++ Excel Add-in loading error: XLL file is loaded by Excel as text file

I'm building XLL add-ins for Excel, using C++ and XLW library. It works fine on my PC, and on many others. But in some cases, when I drag the XLL into a new Excel window, this error shows up: The file you are trying to open, 'my_addin.xll', is in a…
athos
  • 6,120
  • 5
  • 51
  • 95
3
votes
1 answer

Handling Variable Number of Columns Dataframe - Python

I am trying to write a list of lists into an excel sheet using pandas the list looks like: List_of Lists = [ [1,2,3,4], [5,6,7,8], [9,10,11,12], ........, ] The number of these…
Eric Enkele
  • 183
  • 1
  • 7
  • 17
2
votes
0 answers

Build and Debug Excel add-in using XLW Project and Visual Studio 2022 C++

I am creating an Excel add-in using the XLW project on GitHub in Visual Studio 2022 C++. I have done the following: Create a solution MyFunction which contains two projects MyFunction and XLW. In MyFunction, Configuration Properties -> General ->…
MagicPig
  • 21
  • 1
2
votes
0 answers

XLL and VBA : Can't find DLL entry point Myfunc

I have a c++ library , and I am using xlw to create functions that can be used in Excel. So far, I was just releasing the xlw solution , and dropping the xll file on the excel sheet, and I could get my C++ functions. With VBA, I was using…
Canardini
  • 169
  • 6
2
votes
1 answer

How do I declare a function in VBA which accepts arguments of type XlfOper (LPXLOPER)?

I have found out in the answer to a previous question a way to call a function defined in a (C++) xll without registering it. I was previously using the registering infrastructure provided by XLW and I was using the XlfOper type to pass the…
Francesco
  • 3,200
  • 1
  • 34
  • 46
2
votes
1 answer

Reading Multiple excel files in a directory and write a particular cell value to another excel sheet

I need to read a particular cell value from 100 excel workbooks present in a directory, and write that data to columns in a separate excel sheet. Here is what I did which produced errors: #!/usr/bin/env python import os import xlwt import…
Minion
  • 135
  • 3
  • 20
1
vote
1 answer

python xlwt, write to the next available line

I know you can do this sheet1.write(3, 3, 'TEXT') Or you can do a for loop, but I have multiple users working with my file and I don't know what's the number of the current row. I could create a var CurrentRow and increase it every time new user…
jack
  • 13
  • 3
1
vote
0 answers

Unregister and Register XLL in Excel VBA

I have a sheet that when loaded gets passed a path to a XLL which it loads. I need a VBA macro that can unregister that XLL and register a new one. I know how to register a new XLL. How can I unregister the original XLL? I found this code : …
stas
  • 229
  • 3
  • 16
1
vote
1 answer

XLL Made By XLW with BOOST UBLAS MyMatrix Data Type Conversion to Double ** Failing

I am using XLW to create an XLL of functions to register in Excel. The XLL calls the actual mathematical models in a C++ DLL. I am using BOOST with UBLAS to aid in conversion from the XLL MyMatrix data type to the double ** that the C++ DLL uses…
RESTfulInSeattle
  • 13
  • 4
1
vote
1 answer

DLL function name restriction - digit at end of function name OK?

I'm using the Xlw framework which provides convenient wrappers for writing C++ add-ins in Excel. I've come across a problem: when I name an Excel function for use in Excel with a digit on the end, the function is not 'exposed' (ie. loaded by the…
Pete855217
  • 1,570
  • 5
  • 23
  • 35
1
vote
1 answer

XLW - Compiled XLL "The file format and extension don't match"

I'm using XLW 5 to build an Excel XLL add in, and am experimenting with the EchoShort template example. I successfully compiled Template.xll using GNU Make, with g++ version 4.9.2 (mingw-w64) under cygwin. However, when trying to open the XLL, Excel…
AlmostSurely
  • 552
  • 9
  • 22
1
vote
0 answers

XLL and EXCEL : Drag or Load

I have a problem loading my XLL into Excel. I use XLW to generate my XLL , and I use Excel 2007. When I drag the file on my spreadsheet, I can use all my Xll functions, and it works well. However when I load it using Excel-Add in , the file is…
Canardini
  • 169
  • 6
1
vote
1 answer

xlw: how to use new typedef to get std::string from Excel cells (and possibly populate a std::map)

Introduction I am referring to xlw, the Excel C API wrapper by Mark Joshi and others. Before starting with my example, my trials and my question, a couple of words about how to reproduce these codes: once you've downloaded and installed xlw from its…
Lisa Ann
  • 3,345
  • 6
  • 31
  • 42
1
vote
1 answer

How do I call a function from an xll add-in which could not be registered to the function wizard?

I have an xll (a rather complex c++ project) exporting a function which, for historical reasons, takes a large number of arguments, and precisely 20. This is a magic number: apparently in Excel 2003 there is a maximum number of 30 arguments (" In…
Francesco
  • 3,200
  • 1
  • 34
  • 46
0
votes
1 answer

How many memory an Excel XLL plugin can have?

I'm using C++ to write a .XLL plugin for Microsoft Excel, with the help of XLW library. My operating system is windows 7 64-bit version, with 32 GB RAM; but my Excel is Excel 2010, 32-bits version. Checking with GlobalMemoryStatusEx, it shows that…
athos
  • 6,120
  • 5
  • 51
  • 95
1
2