how to convert xls to xlsx

by

You need to have win32com installed on your machine. Here is my code:

import win32com.client as win32
fname = "full+path+to+xls_file"
excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Open(fname)

wb.SaveAs(fname+"x", FileFormat = 51)    #FileFormat = 51 is for .xlsx extension
wb.Close()                               #FileFormat = 56 is for .xls extension
excel.Application.Quit()

More Related Contents:

  1. difference between arrays in numpy
  2. How do I open a new txt file using path
  3. How do I sort a dictionary by value?
  4. How to start a background process in Python?
  5. Generate random numbers summing to a predefined value
  6. Given a URL to a text file, what is the simplest way to read the contents of the text file?
  7. Parameter substitution for a SQLite “IN” clause
  8. How to print one character at a time on one line?
  9. Time complexity of string slice
  10. PIL thumbnail is rotating my image?
  11. ValueError: Wrong number of items passed – Meaning and suggestions?
  12. How can I listen for ‘usb device inserted’ events in Linux, in Python?
  13. How to get path of an element in lxml?
  14. Only download a part of the document using python requests
  15. Streaming large training and test files into Tensorflow’s DNNClassifier
  16. Why is Collections.counter so slow?
  17. How to repeatedly execute a function every x seconds?
  18. What does nonlocal do in Python 3?
  19. Why does math.log result in ValueError: math domain error?
  20. How to convert hexadecimal string to bytes in Python?
  21. Circular Reference with python lists
  22. How to replace a double backslash with a single backslash in python? [duplicate]
  23. How to center labels in histogram plot
  24. Possible to change a function’s repr in python?
  25. Send keys not working selenium webdriver python
  26. scikit-learn .predict() default threshold
  27. imshow doesn’t need convert from BGR to RGB
  28. deque.popleft() and list.pop(0). Is there performance difference?
  29. Round to nearest 0.05 using Python
  30. Pandas min() of selected row and columns

Leave a Comment