1
Vote

unsuccessful build

description

I followed the very simple instructions, running setup and project10 first. I created the XLL Add-in Project, but it does not build successfully. I get the following error:

LINK : fatal error LNK1104: cannot open file 'xll.lib'

I am using Visual Studio 2010. Is there something else I need to do in order to get this up and running?

comments

keithalewis wrote Nov 21, 2013 at 3:46 AM

I haven't been able to replicate this. Can you tell me what you see under KALX\xll where you installed the library?

thedusemeister wrote Nov 21, 2013 at 4:05 AM

I see 7 directories: build, config, SandCastle, test, v100, v110, xll

KALX\xll\xll appears to include all of the files in the External Dependencies

keithalewis wrote Nov 21, 2013 at 5:06 AM

Looks like you are missing two symbolic links. Make a link called 10 to v100 and 11 to v110. You can also replace the 10 in the library path by $(PlatformToolset).

thedusemeister wrote Nov 21, 2013 at 5:59 AM

Substituting $(PlatformToolset) for 10 in the library path did the trick. Thanks for the assistance.

keithalewis wrote Nov 21, 2013 at 12:55 PM

Great. The good news is that you are now set up to build on VS 2012 too.

krad23 wrote Sep 16, 2014 at 8:24 AM

i have the exact same issue. where is the library path that i'm supposed to change?

keithalewis wrote Sep 16, 2014 at 9:48 AM

What did you set $(PlatformToolset) to?

krad23 wrote Sep 16, 2014 at 10:01 AM

I didn't set anything. All by default.

I think I've managed to partially fix it. I went to linker / additional library directories and changed from
$(ProgramFiles)\KALX\xll\10\Debug\;%(AdditionalLibraryDirectories)
to
$(ProgramFiles)\KALX\xll\$(PlatformToolset)\Debug\;%(AdditionalLibraryDirectories)
But now when I try to debug, I get
Debugging information for EXECEL.EXE could not be found or does not match. Cannot find or open the PDB file.

keithalewis wrote Sep 16, 2014 at 10:37 AM

Ignore that. You are good to go now.

krad23 wrote Sep 16, 2014 at 10:47 AM

it seems to work. thank you

JohnAnon wrote Jan 2, 2015 at 11:22 PM

Windows 7 Pro; brand new installation

I tried both solutions and neither works.

Starting with the easiest:

1) Open XllProject1
2) Right Click on the solution name and select Properties
3) Select Configuration Properties
4) Select Linker
5) Select General
6) Select Additional Library Directories
7) Change value from $(ProgramFiles)\KALX\xll\10\Debug\;%(AdditionalLibraryDirectories)
to $(ProgramFiles)\KALX\xll\$(PlatformToolset)\Debug\;%(AdditionalLibraryDirectories)

and received the same error: LINK : fatal error LNK1104: cannot open file 'xll.lib'

Then I tried the symbolic link solution and it appears to get by the LNK1104 error but it then errors out with the message:

LINK : fatal error LNK1123: failure during conversion to COFF: file invalid or corrupt

As a test, I replaced $(ProgramFiles)\KALX\xll\10\Debug\;%(AdditionalLibraryDirectories) with
$(ProgramFiles)\KALX\xll\V100\Debug\;%(AdditionalLibraryDirectories) and got the same error message:

LINK : fatal error LNK1123: failure during conversion to COFF: file invalid or corrupt

Should I just reinstall from scratch and try again?

Any hints would be appreciated.

Thanks

keithalewis wrote Jan 3, 2015 at 2:49 AM

Yes. I had to change the installer to deal with the various versions of Visual Studio. Let me know if that does not work for you.

JohnAnon wrote Jan 3, 2015 at 8:21 AM

The two files: project10.zip and setup.zip have the same exact files (project.msi and setup.msi) with the exact same modified date and byte size as they did when I downloaded them earlier today. Are you really suggesting that I should just reinstall the exact same files? Or did you mean that I should wait until those files are updated in some way before re-installing.

Thanks for the quick response!

Thanks

keithalewis wrote Jan 3, 2015 at 10:14 AM

Download https://xll8.codeplex.com and use VS 2013.

JohnAnon wrote Jan 3, 2015 at 10:48 AM

My computer doesn't give me a choice of using VS 2013, unless I'm not understanding the choices I'm being given.

The above link takes me to a page with the following text hyperlinked: Excel xll add-in library. When I follow the link it takes me back to https://xll.codeplex.com.

I think that is where I started earlier today. If I follow the link to Visual C++ 2010 Express, I note that there are other links but none of them are for VS 2013. The closest one is for Visual Studio 2013 Update 4 .

If you could direct me to where I can find VS 2013 I'd appreciate it.

Thanks!

keithalewis wrote Jan 3, 2015 at 1:21 PM

If you can't figure out how to install VS 2013 you shouldn't be using this library.
Maybe you should try https://www.add-in-express.com/.

JohnAnon wrote Jan 3, 2015 at 7:36 PM

I can install it, but onn my computer it isn't free. Maybe it is free on your computer?

keithalewis wrote Jan 3, 2015 at 10:37 PM

Nope.

JohnAnon wrote Jan 4, 2015 at 1:01 AM

If it isn't free, why would you suggest it? If your web page indicates that it works with VC++ 2010 Express, which is free, shouldn't you either look for the bug in your software or change the webpage so that it properly displays the software it does work with and not waste hours of reader's time installing something that you are now aware does not work? I decided to install based, in part, on your completely appropriate rants against those that waste your time by asking for C++ debugging. Well, here's my rant against developers that leave 1/2 baked webpages and do the same to the public. Get your act together, man, and drop the hypocritical, holier than thou, stuck up attitude (yes, I've read most of your blog posts). Try to keep in mind that I wasn't asking you for C++ help, just for direction on how to make what you say works ....... work. That's all.

keithalewis wrote Jan 4, 2015 at 2:21 AM

You told me you changed compiler settings. My advice was to not do that. It works for thousands of people, just not for JohnAnon the compiler settings fiddler.

I've updated the testimonials based on your helpful feedback.

JohnAnon wrote Jan 4, 2015 at 7:47 AM

quote from keithalewis wrote Nov 20, 2013 at 10:06 PM :

You can also replace the 10 in the library path by $(PlatformToolset).

I changed compiler settings? Really? I tried what you said to do!

And where exactly did you say not to do that? You can quote from ANY of your messages to me.

Why are you being this way?

JohnAnon wrote Jan 4, 2015 at 7:58 AM

If you are going to take a portion of that post and use it as a testimonial at least have the guts to use the whole thing.