Adding Excel table to a layout page

2863
4
01-18-2019 11:33 AM
ChrisSlinko1
New Contributor II

I'm trying to add an excel spreadsheet or .pdf to the layout page either or the data view.  Does anyone have any ideas?

0 Kudos
4 Replies
TomBole
Esri Regular Contributor

Chris, 

You can import an Excel spreadsheet into ArcGIS Pro.  See Work with Microsoft Excel files in ArcGIS Pro—Excel | ArcGIS Desktop for more information.  Once you have the table in a map you can add the table to the layout by inserting a table frame. See Add and modify table frames—Layouts | ArcGIS Desktop

In ArcMap you could add object such as an Excel spreadsheet to a layout an an OLE object. This workflow is not supported in ArcGIS Pro. See 20039: OLE objects are not supported and were dropped from the layout—ArcGIS Pro | ArcGIS Desktop

Currently, there are no plans to support OLE (objects linked to MS applications) in ArcGIS Pro.  To support workflows that previously depended on OLE we are focusing on making improvements from within Pro. For example, we have added an improved table element and are working on improvements to formatting when using copy and paste into text elements from Microsoft Word.

 

Hope this helps,

Tom

0 Kudos
MichaelAugust
Occasional Contributor III

Hi Tom - so would each table in the above scenario be a separate Excel file?? Right now we use a single Excel worksheet to contain hundreds of boxes that describe analytical results for say 50 or so point locations on the map, these get pretty complicated with colors, italics, bold, etc. - our workflow and I'm sure for many others out there - was to open a formatted Excel worksheet and copy/paste these analyte boxes onto the layout view in ArcMap.

What would be your workflow solution for the same end product in Pro? I've attached an example here...I'd hate to think that we'd have to make a completely separate excel table or file for each of these boxes (there can be several hundred for us on a given figure set), then bring them into Pro, then format all of the tables in Pro on the layout individually, etc. - that's a lot more work than a single 5 sec. copy/paste onto a layout. Also none of our scientists work in Word vs. Excel so we're always going to get one large Excel worksheet containing multiple boxes, we need to get those boxes onto a map, splitting them into a hundred individual Excel files is unrealistic. 

I guess what I'm asking is how you would you, in Pro, display 30 Excel boxes like I've shown below on a map efficiently?  I'm reading thru the help and probably missing something, but it's just an example of one table with data from the living atlas, and it's pretty short on visuals.

Thanks!

0 Kudos
TomBole
Esri Regular Contributor

Michael, 

Looks like you would import 1 table from excel into a map, insert a table frame into the layout and then format the pieces.  You would lose the formatting you had in excel.  We do plan on adding table frame template in the future to make this easier, but I don't know when we will get to it. 

Tom

0 Kudos
VladimirStojanovic
New Contributor III

More than two and a half years later... Tom, I'm sorry to have to say this, but in my opinion this is absolutely ridiculous . Please allow some irony, I understand, this is no AI, 3D, AR and all other buzz words ESRI (and whole world) like to brag around on conferences and in paper articles... how far technology came... but this, this is just putting tables into layouts... how endless boring...

Nobody cares. Sad.

Cheers