Author Topic: Importing Points from .xlsx File  (Read 3693 times)

0 Members and 1 Guest are viewing this topic.

Offline davidratxTopic starter

  • Premier Member
  • *****
  • Posts: 1401
  • Country: us
  • Gender: Male
Importing Points from .xlsx File
« on: May 01, 2015, 15:06:00 PM »
So I found this and it worked very slick so thought I would pass it along...

The thing you need too do is make sure the text file contains nothing but the coordinates for the points, if you have attributes or a point number mixed in with the coordinates you need to delete them from the file. So your text file is something like this:

1705145.103,829479.6554,0
1708780.203,825996.5793,0
1709520.941,823934.5335,0
1710569.845,824786.8715,0
1710583.068,824685.7594,0
1709493.485,828888.0862,0
1709298.454,831331.2523,0

Now with the file open select all the points and use ctrl+C to copy the lines to the windows clipboard. Back in your drawing give the MULTIPLE command, then the POINT command then paste the text from the clipboard by using ctrl+v when it asks “Specify a point”. The points should be created based on the text file. You then have to press the escape key to end the MULTIPLE command.

Command: multiple
Enter command name to repeat: point
Current point modes: PDMODE=35 PDSIZE=0.0000
Specify a point: “ctrl&v to paste the text file here”.

A simple way to add points.
David Ronson
TDIndustries Director of Construction Technologies
Windows 10 - Revit - AutoCAD - CADmep - ESTmep - CAMduct - GTP Stratus

Offline nansilly

  • Full Member
  • ***
  • Posts: 233
  • Country: us
  • Gender: Female
Re: Importing Points from .xlsx File
« Reply #1 on: Jun 26, 2017, 15:10:37 PM »
Thank you for your help.  However it doesn't seem to be working for me.  I typed in multiple, then point, then ctrl v to paste my points.  I got all point in one long line across the building.  See my snapshot below.  What am I missing?