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.

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

Ability to Set the table name in AddTable #216

Closed
jjmartin opened this issue May 3, 2018 · 2 comments
Closed

Ability to Set the table name in AddTable #216

jjmartin opened this issue May 3, 2018 · 2 comments
Labels
enhancement New feature or request

Comments

@jjmartin
Copy link

jjmartin commented May 3, 2018

I have an excel template that I am manipulating and I have pivot tables referring to a named table,
If I add table to the sheet where an existing table is, then the data may expand beyond the length of the existing table and the pivot tables miss it.

the next bet i have is to add a table to the data I am adding, but I don't have the ability to set the name of the table and so the pivot tables lose the reference.

Basically i just want to be able to send in a parameter to this line here instead of it being auto-created:
https://github.com/360EntSecGroup-Skylar/excelize/blob/master/table.go#L125

@xuri xuri added the enhancement New feature or request label May 4, 2018
xuri added a commit that referenced this issue May 4, 2018
- godoc and go test has been updated
@xuri
Copy link
Member

xuri commented May 4, 2018

Thanks for your issue. I have added the set name of table support for AddTable(). We can set the name of the table by table_name parameter.

@jjmartin
Copy link
Author

jjmartin commented May 4, 2018

thanks so much for jumping on this - it does exactly what i asked for but unfortunately doesn't solve my problem, creating the new table doesn't seem to keep the link to the pivot tables in the document.

Would be nice to be able to alter the range of an existing table maybe. Some of this excel internal linking seems like magic.

@jjmartin jjmartin closed this as completed May 4, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants