Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

How to adjust the order of sheets？ #1076

Closed
iseejustdoit opened this issue Nov 29, 2021 · 4 comments
Closed

How to adjust the order of sheets？ #1076

iseejustdoit opened this issue Nov 29, 2021 · 4 comments

Comments

@iseejustdoit
Copy link

Adjust Sheet2 before Sheet1
@xuri
Copy link
Member

xuri commented Dec 9, 2021

Thanks for your issue, this library not support to adjust the order of sheets directly, you can rename sheet with SetSheetName, note that it won't be update the sheet name in the formula or reference associated with the cell. So there may be problem formula error or reference missing.

@xuri xuri mentioned this issue Dec 26, 2021
Closed
@xuri xuri mentioned this issue Aug 31, 2023
Closed
Zncl2222 added a commit to Zncl2222/excelize that referenced this issue Sep 24, 2024
@Zncl2222
Add MoveSheet and SwapSheets functions to support changing sheet orde…
239697b 
…r in the workbook (qax-os#1076)

- Add MoveSheet and SwapSheets functions to change sheet order in the workbook
- Add unit tests for MoveSheet and SwapSheets functions
@Zncl2222 Zncl2222 mentioned this issue Sep 24, 2024
Merged
10 tasks
Zncl2222 added a commit to Zncl2222/excelize that referenced this issue Sep 24, 2024
@Zncl2222
Add MoveSheet and SwapSheets functions to support changing sheet orde…
8f98bb3 
…r in the workbook (qax-os#1076)

- Add MoveSheet and SwapSheets functions to change sheet order in the workbook
- Add unit tests for MoveSheet and SwapSheets functions
Zncl2222 added a commit to Zncl2222/excelize that referenced this issue Sep 24, 2024
@Zncl2222
Add more test cases to test MoveSheet (qax-os#1076)
6b54994 
1. Add failing scenarios where sourceIdx is provided with invalid values
@xuri xuri closed this as completed in b23e5a2 Sep 30, 2024
@xuri xuri moved this to Features in Excelize v2.9.0 Sep 30, 2024
@xuri
Copy link
Member

xuri commented Oct 1, 2024

New function MoveSheet has been added, this function will be available on the next released version.

@RichardHill
Copy link

Is there a date for a new release? @xuri

@xuri
Copy link
Member

xuri commented Nov 15, 2024

Hi @RichardHill, the MoveSheet function already released in the version 2.9.0. Please upgrade to the lasted version.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
No open projects
Excelize v2.9.0
Status: Features
Milestone
No milestone
Development

No branches or pull requests
3 participants
@RichardHill @xuri @iseejustdoit