Re:xlskubectl – a spreadsheet to control your Kubernetes clu...
by anner_ on Thursday March 13, 2025 @02:32AM
(#43350830)
Is this feature what you're looking for?
https://support.microsoft.com/en-us/office/display-the-relat...
Re:xlskubectl – a spreadsheet to control your Kubernetes clu...
by philips on Thursday March 13, 2025 @02:42PM
(#43356114)
Today I learned.
Here is the doc for Google sheets: https://support.google.com/docs/answer/63175?hl=en&co=GENIE....
Re:xlskubectl – a spreadsheet to control your Kubernetes clu...
by rickdeckard on Thursday March 13, 2025 @10:28AM
(#43353741)
> I wish someone also solved the issue with excel around refactoring though - esp when cells are being used in formulas, if there was a "Find All References" or Cmd+SHIFT+F (global find) of elements used in formula (not their values) - it would step it up even more towards maintainability.
I usually handle this in MS Excel by searching "in workbook" and "in formulas". Works even better when the elements are in a named cell which is referenced in formulas (i.e. "stat.infra.APIrequests" instead of "$A$5"), this way you can also globally change the element by reassigning the cell-name to another cell
It's quite versatile. I had never considered this angle of using it to manage and sync with something external like Kubernetes here and love it.
I wish someone also solved the issue with excel around refactoring though - esp when cells are being used in formulas, if there was a "Find All References" or Cmd+SHIFT+F (global find) of elements used in formula (not their values) - it would step it up even more towards maintainability.
(I understand it buckles under huge datasets, but I believe that's really over-use of the tool)