[编程交流] plot x,y and z coordinate usin

 Public mstrBlockName As StringPublic blnBlockLabelFailure As BooleanPublic mstrImportType As StringPublic Sub ReadXYFile(strFileName As String)'mstrBlockName was set on userform before calling this sub routineDim myFile As IntegerDim lngIndex As LongDim strTextLine As StringDim arrText As VariantDim intCol As IntegerDim intSubStrings As IntegerDim dblX As DoubleDim dblY As DoubleDim dblZ As DoubleDim strName As String'strFileName = "C:\GIS\COORD_TEST3.csv" 'change this to your fileOn Error GoTo ErrorHandlerPoint' TODO: Take this check out, have already checked on form.If Dir(strFileName) = "" ThenCall MsgBox(strFileName & " not found", vbExclamation, "Import XYZ Coordinates")GoTo TidyUpAndExitEnd IfmyFile = FreeFileOpen strFileName For Input As #myFileDo While Not EOF(myFile)Line Input #myFile, strTextLinearrText = Split(strTextLine, ",")If lngIndex = 0 Then ' read first line to determine number columns in fileintSubStrings = UBound(arrText)'Debug.Print intSubStringsIf intSubStrings = 2 Then 'i.e. 3 columns, we are expecting X,Y,NamemstrImportType = "XYName"ElseIf intSubStrings = 3 Then 'i.e. 4 columns, we are expecting X,Y,Z and NamemstrImportType = "XYZName"ElsemstrImportType = ""Call MsgBox("The chosen file was invalid." & _vbCrLf & "" & _vbCrLf & "File must comprise 3 (X,Y,Name) or 4 (X,Y,Z,Name) columns of data only.", vbExclamation, "Import XYZ Coordinates")GoTo TidyUpAndExitEnd IfEnd If'if the columns are in the wrong order a type mismatch error will be thrown by the error handlerSelect Case mstrImportTypeCase "XYName"dblX = arrText(0)dblY = arrText(1)dblZ = 0strName = arrText(2)Call InsertBlock(dblX, dblY, dblZ, strName)Case "XYZName"dblX = arrText(0)dblY = arrText(1)dblZ = arrText(2)strName = arrText(3)Call InsertBlock(dblX, dblY, dblZ, strName)Case Else'????????????End SelectlngIndex = lngIndex + 1LoopTidyUpAndExit:'**** tidy up e.g. close and set objects to nothingClose myFileExit SubErrorHandlerPoint:MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure ReadXYFile"'could try to catch specific error, e.g possible type mismatch and provide meaningful messageGoTo TidyUpAndExitEnd SubSub InsertBlock(xx As Double, yy As Double, zz As Double, bAttr As String)Dim insertionPnt(0 To 2) As DoubleDim blockRefObj As AcadBlockReferenceDim varAttribs As VariantDim intAttribCount As Integer'Coordinate 'x=0,y=1,z=2insertionPnt(0) = xx#: insertionPnt(1) = yy#: insertionPnt(2) = 0'InsertBlock inserts a drawing file or a named block that has been defined in the current drawing.Set blockRefObj = ThisDrawing.ModelSpace.InsertBlock(insertionPnt, mstrBlockName, 1#, 1#, 1#, 0)' Get attribute value(s) from the block.varAttribs = blockRefObj.GetAttributes'Check how many attributes the block - if 0 set a boolean flagintAttribCount = UBound(varAttribs)If intAttribCount = -1 Then ' The block has no attributesblnBlockLabelFailure = True'Call MsgBox("The chosen block has no attributes to label.", vbInformation, "Import XYZ Coordinates")Else' We will use only the First attribute in the block found at location Zero.' varAttribs(0) is the first block attribute value.' Note, most programs uses Zero-based counting & therefore the first number is Zero when counting rather than one.varAttribs(0).TextString = bAttr' Update the block so we can see the new Values applied to the block attribute values above.' This is similar to a localized regen, only the block is updated/regenerated.varAttribs(0).UpdateEnd IfTidyUpAndExit:'**** tidy up e.g. close and set objects to nothingExit SubErrorHandlerPoint:MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure InsertBlock"'could try to catch specific error, e.g possible type mismatch and provide meaningful messageGoTo TidyUpAndExitEnd Sub

 [/ code] tags as it makes it easier to read, follow and copy  
Thanks
 
Lee