Trimble Business Center

 View Only
Expand all | Collapse all

Excel Tables in TBC Drafting

  Thread closed by the administrator, not accepting new replies.
  • 1.  Excel Tables in TBC Drafting

    Posted 07-30-2021 07:49
    No replies, thread closed.
    Aside from creating a .pdf / georeferencing the .pdf / dynaview the .pdf to the sheet view, is there an easy way to insert excel tables, ultimately to the sheet view for plotting/drafting of a "field to finish" deliverable, in TBC?

    Use of the clipboard, another words widely used current technology, would certainly be helpful.

    ------------------------------
    Richard Tyndall
    ------------------------------


  • 2.  RE: Excel Tables in TBC Drafting

    Posted 07-30-2021 14:05
    No replies, thread closed.

    The InsertExcelTable command will allow you to insert a table from an excel file and control text style/colour etc... It doesn't use copy and paste currently. See example screenshot below.



    ------------------------------
    Dylan Towler
    www.tbcanz.com/anz-toolbox/
    ------------------------------



  • 3.  RE: Excel Tables in TBC Drafting

    Posted 07-31-2021 09:34
    No replies, thread closed.
    Dylan, where has this command been hiding!  I'm very excited to see this in the software, I was unaware of it.  I have it available in my command pane but it says my license does not include it.  I can't imagine what license it must be under?!  I have survey advanced and drafting (among others) but I would think it is in one of them.  Unless its in the pesky ANZ toolbox that has all these nice commands that I can't get.

    ------------------------------
    Wayne Welshans
    ------------------------------



  • 4.  RE: Excel Tables in TBC Drafting

    Posted 07-31-2021 15:57
    No replies, thread closed.
    ANZ- with those coordinates, it seems it is a ANZ command.

    ------------------------------
    Francisco Guerrero
    ------------------------------



  • 5.  RE: Excel Tables in TBC Drafting

    Posted 07-31-2021 16:35
    No replies, thread closed.
    Hi Wayne, the module is not restricted to a particular region and is available worldwide. You can see a list of all the commands (they all support imperial units btw) and functionality included here: https://tbcanz.com/anz-toolbox/

    ------------------------------
    Dylan Towler
    www.tbcanz.com/anz-toolbox/
    ------------------------------



  • 6.  RE: Excel Tables in TBC Drafting

    Posted 08-01-2021 12:51
    Edited by Scott Bridges 08-02-2021 20:22
    No replies, thread closed.
    “Comment removed due to breach of community standards.”


  • 7.  RE: Excel Tables in TBC Drafting

    Posted 08-01-2021 19:58
    Edited by Scott Bridges 08-02-2021 20:22
    No replies, thread closed.
    “Comment removed due to breach of community standards.”


  • 8.  RE: Excel Tables in TBC Drafting

    Posted 08-02-2021 05:23
    Edited by Scott Bridges 08-02-2021 20:22
    No replies, thread closed.
    “Comment removed due to breach of community standards.”


  • 9.  RE: Excel Tables in TBC Drafting

    Posted 08-02-2021 12:14
    No replies, thread closed.
    Hi Richard,

    Looks like the website section has been updated to clarify, "SITECH CS".

    Commands (+ importer/exporter) for the ANZ market have been around for a long time - originally installed separately, later included in the TBC install options, and now part of the TBC licensing system.

    I hadn't kept up with it, but noticed last year that they had some general market commands - and appear to be creating more, which is great for the community.

    ------------------------------
    Quan Mueller
    Revenant Solutions - TML Development
    ------------------------------



  • 10.  RE: Excel Tables in TBC Drafting

    Posted 08-02-2021 14:33
      |   view attached
    No replies, thread closed.
    Before they came out with their macro I wrote a simple one myself. I haven't worked on it in a while.
    Mine doesn't color code and only works with plain ASCII CSV files.
    Give it a try. Maybe it's enough for your needs.

    ------------------------------
    Ronny Schneider
    ------------------------------

    Attachment(s)

    zip
    SCR_CSVtoTable.zip   11 KB 1 version