#!/usr/bin/python

# this script requires libraries
# pandas, xlrd, xlwt, xlsxwriter

import sys
import os.path
import pandas as pd
from pandas import ExcelWriter

if len(sys.argv) < 2:
    print "Not enough input arguments. PLease put the path to file as an argument."
    exit()

file = sys.argv[1]

if os.path.isfile(file):
    try:
        xl = pd.ExcelFile(file)
        sheet_names = xl.sheet_names
        writer = pd.ExcelWriter(file, engine='xlsxwriter')

        d = {}
        for i in range (0, len(sheet_names)):
            current_sheet_name = sheet_names[i]
            d[current_sheet_name] = pd.read_excel(file, sheet_name = i, keep_default_na=False)
            d[current_sheet_name].to_excel(writer, '%s' % (current_sheet_name), index=False)

        writer.save()
    except Exception:
        print "Error: can't process file:" , file
    else:
        print "Success."
else:
    print "Error: file file doesn't exist."