using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace ConsoleApplication1 { /// <summary> /// 公用的特殊函数 /// </summary> public class SpecialFunctions { #region 构造函数 /// <summary> /// 构造函数 /// </s
发现Excel的VBA功能真是批量处理的一把利刃,工作中小试牛刀了一把,将Excel中度分秒形式的坐标批量处理成十进制度形式,处理完后用于GIS展点制图. 原Excel数据如下: VBA代码如下: Sub Coorder() Dim Longitude, Latitude As String, arr Dim num As Integer Dim LongColIdx As Integer Dim latColIdx As Integer LongColIdx = latColIdx = num
public String trandu2m(double d) { //gisoracle 编号 try { //double dd = Convert.ToDouble(str); String str = "" + d; int p = str.indexOf("."); int dt = Integer.parseInt(str.substring(0, p)); d = d - dt; double M = d * 60; int mt = (int) M
#必须是u类型==================u==================== by gisoracle def dmstod(dms): #arcpy.AddMessage("======================gisoracle==========="+dms+"==============================") try: p = dms.find('°') if p<0: return str(dms) #arcpy.