Skip to content

Instantly share code, notes, and snippets.

Govert van Drimmelen govert

Block or report user

Report or block govert

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@govert
govert / Test.vb
Created Aug 20, 2019
VB.NET Test for Google Groups question
View Test.vb
Option Explicit On
Imports ExcelDna.Integration ' for ExcelDnaUtil, XlCall, etc
Imports System.Math
Imports System.Runtime.InteropServices ' for <ComVisible(True)>
Imports ExcelDna.Integration.CustomUI ' needed for IRibbonControl
Imports DNAIRibbonControl = ExcelDna.Integration.CustomUI.IRibbonControl ' needed for IRibbonControl
Imports Microsoft.Office.Interop
Imports Microsoft.Office.Core
Imports Microsoft.Office.Interop.Excel ' Các giao diện như Workbook, Range
Module Globals
@govert
govert / ObservableClock.cs
Last active Dec 1, 2017
Test code for Excel-DNA IExcelObservable
View ObservableClock.cs
using System;
using System.Diagnostics;
using System.Threading;
using ExcelDna.Integration;
namespace TestDisposable
{
public static class RtdClock
{
[ExcelFunction(Description = "Provides a ticking clock")]
@govert
govert / FSharpTest.ipynb
Last active Jun 29, 2016
F# Feature Notebook Test
View FSharpTest.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@govert
govert / linear-regression.ipynb
Created Jun 29, 2016
Linear regression sample from EFavDB/linear-regression
View linear-regression.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@govert
govert / Excel-DNA Used Range.cs
Last active Jun 20, 2016
Uses the C API to retrieve the used range for a sheet, and intersect with a passed-in ExcelReference
View Excel-DNA Used Range.cs
using ExcelDna.Integration;
using static System.Math;
using static ExcelDna.Integration.XlCall;
public static class TestFunctions
{
[ExcelFunction(Description = "Returns the sum of cells in the target (using the used range for performance)", IsMacroType = true)]
public static object GetUsedSum([ExcelArgument(AllowReference = true)] object target)
{
// NOTE: This function will be volatile by default,
@govert
govert / RTD DisconnectData array issue.md
Last active Dec 12, 2018
RTD calls made from an array formula do not disconnect properly
View RTD DisconnectData array issue.md

Overview

The issue concerns the behaviour of Excel's RTD feature when:

  • the RTD call is made from a wrapper function,
  • the wrapper function is called from an array formula, and
  • in one of the calculation calls, the wrapper function does not make an RTD call.

The expected behaviour is that the RTD server gets a DisconnectData call for the relevant RTD topic.

The observed behaviour is that the RTD server does not get a DisconnectData call.

@govert
govert / Excel-DNA CLA.md
Created Sep 26, 2015
Excel-DNA Contributor License Agreement
View Excel-DNA CLA.md

Contributor License Agreement (CLA)

This CLA specifies how the Excel-DNA project is allowed to use your code.

When you make a contribution to the Excel-DNA project, you agree:

  1. The code you wrote is your original work (you own the copyright) or you otherwise have the right to submit the work.

  2. To grant the Excel-DNA project and its coordinator(s) a nonexclusive, irrevocable license to use your submitted code in any way.

  3. You are capable of granting these rights for the contribution.

@govert
govert / AsyncCaller.cs
Created Jul 2, 2015
A sample about recovering caller information for async calls, and the effect of different async keys
View AsyncCaller.cs
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Text;
using System.Threading;
using ExcelDna.Integration;
using ExcelDna.Logging;
namespace AsyncCaller
@govert
govert / GpsUtils.cs
Last active Dec 13, 2019
Convert WGS-84 geodetic locations (GPS readings) to Cartesian coordinates in a local tangent plane (Geodetic to ECEF to ENU)
View GpsUtils.cs
using System;
using System.Diagnostics;
using static System.Math;
// Some helpers for converting GPS readings from the WGS84 geodetic system to a local North-East-Up cartesian axis.
// The implementation here is according to the paper:
// "Conversion of Geodetic coordinates to the Local Tangent Plane" Version 2.01.
// "The basic reference for this paper is J.Farrell & M.Barth 'The Global Positioning System & Inertial Navigation'"
// Also helpful is Wikipedia: http://en.wikipedia.org/wiki/Geodetic_datum
@govert
govert / AsyncBatchExample.cs
Last active Oct 9, 2018
Async Batching Sample
View AsyncBatchExample.cs
using System;
using System.Collections.Generic;
using System.Threading;
using System.Threading.Tasks;
using System.Timers;
using Timer = System.Timers.Timer;
using ExcelDna.Integration;
namespace ExcelDnaSamples
{
You can’t perform that action at this time.