Python将xls转换成xlsx 100
公司以前同事写的代码,可以把csv的转换成xlsx格式,现在我想在原有基础上改一下,可以将xls格式的转换成xlsx格式,有大神可以帮忙吗?谢谢。importpandas...
公司以前同事写的代码,可以把csv的转换成xlsx格式,现在我想在原有基础上改一下,可以将xls格式的转换成xlsx格式,有大神可以帮忙吗?谢谢。
import pandas as pd
a=pd.read_csv('My Product for epop-product-advancetraining.csv',header=0, encoding='utf-8')
b=pd.read_csv('My Product for epop-product-apptraining.csv',header=0, encoding='utf-8')
c=pd.read_csv('My Product for epop-productbasic-configuration.csv',header=0, encoding='utf-8')
d=pd.read_csv('My Product for epop-productbasic-master.csv',header=0, encoding='utf-8')
e=pd.read_csv('My Product for epop-productbasic-masterinfo.csv',header=0, encoding='utf-8')
f=pd.read_csv('My Product for epop-product-gebundles.csv',header=0, encoding='utf-8')
g=pd.read_csv('My Product for epop-product-pos.csv',header=0, encoding='utf-8')
h=pd.read_csv('My Product for epop-product-trainingbundles.csv',header=0, encoding='utf-8')
i=pd.read_csv('My Product for epop-product-vendorbundles.csv',header=0, encoding='utf-8')
a.to_excel('My Product for epop-product-advancetraining.xlsx',index = False,encoding='utf-8')
b.to_excel('My Product for epop-product-apptraining.xlsx',index = False,encoding='utf-8')
c.to_excel('My Product for epop-productbasic-configuration.xlsx',index = False,encoding='utf-8')
d.to_excel('My Product for epop-productbasic-master.xlsx',index = False, encoding='utf-8')
e.to_excel('My Product for epop-productbasic-masterinfo.xlsx',index = False,encoding='utf-8')
f.to_excel('My Product for epop-product-gebundles.xlsx',index = False,encoding='utf-8')
g.to_excel('My Product for epop-product-pos.xlsx',index = False, encoding='utf-8')
h.to_excel('My Product for epop-product-trainingbundles.xlsx',index = False,encoding='utf-8')
i.to_excel('My Product for epop-product-vendorbundles.xlsx',index = False,encoding='utf-8')
我的Python版本是2.7.3,由于之前代码都是基于这个版本的,麻烦大家帮忙给的代码可以在这个版本上执行,谢谢。 展开
import pandas as pd
a=pd.read_csv('My Product for epop-product-advancetraining.csv',header=0, encoding='utf-8')
b=pd.read_csv('My Product for epop-product-apptraining.csv',header=0, encoding='utf-8')
c=pd.read_csv('My Product for epop-productbasic-configuration.csv',header=0, encoding='utf-8')
d=pd.read_csv('My Product for epop-productbasic-master.csv',header=0, encoding='utf-8')
e=pd.read_csv('My Product for epop-productbasic-masterinfo.csv',header=0, encoding='utf-8')
f=pd.read_csv('My Product for epop-product-gebundles.csv',header=0, encoding='utf-8')
g=pd.read_csv('My Product for epop-product-pos.csv',header=0, encoding='utf-8')
h=pd.read_csv('My Product for epop-product-trainingbundles.csv',header=0, encoding='utf-8')
i=pd.read_csv('My Product for epop-product-vendorbundles.csv',header=0, encoding='utf-8')
a.to_excel('My Product for epop-product-advancetraining.xlsx',index = False,encoding='utf-8')
b.to_excel('My Product for epop-product-apptraining.xlsx',index = False,encoding='utf-8')
c.to_excel('My Product for epop-productbasic-configuration.xlsx',index = False,encoding='utf-8')
d.to_excel('My Product for epop-productbasic-master.xlsx',index = False, encoding='utf-8')
e.to_excel('My Product for epop-productbasic-masterinfo.xlsx',index = False,encoding='utf-8')
f.to_excel('My Product for epop-product-gebundles.xlsx',index = False,encoding='utf-8')
g.to_excel('My Product for epop-product-pos.xlsx',index = False, encoding='utf-8')
h.to_excel('My Product for epop-product-trainingbundles.xlsx',index = False,encoding='utf-8')
i.to_excel('My Product for epop-product-vendorbundles.xlsx',index = False,encoding='utf-8')
我的Python版本是2.7.3,由于之前代码都是基于这个版本的,麻烦大家帮忙给的代码可以在这个版本上执行,谢谢。 展开
3个回答
展开全部
首先需要安装Python,我这里安装的是Python3.6.4(注意:Python3和2版本语法有改动)
到 官网 进行下载安装。
选择对应版本的安装包即可,因为我这台电脑是Win10 64位,所以选择Windows x86-64 executable installer。
安装pywin32
pywin32貌似不能通过pip3 install下载,不过可以在sourceforge中找到 下载地址
在其中选择对应版本的安装包即可,我的python版本(通过命令行下执行python --version查看)是3.6.4,所以我选择下载pywin32-221.win-amd64-py3.6.exe。
下载下来后执行安装。
代码
安装好了Python3和Pywin32之后,我们便可以在代码中调用win32com.client了。
下面的代码用于演示将一个xls格式文件另存为xlsx格式。
import win32com.client as win32
2018-11-04 · 百度知道官方认证企业
腾讯电脑管家
腾讯电脑管家是腾讯公司推出的免费安全管理软件,能有效预防和解决计算机上常见的安全风险,并帮助用户解决各种电脑“疑难杂症”、优化系统和网络环境,是中国综合能力最强、最稳定的安全软件。
向TA提问
关注
展开全部
import win32com.client as win32
fname = "C:\\myProjects\\daily\\data\\20171229\\标准化文档-20171226\\全量数据过滤表清单.xls"excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Open(fname)
wb.SaveAs(fname+"x", FileFormat = 51) #FileFormat = 51 is for .xlsx extensionwb.Close() #FileFormat = 56 is for .xls extensionexcel.Application.Quit()
fname = "C:\\myProjects\\daily\\data\\20171229\\标准化文档-20171226\\全量数据过滤表清单.xls"excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Open(fname)
wb.SaveAs(fname+"x", FileFormat = 51) #FileFormat = 51 is for .xlsx extensionwb.Close() #FileFormat = 56 is for .xls extensionexcel.Application.Quit()
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询