Does xlwings require an excel install

4.8k views Asked by At

Does xlwings require an install of excel?

We are hoping to use it, with an anaconda install, on a windows server, with no EXCEL, to inject some data to a workbook and pass the workbook back to the user.

1

There are 1 answers

3
Felix Zumstein On BEST ANSWER

xlwings is indeed made for interacting with a running instance of Excel and therefore does not run on Linux.

You will want to have a look into the pandas to_excel method or you may even want to use one of the underlying libraries directly that this method uses (XlsxWriter, openpyxl and xlwt).

In short, with pandas you can do:

df.to_excel('output.xlsx', 'Sheet1')