sketchucation logo sketchucation
    • Login
    ℹ️ Licensed Extensions | FredoBatch, ElevationProfile, FredoSketch, LayOps, MatSim and Pic2Shape will require license from Sept 1st More Info

    Adding Spreadsheets or Tables to layout page

    Scheduled Pinned Locked Moved LayOut Discussions
    layout
    19 Posts 13 Posters 7.5k Views 13 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • pbacotP Offline
      pbacot
      last edited by

      I think I would just print Excel to pdf and insert the pdf.

      MacOSX MojaveSketchUp Pro v19 Twilight v2 Thea v3 PowerCADD

      1 Reply Last reply Reply Quote 0
      • Dave RD Offline
        Dave R
        last edited by

        Peter, that works well if you're using a Mac. On PC, not so much.

        Etaoin Shrdlu

        %

        (THERE'S NO PLACE LIKE)

        G28 X0.0 Y0.0 Z0.0

        M30

        %

        1 Reply Last reply Reply Quote 0
        • pbacotP Offline
          pbacot
          last edited by

          What happens on a PC?

          MacOSX MojaveSketchUp Pro v19 Twilight v2 Thea v3 PowerCADD

          1 Reply Last reply Reply Quote 0
          • Dave RD Offline
            Dave R
            last edited by

            No PDF import option.

            Etaoin Shrdlu

            %

            (THERE'S NO PLACE LIKE)

            G28 X0.0 Y0.0 Z0.0

            M30

            %

            1 Reply Last reply Reply Quote 0
            • S Offline
              seasdes
              last edited by

              FastStone Capture allows screen clips to be saved at whatever resolution that you want. I use it every day.

              Using Sketchup Pro 2019

              1 Reply Last reply Reply Quote 0
              • C Offline
                caronte01
                last edited by

                I generate PDF from libre office, and then open it in inkscape, where I can save as PNG. At 200-300 DPI. Yes, layout PC needs PDF import badly!!!

                1 Reply Last reply Reply Quote 0
                • G Offline
                  Garyvn
                  last edited by

                  I just did a quick check then with Excel and Layout

                  not sure if this is a capability new to Layout 2015 but

                  Copy and paste from excel to LO worked fine - editable table in a text box

                  Also trying a way I always use via powerpoint to keep the formatting and colours of Excel

                  1] select range in excel
                  2] paste as image in powerpoint
                  3] copy that image from powerpoint
                  4] pasting into layout - quick and pretty spreadsheet

                  hope that helps

                  1 Reply Last reply Reply Quote 0
                  • C Offline
                    Chailas
                    last edited by

                    In a PC you can use the snipping tool and save the image as a .jpg

                    1 Reply Last reply Reply Quote 0
                    • ashscottA Offline
                      ashscott
                      last edited by

                      Have just been doing some tables from excel to Layout - they copied and pasted quite nicely so long as I didn't try and edit them in Layout - it seems Layout reads them better than it did a few versions back when I tried this and consistently got tabs jumping all over the place.

                      TL;DR: Try copy pasting from your spreadsheet to Layout first - could save you some time.

                      Just some stuff I do with Sketchup.

                      1 Reply Last reply Reply Quote 0
                      • S Offline
                        shawb
                        last edited by

                        Hi,

                        I have been looking at the Excel table into LO thing (or lack of in the PC version). Here is my offering:

                        Create your table in Excel with cell widths, heights, font size and formulas. Make sure that any editable data can be copied and pasted as a block (for convenience).
                        Format a matching area in the spreadsheet as a swap area.
                        Select the entire table, copy and paste into LO. The table comes in as an editable text block with cells bordered in black lines.
                        Make any changes to data in individual cells. Note, no formulas are copied just the numbers.
                        Double click in the text box which will select all cell data.
                        Copy and then paste back into the Excel sheet but in the formatted swap area.
                        Select the data to be changed and paste into the original table position.
                        The formula results will update.
                        Start back at the beginning! Re-copy the updated table and double click in the LO text box, paste.

                        Not perfect but seems to work. Basically it is a way of re-calculating a table using Excel and not having to do it manually.

                        Brian

                        1 Reply Last reply Reply Quote 0
                        • 1 / 1
                        • First post
                          Last post
                        Buy SketchPlus
                        Buy SUbD
                        Buy WrapR
                        Buy eBook
                        Buy Modelur
                        Buy Vertex Tools
                        Buy SketchCuisine
                        Buy FormFonts

                        Advertisement