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

feature request: Can you add a slicer when worksheet.add_table API #918

Open
epver opened this issue Nov 11, 2022 · 1 comment
Open

feature request: Can you add a slicer when worksheet.add_table API #918

epver opened this issue Nov 11, 2022 · 1 comment
Assignees
Labels
feature request someday May eventually be added.

Comments

@epver
Copy link

epver commented Nov 11, 2022

Feature Request

image

options = {
    "data": data,
    "slicer": [
        {"column": "Column1", "location": "A1"},
        {"column": "Column2", "location": "C1"},
    ]
}

or 

options = {
    'data': data,
    'columns': [
        {'header': 'Product', 'slicer': 'A1'},
        {'header': 'Quarter 1'},
        {'header': 'Quarter 2'},
        {'header': 'Quarter 3'},
        {'header': 'Quarter 4'},
    ]
}
worksheet.add_table('B3:F7', {options})

In this way, you can initially realize the function of the pivot table.

At present, I think the method is to rewrite the Workbook, Worksheet for simple implementation, but I don't know how to add slicer1.xml file

image

@epver epver changed the title feature request: Can you add a slicer when "worksheet.add_table" API feature request: Can you add a slicer when worksheet.add_table API Nov 12, 2022
@jmcnamara jmcnamara self-assigned this Nov 17, 2022
@jmcnamara
Copy link
Owner

I'll look into it since Slicers are a really nice feature. However, it won't happen in the short term.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature request someday May eventually be added.
Projects
None yet
Development

No branches or pull requests

2 participants