SQL Server Import/Export to Excel by executing Python script within T-SQL

Hi: 

Firstly, I found the article interesting and helpful. Thanks!! 

I'm trying to enhance the code so that usecols can be used. Idea is to pass a string, ie: A:BE . The string is saved in a SQL Server database column Range varchar(25) = A:BE

In ML Services external script I set ---> range = str("\"")+str(row["Range"])+str("\"")
so that I get the double quotes wrapping the content.

When I print(range) I get "A:BE" which is the expected result.

When I run pd.read_excel(InFolder+ExcelFileName, sheetname=sheetname, skiprows=skiprow, header=headerrow, usecols=range)

I get error message:


Msg 39019, Level 16, State 2, Line 16
An external script error occurred: 
    self._make_engine(self.engine)
  File "D:\MSSQL\DEFAULT\MSSQL14.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\io\parsers.py", line 929, in _make_engine
    self._engine = klass(self.f, **self.options)
  File "D:\MSSQL\DEFAULT\MSSQL14.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\io\parsers.py", line 1820, in __init__
    self.columns, self.num_original_columns = self._infer_columns()
  File "D:\MSSQL\DEFAULT\MSSQL14.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\io\parsers.py", line 2183, in _infer_columns
    columns = self._handle_usecols(columns, columns[0])
  File "D:\MSSQL\DEFAULT\MSSQL14.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\io\parsers.py", line 2236, in _handle_usecols
    col_indices.append(usecols_key.index(u))
ValueError: 'A' is not in list

SqlSatelliteCall error: Error in execution.  Check the output for more information.

Any ideas as of why is it failing?

Kindest Regards,

Martin