Pyexcel不合并xls文件

Question

我正在尝试将多个.xls文件合并到一个工作簿中，每个文件都插入到一个以.xls文件名命名的工作表中。你知道吗

在网上冲浪的时候，我看到了Pyexcel的文档和一个特定的模块，就像这里写的那样，可以轻松地完成这项工作。 这是密码。你知道吗

from pyexcel.cookbook import merge_all_to_a_book
import glob 
merge_all_to_a_book(glob.glob("Dir\*.xls"),"output.xls")

正如所料，它不起作用。这是控制台输出。你知道吗

File "..\Desktop\scripts\provaimport.py", line 48, in <module>


merge_all_to_a_book(glob.glob("C:\Users\Tesisti\Desktop\forpythonscript\*.xls"),"output.xls")
  File "C:\Users\Tesisti\Anaconda2\lib\site-packages\pyexcel\cookbook.py", line 148, in merge_all_to_a_book
    merged.save_as(outfilename)
  File "C:\Users\Tesisti\Anaconda2\lib\site-packages\pyexcel\internal\meta.py", line 339, in save_as
    return save_book(self, file_name=filename, **keywords)
  File "C:\Users\Tesisti\Anaconda2\lib\site-packages\pyexcel\internal\core.py", line 51, in save_book
    return _save_any(a_source, book)
  File "C:\Users\Tesisti\Anaconda2\lib\site-packages\pyexcel\internal\core.py", line 55, in _save_any
    a_source.write_data(instance)
  File "C:\Users\Tesisti\Anaconda2\lib\site-packages\pyexcel\plugins\sources\file_output.py", line 38, in write_data
    **self._keywords)
  File "C:\Users\Tesisti\Anaconda2\lib\site-packages\pyexcel\plugins\renderers\excel.py", line 30, in render_book_to_file
    save_data(file_name, book.to_dict(), **keywords)
  File "C:\Users\Tesisti\Anaconda2\lib\site-packages\pyexcel_io\io.py", line 119, in save_data
    **keywords)
  File "C:\Users\Tesisti\Anaconda2\lib\site-packages\pyexcel_io\io.py", line 141, in store_data
    writer.write(data)
  File "C:\Users\Tesisti\Anaconda2\lib\site-packages\pyexcel_io\book.py", line 58, in __exit__
    self.close()
  File "C:\Users\Tesisti\Anaconda2\lib\site-packages\pyexcel_xls\xlsw.py", line 86, in close
    self.work_book.save(self._file_alike_object)
  File "C:\Users\Tesisti\Anaconda2\lib\site-packages\xlwt\Workbook.py", line 710, in save
    doc.save(filename_or_stream, self.get_biff_data())
  File "C:\Users\Tesisti\Anaconda2\lib\site-packages\xlwt\Workbook.py", line 680, in get_biff_data
    self.__worksheets[self.__active_sheet].selected = True

你知道怎么修理吗？你知道吗

Answer 1

在我看来全球。全球（“Dir*.xls”）返回了一个空的文件列表。因此pyexcel的插件pyexcel xlsfails to create an empty file。你知道吗

我建议目前的解决方案是使用最新的pyexcel xls，并使用try-except语句将所有文件合并到一本书中，以捕获空文件大小写。你知道吗