|
Leon Lai Kan
Posts: 200
Joined: 2018-12-20
|
Hi,
I am trying to reproduce the following addin from scratch:
Importing data from SQL databases and other sources to Microsoft Excel
https://www.add-in-express.com/creating-addins-blog/2013/10/30/excel-importing-data-sql-databases/
The ExcelData.AddinModule.cs has the following "using" among others:
using Microsoft.Data.ConnectionUI;
No problem with this!
-----
But when I create a Test addin in a similar way, I get this error:
"The type or namespace "Data" does not exist in the namespace Microsoft.Are you missing an assembly Reference?"
In fact, when I type "using Microsoft.",
IntelliSense displays "Data" in your sample, but in my Test addin, it does not display "Data".
{ } CSharp
red ...... problem with Data... this appears with your sample, but not in my test addin
{ } Office
{ } Runtime
{ } SqlServer
{ } Vbe
{ } VisualBasic
{ } Win32
What has gone wrong?
Thanks
Leon |
|
Posted 09 Jan, 2019 06:28:44
|
|
Top
|
|
Andrei Smolin
Add-in Express team
Posts: 18793
Joined: 2006-05-11
|
Hello Leon,
That add-in project references DLLs located in folder called 'lib'. Make sure your project references these DLLs.
Andrei Smolin
Add-in Express Team Leader |
|
Posted 09 Jan, 2019 07:06:02
|
|
Top
|
|
Leon Lai Kan
Posts: 200
Joined: 2018-12-20
|
Hi, Andrei
Where is this "lib" folder hidden?
leon |
|
Posted 09 Jan, 2019 07:13:51
|
|
Top
|
|
Andrei Smolin
Add-in Express team
Posts: 18793
Joined: 2006-05-11
|
Find a link to the ZIP file right below the title Available Downloads on that page.
Andrei Smolin
Add-in Express Team Leader |
|
Posted 09 Jan, 2019 07:16:25
|
|
Top
|
|
Leon Lai Kan
Posts: 200
Joined: 2018-12-20
|
Hi, Andrei
I found the lib folder.
But there are many things that are puzzling me:
------------------------------------------------------------
If these DLL are provided by you, and not available freely from Microsoft, it can only mean that these DLL were written by ADX?
Am I right?
Since I am developing in VB .NET and not C#, maybe I cannot develop my addin if I use your dll?
-------------------------------------------------------------
Suppose someone did not come across your DLL. Then he would not be able to develop an add-in requiring a DLL connection?
He will have to write his own connection program?
------------------------------------------------------------
Your blog is quite old (2013). If the DLL were written by you, I presume it is also quite old.
What will happen if one day Microsoft modifies its programs, and your DLL stops working?
------------------------------------------------------------
Thanks
Leon |
|
Posted 09 Jan, 2019 07:56:35
|
|
Top
|
|
Andrei Smolin
Add-in Express team
Posts: 18793
Joined: 2006-05-11
|
Leon,
Indeed, to my surprise, the files are not created by Microsoft. You would need to write your code producing that functionality.
Andrei Smolin
Add-in Express Team Leader |
|
Posted 09 Jan, 2019 10:56:34
|
|
Top
|
|
Leon Lai Kan
Posts: 200
Joined: 2018-12-20
|
Wow!
Thanks
It's 20:00 in Mauritius, and very hot these days.
Leon |
|
Posted 09 Jan, 2019 11:03:17
|
|
Top
|
|
Andrei Smolin
Add-in Express team
Posts: 18793
Joined: 2006-05-11
|
-5..-15 C :)
Andrei Smolin
Add-in Express Team Leader |
|
Posted 10 Jan, 2019 05:34:01
|
|
Top
|
|