topic Re: XTools Pro - Export Table to MS Excel in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/xtools-pro-export-table-to-ms-excel/m-p/350914#M12181 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hi there,<BR /><BR />I have created a model that merges several dbfs then exports that final merged table to an excel file.&nbsp; All the results of the tool are contained in that exel file,<BR /><BR />I am just wondering if anyone knows how to format the resulting excel file such that its more clear to the end user. <BR /><BR />The tool outputs several spatial statistics for shapefiles, I would like to input labels into column 1: "Min, mean, within 600m, etc." so the end user knows exactly what all the numbers mean.&nbsp; </BLOCKQUOTE><BR /><BR /><SPAN>You can control the output field names using the field mapping parameter in the Merge tool. If you aren't changing with the inputs, you can do this using the </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/0021/00210000000s000000.htm">field mapping control</A><SPAN> in the Merge tool dialog within your model. Otherwise, you may have to use Python to set up your field mapping (you can do this with the Calculate Value tool). Programming field mappings in Python is challenging, but it does work.</SPAN></BODY></HTML> Fri, 11 Jan 2013 17:42:19 GMT curtvprice 2013-01-11T17:42:19Z XTools Pro - Export Table to MS Excel https://community.esri.com/t5/geoprocessing-questions/xtools-pro-export-table-to-ms-excel/m-p/350913#M12180 <HTML><HEAD></HEAD><BODY><SPAN>Hi there,</SPAN><BR /><BR /><SPAN>I have created a model that merges several dbfs then exports that final merged table to an excel file.&nbsp; All the results of the tool are contained in that exel file,</SPAN><BR /><BR /><SPAN>I am just wondering if anyone knows how to format the resulting excel file such that its more clear to the end user. </SPAN><BR /><BR /><SPAN>The tool outputs several spatial statistics for shapefiles, I would like to input labels into column 1: "Min, mean, within 600m, etc." so the end user knows exactly what all the numbers mean.&nbsp; </SPAN><BR /><BR /><SPAN>Is this possible without moving into python?</SPAN><BR /><BR /><SPAN>Please let me know if you have any ideas and thanks in advance!!</SPAN></BODY></HTML> Mon, 07 Jan 2013 16:49:58 GMT https://community.esri.com/t5/geoprocessing-questions/xtools-pro-export-table-to-ms-excel/m-p/350913#M12180 ShinoRah 2013-01-07T16:49:58Z Re: XTools Pro - Export Table to MS Excel https://community.esri.com/t5/geoprocessing-questions/xtools-pro-export-table-to-ms-excel/m-p/350914#M12181 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Hi there,<BR /><BR />I have created a model that merges several dbfs then exports that final merged table to an excel file.&nbsp; All the results of the tool are contained in that exel file,<BR /><BR />I am just wondering if anyone knows how to format the resulting excel file such that its more clear to the end user. <BR /><BR />The tool outputs several spatial statistics for shapefiles, I would like to input labels into column 1: "Min, mean, within 600m, etc." so the end user knows exactly what all the numbers mean.&nbsp; </BLOCKQUOTE><BR /><BR /><SPAN>You can control the output field names using the field mapping parameter in the Merge tool. If you aren't changing with the inputs, you can do this using the </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/0021/00210000000s000000.htm">field mapping control</A><SPAN> in the Merge tool dialog within your model. Otherwise, you may have to use Python to set up your field mapping (you can do this with the Calculate Value tool). Programming field mappings in Python is challenging, but it does work.</SPAN></BODY></HTML> Fri, 11 Jan 2013 17:42:19 GMT https://community.esri.com/t5/geoprocessing-questions/xtools-pro-export-table-to-ms-excel/m-p/350914#M12181 curtvprice 2013-01-11T17:42:19Z