qrilka / xlsx

Simple and incomplete Excel file parser/writer
MIT License
128 stars 62 forks source link

Add integration test that checks correctness with xlsx validator #149

Open jappeace opened 2 years ago

jappeace commented 2 years ago

My comment at verbatim:

To validate the result is correct xml:                                                                     

@                                                                                                          
docker run -v $(pwd):/app/xlsx-validator/xlsx -it vindvaki/xlsx-validator xlsx-validator xlsx/yourfile.xlsx
@                                                                                                          

TODO: package that program for nix and make a unit test out of it.                                         
it's *really* usefull.                                                                                     

This will put the xlsx project root in the current working                                                 
directory of xlsx validator,                                                                               
allowing you to run that program on the output from                                                        
streaming (which in this example was written to out/out.xlsx).                                             
This gives a much more descriptive error reporting than excel.            

It's this program: https://github.com/vindvaki/xlsx-validator