Legend to Excel

Michael Csiki
Michael Csiki Posts: 6
edited December 12 in Peer Support

Hello, I want to be able to export the information from a legend easily to Excel.

I know you can export all the markups and work from there, but the legend has everything nicely summarized and I would like to manipulate the info more in Excel.

I tried the File > Export > Excel Workbook > Page Region … but it clumps it into a text box and when copy and pasting the info its all one cell.

Any ideas?

Answers

  • ECI-Dpainter
    ECI-Dpainter Posts: 3
    edited December 12
    image.png

    Try inserting some lines/rectangles around your legend data to make it clear that the info is in a table. I tried a quick example by writing some text then flattening it and exporting the region to excel…as you said everything was grouped in a single cell. Then I grouped a bunch of rectangles around the data, flattened, and exported the region again, this time it was set up in a table.

  • Michael Csiki
    Michael Csiki Posts: 6

    Thanks, I am using the Legend that is being populated by a toolchest.
    Example Legend below and excel region capture further below.
    I thought maybe trying the Snapshot tool to capture the dynamic Legend to a static vector with the data copied in hard, and then exporting the region to excel but similar result, last snip below.

    image.png
    image.png
    image.png

  • Luke Shiras
    Luke Shiras Posts: 336

    This is when I wish we had emojis to "like" a post. 😮

    Is that all one cell and is the "table" lines an image?

Categories