python


python: converting corrupt xls file


I have downloaded few sales dataset from a SAP application. SAP has automatically converted the data to .XLS file. Whenever I open it using Pandas library I am getting the following error:
XLRDError: Unsupported format, or corrupt file: Expected BOF record; found '\xff\xfe\r\x00\n\x00\r\x00'
When I opened the .XLS file using MSEXCEL it is shows a popup saying that the file is corrupt or unsupported extension do you want to continue when I clicked 'Yes' its showing the correct data. When I saved the file again as .xls using msexcel I am able to use it using Pandas.
So, I tried renaming the file using os.rename() but it dint work. I tried opening the file and removing \xff\xfe\r\x00\n\x00\r\x00, but then also it dint work.
The solution is to open MSEXCEL and save the file again as .xls manually, is there any way to automate this. Kindly help.

Related Links

Transform string in integer
Py2neo: Match relationship
2sum performance improvement
how to store yield request responses on scrapy
python sklearn non linear svm penalty
builtins.TypeError: __init__() missing 2 required positional arguments: 'height' and 'radius'
How to do a reverse operation to tf.nn.embedding_lookup?
django complex query for interdependant tables
Is there a more efficient and elegant way to filter pandas index by date?
How do I temporarily use Python 3.6 in terminal Mac?
Difference between pre-trained word embedding and training word embedding in keras
AttributeError: module 'xlwings' has no attribute 'save'
Images broadcast over UDP socket (Python)
Index class as list and as dictionary
Python “will the arrow fly straight program”
Processing an eventlog with Pandas - find next match in DataFrame

Categories

HOME
drupal-7
translation
parse-server
safari
appmaker
snap.svg
user
actionscript-2
constructor
vuex
lotus-notes
cakephp-2.9
cpanel
symfony-forms
store
scala-native
phpbb
pycrypto
cvs2svn
embedly
tampermonkey
data-cleansing
kong
ggmap
data-conversion
winscp
ivy
jackson-dataformat-csv
piecewise
strophe
smart-mobile-studio
receipt
css-counter
sidr
openshift-enterprise
mmdrawercontroller
vmd
installshield-2012
s3cmd
flex4.5
wcf-security
floating-accuracy
socketscan
viewgroup
powermta
fastq
proof
goquery
pluck
mbaas
jexl
modelattribute
in-memory-database
python-hypothesis
jcreator
visual-studio-templates
adler32
xib
rstudio-server
children
soda
gradle-release-plugin
mpeg-4
asp.net-mvc-partialview
twgl.js
android-recyclerview
persistence.xml
windows-vista
rad
ipojo
castle-windsor-3
manjaro
hiera
word-2013
hana-xs
client-side-validation
tilestache
cpu-speed
collabnet
libssh2
system.web
valence
funkload
map-force
zipalign
internal
facebook-sdk-3.1
installshield-2011
vertical-rhythm
nimrod
execvp
va-list
client-library
vt100
sequelpro
pitch
scrollto
continuous-testing
macruby
point-sprites
cross-domain-policy
shared-objects
coff
galaxy-tab
collect
squeel
loadui
pantheios
recordset
sitemappath
surefire
aio
visual-c++-2008-express

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html