Missed Team ’24? Catch up on announcements here.

×
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Excel Format unsupported

vrindha_sharma
vrindha_sharma
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
April 29, 2020

Hi,

When i export issues logged in jira into excel file and open that downloaded excel, a warning pops up states that:

The file format and extension of 'filename.xls' don't match. The file could be corrupted or unsafe.

I was trying to read the downloaded excel file from a python script but because of mismatch of file format and extension, I could not open it. 

Error while opening file through script: xlrd.biffh.XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'<html xm'

Answer
Watch
Like Be the first to like this
825 views

1 answer

0 votes
Gonchik Tsymzhitov
Gonchik Tsymzhitov
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
February 11, 2021

Hi! 

Please, use the pandas and export as xls

View More Comments
Francois Regnoult
Francois Regnoult
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
November 9, 2022

Pandas uses xlrd or another engine to open the file so that won't change anything: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html

 

The issue is https://jira.atlassian.com/browse/JRASERVER-60667

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events