# -*- coding: gbk -*-
import codecs
import json

import xlrd
import datetime
import csv
import sys
reload(sys)
sys.setdefaultencoding('gbk')
print sys.getdefaultencoding()
def xlsx_to_csv():
    filename='E:\workspaces\test測試.xlsx'
    workbook = xlrd.open_workbook(filename)
    
    # with codecs.open('fcc.csv', 'w', encoding='utf-8') as f:
    #     write = csv.writer(f)
    #     for row_num in range(table.nrows):
    #         row_value = table.row_values(row_num)
    #         write.writerow(row_value)
    sheet_names=workbook.sheet_names()
    for i in range(len(sheet_names)):
        table = workbook.sheet_by_index(i)
        for row_num in range(0,table.nrows):
            row_value = table.row_values(row_num)
            # print row_value
            print sheet_names[i],",",json.dumps(row_value, ensure_ascii=False, encoding='utf-8')
        # print str(row_value).encode('GB2312')  .decode('unicode_escape')
if __name__ == '__main__':
    xlsx_to_csv()

@echo off
for /f "delims=" %%i in ('D:\python\Python27\python.exe "E:\workspaces\xlsx_to_csv.py"') do echo %%i