Serving the Quantitative Finance Community

 
User avatar
PiotrW
Topic Author
Posts: 7
Joined: March 5th, 2004, 12:49 pm

Borland C++ Builder dll in Excel (bcb dll 4 xls)

August 30th, 2009, 10:43 pm

Hello,you can find a number of threads in net about constructing dll libraries in Visual C++ and implement them in Excel. But as far as BCB is concened, you can only find:a) dll used in form (e.g):http://www.functionx.com/bcb/libraries/staticdll.htmb) dll used in console application.http://www.yevol.com/en/bcb/Lesson06.htmc) dll used in R (e.g):http://www.math.ncu.edu.tw/~chenwc/R_no ... and.htmThe quastion is:"Perhaps you know how to create a stand-alone dll for Excel in C++ Builder?" (I mean could you illustrate the whole process on the example)Any help appreciated.Regards,PiotrW
Last edited by PiotrW on August 30th, 2009, 10:00 pm, edited 1 time in total.
 
User avatar
mj
Posts: 12
Joined: December 20th, 2001, 12:32 pm

Borland C++ Builder dll in Excel (bcb dll 4 xls)

August 31st, 2009, 9:14 am

I always meant to try to get xlw to work with Borland but never did. Given that it works with Visual Studio and gcc it should n't be that hard.Is there real demand for this?
 
User avatar
PiotrW
Topic Author
Posts: 7
Joined: March 5th, 2004, 12:49 pm

Borland C++ Builder dll in Excel (bcb dll 4 xls)

August 31st, 2009, 10:20 am

Hi mj,>Is there real demand for this?If you mean creating a stand-alone dll for Excel in C++ Builder? Yes there is real demand for this.Regards,PiotrW
Last edited by PiotrW on August 30th, 2009, 10:00 pm, edited 1 time in total.
 
User avatar
mj
Posts: 12
Joined: December 20th, 2001, 12:32 pm

Borland C++ Builder dll in Excel (bcb dll 4 xls)

August 31st, 2009, 9:03 pm

Well if you get xlw include all the files in C++ builder, create a dll project and rename the output to have .xll suffix, it might work... When i ported to gcc, this is all I did. Built it and removed all errors and warnings and it worked. It seems that C++ builder is not free so I can't try this myself. (unless someone wants to buy me a copy!)
 
User avatar
PiotrW
Topic Author
Posts: 7
Joined: March 5th, 2004, 12:49 pm

Borland C++ Builder dll in Excel (bcb dll 4 xls)

September 1st, 2009, 5:55 am

Hi mj,Turbo C++ 2006 Explorer is Free download, Full product.If you would like to download it, you may use https://downloads.embarcadero.com/free/c_builder .Regards,PiotrW
 
User avatar
mj
Posts: 12
Joined: December 20th, 2001, 12:32 pm

Borland C++ Builder dll in Excel (bcb dll 4 xls)

September 1st, 2009, 10:54 pm

OK i had a go with xlw 2.1. Building it was fairly easy. Change all ctime includes to time.h . Comment out the template factory example code (or work out what syntax works with the Borland compiler.) However, I got the unrecognizable format error because of missing dlls. Using dependency walker (free download) I identified the missing dlls. However, one was bcrypt.dll which I don't seem to be able to get hold of. It seems to be part of Vista.I don't know much about the Borland compiler but if I got it to use static linking when building, the problem would probably go away.