All, My python codes were generated from ModelBuilder. At the process of "Table To Excel" I need to have 2 parameters: File_Path and File_Name. So in "Properties" of Script, I add those 2 parameters but the parameter for File Path doesn't work. No error but file was saved to the "Scratch" folder. What step that I missed? Thanks for your help. # Model Environment settings with arcpy . EnvManager ( scratchWorkspace = r "C:\ModelBuilder\Scratch\Output.gdb" , workspace = r "C:\ModelBuilder\Scratch\Output.gdb" ) : Output_gdb = "C:\\ModelBuilder\\Scratch\\Output.gdb" # Process: Table To Excel (Table To Excel) (conversion) arcpy . conversion . TableToExcel ( Input_Table = Parcels_Lots_DeleteIdentical , Output_Excel_File = ExcelFileName_xls , Use_field_alias_as_column_header = "ALIAS" , Use_domain_and_subtype_description = "DESCRIPTION" ) if __name__ == '__main__' : SqftMapToExcelNewLoc ( * argv [ 2 : ] )

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

python for Pro: how to set File Path parameter

helenchu

All,

My python codes were generated from ModelBuilder. At the process of "Table To Excel" I need to have 2 parameters: File_Path and File_Name. So in "Properties" of Script, I add those 2 parameters but the parameter for File Path doesn't work. No error but file was saved to the "Scratch" folder. What step that I missed? Thanks for your help.

<SPAN class="comment token"># Model Environment settings</SPAN>
 <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>EnvManager<SPAN class="punctuation token">(</SPAN>scratchWorkspace<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\ModelBuilder\Scratch\Output.gdb"</SPAN><SPAN class="punctuation token">,</SPAN> workspace<SPAN class="operator token">=</SPAN>r<SPAN class="string token">"C:\ModelBuilder\Scratch\Output.gdb"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
 Output_gdb <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\\ModelBuilder\\Scratch\\Output.gdb"</SPAN>

<SPAN class="comment token"># Process: Table To Excel (Table To Excel) (conversion)</SPAN>
 arcpy<SPAN class="punctuation token">.</SPAN>conversion<SPAN class="punctuation token">.</SPAN>TableToExcel<SPAN class="punctuation token">(</SPAN>Input_Table<SPAN class="operator token">=</SPAN>Parcels_Lots_DeleteIdentical<SPAN class="punctuation token">,</SPAN> Output_Excel_File<SPAN class="operator token">=</SPAN>ExcelFileName_xls<SPAN class="punctuation token">,</SPAN> Use_field_alias_as_column_header<SPAN class="operator token">=</SPAN><SPAN class="string token">"ALIAS"</SPAN><SPAN class="punctuation token">,</SPAN> Use_domain_and_subtype_description<SPAN class="operator token">=</SPAN><SPAN class="string token">"DESCRIPTION"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
 SqftMapToExcelNewLoc<SPAN class="punctuation token">(</SPAN><SPAN class="operator token">*</SPAN>argv<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

danretired

where is argv defined?

All comments

helenchu

I guess I didn't have it defined. I'm not familiar with python so please excuse my stupid questions above. I'll try to see if I can define the argv. Thank you!

danretired

where is argv defined?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.