ramstk icon indicating copy to clipboard operation
ramstk copied to clipboard

Migrate from openpyxl to pyexcel for imports/exports

Open weibullguy opened this issue 3 years ago • 1 comments

Describe the chore that needs to be addressed. Change from the openpyxl to the pyexcel library for import/export. The pyexcel library provides more file format options by default and has plugins for the *.ods format.

dobranch priority: low type: refactor

  • [ ] This issue subsumes the following issues:

weibullguy avatar Jun 11 '22 16:06 weibullguy

Will also eliminate the pandas "FutureWarning: As the xlwt package is no longer maintained, the xlwt engine will be removed in a future version of pandas. This is the only engine in pandas that supports writing in the xls format. Install openpyxl and write to an xlsx file instead. You can set the option io.excel.xls.writer to 'xlwt' to silence this warning. While this option is deprecated and will also raise a warning, it can be globally set and the warning suppressed."

weibullguy avatar Jun 12 '22 14:06 weibullguy