topic Extra underscore behind ".xlsm" and ".xlsx" after exporting excel files from Databricks in Data Engineering

Extra underscore behind ".xlsm" and ".xlsx" after exporting excel files from Databricks

MinMin — Mon, 20 Nov 2023 15:17:55 GMT

Hi all,

I tried to export several excel files from Databricks. But there will always be one extra underscore behind ".xlsm" and ".xlsx", if I export them and try to open the files on local system. I have to manually remove the underscore from the filename and then I am able to open the excel files.

For the solutions, I downloaded different browsers to implement it. It doesn't work either.

I also tried to change the workspace settings. Does anyone know how I can reconfigure the settings to solve the problem?

I will be super grateful if you can provide some hints!

Thanks 🙂

Re: Extra underscore behind ".xlsm" and ".xlsx" after exporting excel files from

MinMin — Mon, 20 Nov 2023 15:31:00 GMT

Re: Extra underscore behind ".xlsm" and ".xlsx" after exporting excel files from

MinMin — Thu, 23 Nov 2023 14:45:57 GMT

Hello @Retired_mod,

Thank you very much for the response 🙂

My team tested the solutions as you mentioned above. But it didn't work 😞

Note: No code is used to download the excel file. We are trying to directly export the file from Databricks workspace (see screenshot).

The problem appears for all users and not just for this one excel file.

As I mentioned it's not just for excel, it's for all types of files I export in this way: .txt or .py etc.

I'm looking forward to your feedbacks!

Re: Extra underscore behind ".xlsm" and ".xlsx" after exporting excel files from

DH_Fable — Thu, 07 Dec 2023 09:26:29 GMT

Hi, did you find a solution this? I have the same/similar problem where when I save a dataframe from a Databricks notebook using to_excel() it saves the file with extension ".xlsx_" rather then "xlsx", meaning to open I have to manually download and change the file type