search

asteng88 / PyPredict

This is a tool used for statistical analysis of data in MS Excel files using either Linear Regression or the ARIMA model. It can produce a graph of the results and a pdf report of the analysis and the graph.
Other
0 stars 0 forks source link

throws Error when `.xls` file provided #4

Closed pr4j3sh closed 1 month ago

pr4j3sh commented 1 month ago

I tried providing .xls file and the program throws error that the file provided is not a zip file. However, it works fine for .xlsx files.

screenshots

ss-20241001-172751Z-current ss-20241001-172757Z-current

deduction

the error occurs as openpyxl cannot handle .xls files.

suggestion

adding a conversion method for .xls files to be converted into .xlsx files.

asteng88 commented 1 month ago

@prajeshElEvEn I'll take this one and get it fixed. Thanks for the heads up with the .xls extension.

asteng88 commented 1 month ago

Added conversion through using xlrd library to convert xls to xlsx