1 files changed, 24 insertions, 0 deletions

diff --git a/Functions.cs b/Functions.cs
new file mode 100644
index 0000000..999a942
--- /dev/null
+++ b/Functions.cs
@@ -0,0 +1,24 @@
+using ExcelDna.Integration;
+
+namespace Rehau.Sku.Assist
+{
+    public class Functions : IExcelAddIn
+    {
+        [ExcelFunction(description: "Получение наименования и артикула позиции")]
+        public static string RAUNAME(string request)
+        {
+            SkuAssist.EnsureHttpInitialized();
+            return SkuAssist.GetSku(request);
+        }
+
+        public void AutoClose()
+        {
+            ExcelIntegration.RegisterUnhandledExceptionHandler(
+                delegate (object ex) { return string.Format("!!!ERROR: {0}", ex.ToString()); });
+        }
+
+        public void AutoOpen()
+        {
+        }
+    }
+}
\ No newline at end of file