0% found this document useful (0 votes)
95 views2 pages

Super Pro Sáyai

The document contains commands to package and publish NuGet packages for two projects AUExpress.AddIn and AUExpress.International. It then shows errors encountered when trying to initialize and load an Excel add-in built with ExcelDna, likely due to missing files or incorrect configuration.

Uploaded by

The GridLock
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
95 views2 pages

Super Pro Sáyai

The document contains commands to package and publish NuGet packages for two projects AUExpress.AddIn and AUExpress.International. It then shows errors encountered when trying to initialize and load an Excel add-in built with ExcelDna, likely due to missing files or incorrect configuration.

Uploaded by

The GridLock
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

nuget pack AUExpress.AddIn.

nuspec

nuget pack AUExpress.International.nuspec


nuget push AUExpress-International.1.0.0.nupkg
oy2efd6fg7fwua356cgqf3lvdg2ybqbublb53u6trjrlvi -Source
https://api.nuget.org/v3/index.json
nuget push AUExpress-AddIn.1.0.0.nupkg
oy2efd6fg7fwua356cgqf3lvdg2ybqbublb53u6trjrlvi -Source
https://api.nuget.org/v3/index.json

AUExpress.RDeclareFunction

Initialization [Error] External library could not be registered - Path:


AUExpress_CopyPaste.dll : FileNotFoundException - Could not find file
'D:\2.0_VSTO_PROJECT\D_1_MY_PROJECT\1 EXCEL\.NET\3 vsto
Addiin\ExcelCopyPasteVisibleCell\ExcelCopyPaste\ExcelCopyPaste\bin\Release\AUExpres
s_CopyPaste-Xs'.

'https://www.advancedinstaller.com/forums/viewtopic.php?f=2&t=20789
'https://www.nuget.org/packages/UnmanagedExports/
'https://sites.google.com/site/robertgiesecke/Home/uploads/csharpprojecttemplatefor
unmanagedexports

Initialization [Error] The required .dna script file


D:\2.0_VSTO_PROJECT\D_1_MY_PROJECT\1 EXCEL\.NET\3 vsto
Addiin\ExcelCopyPasteVisibleCell\ExcelCopyPaste\ExcelCopyPaste\bin\Debug\AUExpress_
CopyPaste-Xs.dna does not exist.
Initialization [Error] No Dna Library found.

Imports AUExpress.International

Public Module MyFunctionsss


<ExcelFunction(Description:="My first .NET function")>
Public Function SayHelloo(ByVal name As String) As String
Return "Hello " & name
End Function
End Module

Public Class AddIn


Implements IExcelAddIn
'https://gist.github.com/govert/1200178
'https://groups.google.com/forum/#!topic/exceldna/ZyVNjEmg-Hs
Public Sub AutoOpen() Implements IExcelAddIn.AutoOpen
'Try
' Throw New System.Exception("Cannot Load .xll Only")
'Catch ex As Exception
' MsgBox("You cannot Load .Xll file only")
'End Try
MsgBox("First")
If (ClsAURibbon2.Loadxll) Then
Dim now As Double = CDbl(XlCall.Excel(XlCall.xlfNow))
XlCall.Excel(XlCall.xlcOnTime, now, "RemoveMe")
End If
'Dim registerId As Object
'Dim result As XlCall.XlReturn = XlCall.TryExcel(XlCall.xlfRegister,
registerId, "C:\Work\ExcelDna\Samples\MetaAddin\AddIn.xll")
End Sub
Public Shared Sub RemoveMe()
MsgBox("This add-in has been disabled.", "Add-in")
Dim myName As String = CStr(XlCall.Excel(XlCall.xlGetName))
Dim removeId As Object = XlCall.Excel(XlCall.xlfRegister, myName,
"xlAutoRemove", "I", ExcelEmpty.Value, ExcelEmpty.Value, 2)
Dim removeResult As Object = XlCall.Excel(XlCall.xlfCall, removeId)
Dim removeUnregister As Object = XlCall.Excel(XlCall.xlfUnregister,
removeId)
End Sub
Public Sub AutoClose() Implements IExcelAddIn.AutoClose
MsgBox("Welcomne")
End Sub

End Class

moit so loi thuong gap khi dung excel dna


-ten du an va ten assembly khong trung khop
-ten package, ten file trong .dna va assembly khong trung khop

25

You might also like