User: "I have uploaded an excel file"
"but your application says un-supported file format"
Developer: "Did you upload an xlsx file or a csv file?"
User: "Well, I am not sure. I saved the data using "
"Microsoft Excel. Surely, it must be in an excel format."
Developer: "OK. Here is the thing. I were not told to support"
"all available excel formats in day 1. Live with it"
"or delay the project x number of days."
Time To Market
One pip-install command gets you the support for an additional excel format. No code changes required.
It is extremely easy to add a support for your own data format.
Third party libraries(openpyxl, xlrd and xlwt) are pre-configured for optimal data reading and writing.
The idea originated from the common usability problem: when an excel file
driven web application is delivered for non-developer users (ie: team assistant,
human resource administrator etc). The fact is that not everyone knows (or cares) about the
differences between various excel formats: csv, xls, xlsx are all the same to them. Instead of training those users
about file formats, this library helps web developers to handle most of the excel file
formats by providing a common programming interface. To add a specific excel file format type
to you application, all you need is to install an extra pyexcel plugin. Hence no code changes
to your application and no issues with excel file formats any more. Looking at the
community, this library and its associated ones try to become a small and easy to
install alternative to Pandas.
Render database data in handsontable
Visualize poll results
Renderring data in gantt chart
CsvtoTable in Jupyter notebook
Drawing chart using matplotlib
Rendering data in handsontable in html
Drawing chart using pygal
Pyexcel command line tool to view your data without MS Office software