Functions.cs


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

using ExcelDna.Integration;

namespace Rehau.Sku.Assist
{
    public class Functions : IExcelAddIn
    {
        [ExcelFunction(description: "Получение наименования и артикула позиции")]
        public static object RAUNAME(string request)
        {
            SkuAssist.EnsureHttpInitialized();

            return ExcelTaskUtil.Run("RAUNAME ASYNC", request, async token =>
            {
                var document = await SkuAssist.GetDocumentAsync(request);
                return SkuAssist.GetResultFromDocument(document);
            });
        }

        public void AutoClose()
        {
            ExcelIntegration.RegisterUnhandledExceptionHandler(
                delegate (object ex) { return string.Format("!!!ERROR: {0}", ex.ToString()); });
        }

        public void AutoOpen()
        {
        }
    }
}