Transform coordinates between various map projections directly within Excel.
This program currently uses version 4 of the PROJ Cartographic Projections Library.
Copy proj.xll to %USERPROFILE%\AppData\Roaming\Microsoft\AddIns\.
Go to Excel Options, Add-ins, Manage Excel Add-ins. Click Browse, and select proj.xll.
To display the PROJ library version:
=PROJ.VERSION()
To transform coordinates, for example from latitude/longitude to UTM zone 17:
=PROJ.TRANSFORM("+proj=latlong +datum=WGS84","+proj=utm +zone=17 +datum=WGS84",RADIANS(-80),RADIANS(40),1)
=PROJ.TRANSFORM("+proj=latlong +datum=WGS84","+proj=utm +zone=17 +datum=WGS84",RADIANS(-80),RADIANS(40),2)
Arguments:
- Source coordinate system
- Destination coordinate system
- X value
- Y value
- Output: 1=X, 2=Y
Latitude and longitude values must be in radians.
EPSG codes are also supported using the EPSG() helper function. For example, to transform from latitude/longitude to Web Mercator:
=PROJ.TRANSFORM(EPSG(4326),EPSG(3857),RADIANS(-89.83152841),RADIANS(40.91627447),1)
=PROJ.TRANSFORM(EPSG(4326),EPSG(3857),RADIANS(-89.83152841),RADIANS(40.91627447),2)
Download the PROJ source, tested with v4.9.3 (2016-09-02). Extract to C:\PROJ.
Edit the PROJ.4 OPTFLAGS in nmake.opt as follows, to use the static multithreaded version of the CRT library (/MT):
!IFNDEF OPTFLAGS
!IFNDEF DEBUG
OPTFLAGS= /nologo /Ox /Op /MT
!ELSE
OPTFLAGS= /nologo /Zi /MTd /Fdproj.pdb
!ENDIF
!ENDIF
Build the PROJ.4 static library from a Visual Studio command prompt:
C:\PROJ>nmake /f makefile.vc
C:\PROJ>nmake /f makefile.vc install-all
Download and install the Excel 2013 SDK to the default location. As with PROJ, update the SAMPLES/FRAMEWRK makefile to use the static CRT (/MT):
!if "$(TYPE)" == "DEBUG"
CPPFLAGS =/Od /W3 /WX /EHsc /Zi /MTd /Fd"$(FRAMEWORK_PDB)" /Fo"$(FRAMEWORKBUILDDIR)\\"
!else
CPPFLAGS =/W3 /WX /EHsc /MT /Fo"$(FRAMEWORKBUILDDIR)\\"
!endif
Build the library from a Visual Studio command prompt:
C:\2013 Office System Developer Resources\Excel2013XLLSDK\SAMPLES\FRAMEWRK>nmake TYPE=RELEASE
You should now be able to build the XLL using the nmake makefile.