3 ms·
How do you do version control with code embedded into spreadsheets? Am I not better off making code that generates a spreadsheet (or CSV or whatever formats I c
by Waterluvian 8y ago
How do you do version control with code embedded into spreadsheets? Am I not better off making code that generates a spreadsheet (or CSV or whatever formats I care about)?
- wolco 8y agoCopy and paste the file to a new folder.
- EForEndeavour 8y agoCopy of 2019Q1-finance-report-3__fixed)_Jon edits - bugfix (2).xls.xlsx
- projektfu 8y agoIt’s been a long time since I looked into it but I remember a version of Office like 20 years ago that integrated with version control. I wonder if that’s still a thing.
- sheetjs 8y agoIt's not as pleasant as working with plaintext, but Spreadsheet Compare is a nifty tool for diffing workbooks: https://support.office.com/en-us/article/Basic-tasks-in-Spreadsheet-Compare-F2B20AF8-A6D3-4780-8011-F15B3229F5D8 https://support.office.com/en-us/article/Basic-tasks-in-Spre...
- aargh_aargh 8y agoExcel has this built in in the later versions (since 2013, I think)
- squidi 8y agoIt's possible to export the code to text files. MZ-Tools [1] can do it, or use VBA directly [2]. Xtrail [3] is popular in Finance companies but I haven't used it personally [1] https://www.mztools.com/ https://www.mztools.com/ [2] https://www.rondebruin.nl/win/s9/win002.htm https://www.rondebruin.nl/win/s9/win002.htm [3] https://www.xltrail.com/ https://www.xltrail.com/