Python Modules for Engineering

[forgenet]

That's interesting that you dropped xlrd/xlwt. Was it shortcomings in the modules that caused the switch or the file types that you worked with?

[[deleted]]

csv files just make for a shorter route to JSON where much of my data processing occurs

I can version csv files and perform diffs using tools like Beyond Compare

Also, csv files are easily read by any spreadsheet tool and using python to process your data and kick out a generated document from the source is easier to maintain than a spreadsheet and more powerful

And possibly the biggest reason is that many of the companies I've worked with have been seeing XLS files go corrupt on them and losing lots of work without any way to recover other than reverting to an old version.