使用shell脚本或jython将Excel转换为csv.如果可以的话 [英] convert Excel to csv either using shell script or jython . if so how
问题描述
我正在寻找一个程序,如果有一些shell脚本,我可以将excel转换为csv,如果可以的话,请指导我或者如果可能的话,我如何在jython中进行操作.
I am looking for a procedure where i can convert the excel to csv either if there some shell script , if so please guide me or if possbile how can i do in jython.
主要原因是从其他来源接收到excel,并且标头始终在变化,这是不必要的,我们需要有一些自动的方法来删除它.如果可以的话,可以使用jython或shell脚本轻松地做到这一点,并仅删除excel的第一行
The main reason is that the excel is being received from other source and the header is always changing , which is unnecessary and we need to have some automatic way to remove that . If is it possible to do that easily using jython or shell script and remove only the first line of the excel
先谢谢了.
推荐答案
要在各种文件格式之间进行转换,我使用: PyODConverter .有Python和Java版本.
To convert between various file formats I use: PyODConverter. There is Python and Java version.
它使用OpenOffice作为服务,并且可以在各种文档格式之间进行转换,包括MS Office,PDF和文本.
It uses OpenOffice working as a service and can convert between various document formats including MS Office, PDF and text.
还有一个纯Python库: xlrd 供开发人员从中提取数据的库Microsoft Excel(tm)电子表格文件
There is also pure Python library: xlrd Library for developers to extract data from Microsoft Excel (tm) spreadsheet files
这篇关于使用shell脚本或jython将Excel转换为csv.如果可以的话的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!