topic Re: Converting Excel files to GDB question in Python Questions

Converting Excel files to GDB question

MichaelMiller2 — Tue, 01 May 2012 17:22:17 GMT

What is the proper method of accessing excel files using Python?

I'm using the below code and it returns the following error message:
ERROR 000732: Input Rows: Dataset 2005.xlsx does not exist or is not supported
Failed to execute (TableToTable).

import arcpy import os arcpy.env.overwriteOutput = 1 arcpy.env.workspace = r"\\itdhq1apt50\GIS_Data\Test_MM\KellyRawCrash" for file in arcpy.ListFiles("*.xlsx"):     outBase, outExt = os.path.splitext(file)     outCrash = "Crash" + outBase     print file     print outCrash     arcpy.TableToTable_conversion(file, gdb_loc, outCrash)

Michael Miller

Re: Converting Excel files to GDB question

MathewCoyle — Tue, 01 May 2012 17:36:27 GMT

Here's an example of something close to what I do. Each sheet is it's own table.

import arcpy, os arcpy.env.workspace = r"C:\GIS\xlsxTest" outPath = r"C:\GIS\xlsxTest\output" fileList = arcpy.ListFiles("*.xlsx") for file in fileList:     arcpy.env.workspace = os.path.join(r"C:\GIS\xlsxTest", file)     tabList = arcpy.ListTables()      # Convert excel to DBF     tabNum = 0     for tab in tabList:         tabNum += 1         arcpy.TableToTable_conversion(tab, outPath, "Table"+tabNum+".dbf")

Re: Converting Excel files to GDB question

MichaelMiller2 — Sat, 11 Dec 2021 06:52:19 GMT

Here's an example of something close to what I do. Each sheet is it's own table.

import arcpy, os
arcpy.env.workspace = r"C:\GIS\xlsxTest"
outPath = r"C:\GIS\xlsxTest\output"
fileList = arcpy.ListFiles("*.xlsx")
for file in fileList:
    arcpy.env.workspace = os.path.join(r"C:\GIS\xlsxTest", file)
    tabList = arcpy.ListTables()

    # Convert excel to DBF
    tabNum = 0
    for tab in tabList:
        tabNum += 1
        arcpy.TableToTable_conversion(tab, outPath, "Table"+tabNum+".dbf")

Thanks Matthew, that gets me over the hump.

Michael