search

cathei / BakingSheet

Easy datasheet management for C# and Unity. Supports Excel, Google Sheet, JSON and CSV format.
MIT License
346 stars 34 forks source link

Transpose Sheet Row and Column on import #37

Open mgmhunt opened 7 months ago

mgmhunt commented 7 months ago

I have a large list of settings (with variations for different builds) I'm importing from a Google Sheet but at the moment I don't see an easy way of transposing the data at the BakingSheet end so that the 'rows' of data are laid out horizontally and the 'columns' are on the left hand side, vertically.

I think a property in the Sheet definition would be required ie bool importTransposed = true

And then maybe just adding a toggle in the GetCell to reverse the SheetConverter - thing is that currently doesn't have access to the Sheet definition. Also the record/row count would be wrong as the last empty column should be used rather than the row.

Anyway - a feature suggestion as it came to mind really.

Currently possible to transpose in the Google Sheet using reference formula cells in the Google Sheet, hide the Import Sheet and only work on the referenced sheet - so it's not vital or anything. Or manually before import etc.

laicasaane commented 6 months ago

It would be nice to have this feature. Horizontal layout is not good for the settings which usually only needs 1 row of data but multiple columns.