I'm trying to use excel for some functionality that would be handy in a script
I know the line of C# I need in the script is
CODE:
Please log in to see this code.
and I've downloaded and installed these interop libraries but can't seem to find the .dll's I need to reference.
Has anyone done this and can point me in the right direction?
Thanks!
Size:
Color:
Size:
Color:
Thanks Eugene
I've tried, in the editor, to add a reference but Excel/Office is not listed under .Net Framework or Other Assemblies to Reference so I cannot see the COM object. Does this mean that I have to run WL under Visual Studio as I would if I was debugging a strategy or is there a way to do it from the editor?
Size:
Color:
You need to reference not the COM object but its .NET wrapper DLL file.
Size:
Color:
Thanks.
By chance, do you happen to know the name of this DLL file. That's really the only issue I have and if you know, it would help me enormously (and perhaps other readers of this thread)
Size:
Color:
Last time I worked with Excel was 10 years ago so I don't know for sure. OpenOffice/Google Drive is a perfect replacement for me. I guess it's called Microsoft.Office.Interop.Excel.dll and appears after installing "Office Primary Interop Assemblies" (included with MS Office). To find its location on your PC please follow post #2 and below (not the accepted answer):
What reference do I need to use Microsoft.Office.Interop.Excel in .NET?
Size:
Color:
Thanks Eugene.
This "should" do the trick.
I've followed steps correctly after downloading the Primary Interop assemblies but just can't determine where the files are located.
I'll follow up when found.
Size:
Color:
1. They have to be installed into the GAC by the installer, not just 'downloaded'.
2. I'm not sure but their bitness (32/64-bit) may have to match Wealth-Lab's bitness.
3. Not sure again but to get there you may need to enable hidden file/folder visibility in Windows Folder Options.
Size:
Color: