search

uga-libraries / format-report

Aggregate and analyze csv files with file format information generated by the UGA Libraries' digital preservation system (ARCHive).
Creative Commons Attribution Share Alike 4.0 International
0 stars 0 forks source link

Improve Excel formatting #24

Open amhanson9 opened 1 year ago

amhanson9 commented 1 year ago

Formatting by ExcelWriter isn't great. Would like to do more with bolding, justification, outlines, etc. to make it easier to read. Briefly tried xlsxwriter but could not find examples that reformat the index or header, which is what I most want to change.

amhanson9 commented 6 months ago

2023, I manually expanded column widths for all sheets, left justified all columns, and froze the top column. I would also want to make changes about what is bold and has a cell outline.