search

ycphs / openxlsx

openxlsx - a fast way to read and write complex xslx files
https://ycphs.github.io/openxlsx/
Other
220 stars 73 forks source link

select row/column on demand [has inital code] #426

Closed tobwen closed 2 months ago

tobwen commented 1 year ago

Is your feature request related to a problem? Please describe. I'm always frustrated when A1 is selected when opening XLSX files having a header or filter in the first row.

Describe the solution you'd like I want the topLeftCell to be the first data cell (e.g. TopLeft = A2 when there's a header in first row).

Describe alternatives you've considered I wrote this code and it does when I want. I didn't create a PR, since I wanted to talk about this first aaaand came to another idea. https://github.com/tobwen/openxlsx/tree/feature/select-topLeftCell

Additional context After finishing the code, I was fallen asleep. When I woke up, I came to the idea that it might be better to implement a generic function to set the selected freely. So it won't depend on frozen cells, but could be set whenever, wherever.

Maybe something like this?

setActiveCell(wb, sheet, row, column)
setSelectionToCell(wb, sheet, row, column)
selectCell(wb, sheet, row, column)
github-actions[bot] commented 2 months ago

This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.

github-actions[bot] commented 2 months ago

This issue was closed because it has been stalled for 7 days with no activity.