Author Topic: TABLE EDIT POLYLINE  (Read 26637 times)

vagk_18

  • Jr. Member
  • **
  • Posts: 33
TABLE EDIT POLYLINE
« on: February 22, 2013, 09:01:16 AM »
Hi,Lars
I started this message becouse I have a problem with the csv file that is exported. If I open it with notepad, or wordpad I see the results ok. If I open it directly with excel I see the results
in one column and something like this "6   ?116.491?680.73??5" in every line. Do you have any suggestions?

It would be very usuful for me if I opened it directly from excel.
I 'd like to suggest to also promt the calculation of the elevation difference, like you made for the profile "3d polyline", if possible.
Thanks for your time.

Lars

  • Administrator
  • Hero Member
  • *****
  • Posts: 664
Re: TABLE EDIT POLYLINE
« Reply #1 on: February 22, 2013, 05:20:59 PM »
I don't think "Table Edit" command can export to a CSV-file. What command are you using?

Lars

  • Administrator
  • Hero Member
  • *****
  • Posts: 664
Re: TABLE EDIT POLYLINE
« Reply #2 on: February 23, 2013, 09:55:00 AM »
Using saved intersections in Excel. The best way ist to select all text in Notepad, copy it and then paste it into a empty ExcelSheet.

aldebaran

  • Jr. Member
  • **
  • Posts: 30
Re: TABLE EDIT POLYLINE
« Reply #3 on: February 25, 2013, 09:09:25 AM »
Really you can export  to *.csv file that you can read  with excell
Also you can do them real excell files using
the command  data \ text to columns
so you have all data to columns

vagk_18

  • Jr. Member
  • **
  • Posts: 33
Re: TABLE EDIT POLYLINE
« Reply #4 on: February 25, 2013, 10:40:47 AM »
The command is in the file option, File, export to csv file.

vagk_18

  • Jr. Member
  • **
  • Posts: 33
Re: TABLE EDIT POLYLINE
« Reply #5 on: February 25, 2013, 10:43:00 AM »
Sorry,
File, save to csv file.
After you read any line.

Lars

  • Administrator
  • Hero Member
  • *****
  • Posts: 664
Re: TABLE EDIT POLYLINE
« Reply #6 on: February 26, 2013, 06:11:04 AM »
After you have saved it to CSV open Excel, use Data, Import, From Text, in Excel.

Lars

  • Administrator
  • Hero Member
  • *****
  • Posts: 664
Re: TABLE EDIT POLYLINE
« Reply #7 on: February 26, 2013, 07:29:51 PM »
I'll add an option to copy selected range in the grid of "Table Edit" in CadTools. The selected range can be pasted directly into Excel.

This will be in next update (probably this week)

vagk_18

  • Jr. Member
  • **
  • Posts: 33
Re: TABLE EDIT POLYLINE
« Reply #8 on: February 27, 2013, 10:45:38 AM »
Thank you for your concern about this subject.
I only want to ask you if you can add the elevetion difference between the vertices of the polyline,
as a new column and not only the slope% after your "read a polyline".
Of cource the option to save in excel directly is very helpfull.