Hello Folks,
Trying to troubleshoot a few issues that appear connected to a recent upgrade from 2.8 to 2.9 PRO.
The focus of this post is the repeated failure of ExcelToTable running both from the GUI and as an arcPy command (see code below for call and references).
I have tried using multiple xlsx input files and continually get the same issue, which is that it runs 'successfully' (no error thrown in either GUI or arcPy console), but that it returns a table with only the header of column A in the excel file in it (cell A1). This happens even if I explicitly specify a wider range of cell values to read (e.g. A1:D20).
This command ran fine under a prior PRO version. I can't confirm explicitly that the version was 2.8 as it has been a while since the code was run and I may have updated several times). I certainly expected the GUI process to work. It does not (see issue example on image).
I have uninstalled and reinstalled ArcGIS PRO. The problem persists.
I will mention the other issue I have been dealing with since the 2.9 update, which is that it broke my python environment (original reason I uninstalled and reinstalled PRO while deleting the "conda" folder). The python environment issue only appears to have been fixed on updating all python packages (but still early days). I do not think the two issues are related but am mentioning anyway.
Suggestions/Thoughts/HELP anyone?
Thank you, Andrew
Code snippet:
##https://pro.arcgis.com/en/pro-app/latest/tool-reference/conversion/excel-to-table.htm
##arcpy.conversion.ExcelToTable(Input_Excel_File, Output_Table, {Sheet}, {field_names_row}, {cell_range})
arcpy.ExcelToTable_conversion ( SourceData , ( OutputGDB + "\\" + resources[0] ) , resources[0] )
