openpyxl group columns with “Summary Columns to the Right of Detail” unchecked
up vote
-1
down vote
favorite
in Python I want to group a set of columns and have it behave as if the checkbox "Summary Columns to the Right of Detail" in excel under data->outline would be unchecked.
Here is the code I have so far:
wb = openpyxl.Workbook()
ws = wb.create_sheet()
ws = wb.active
ws['A1'] = 1
ws['B1'] = 2
ws['C1'] = 3
ws['D1'] = 4
ws['E1'] = 5
ws.column_dimensions.group('B','E')
I know already how to group columns but can't find a way to give the group the behavior I need.
Have a nice day!
python grouping openpyxl
asked 18 hours ago
TeeDoubleview
12
add a comment |
up vote
-1
down vote
favorite
in Python I want to group a set of columns and have it behave as if the checkbox "Summary Columns to the Right of Detail" in excel under data->outline would be unchecked.
Here is the code I have so far:
wb = openpyxl.Workbook()
ws = wb.create_sheet()
ws = wb.active
ws['A1'] = 1
ws['B1'] = 2
ws['C1'] = 3
ws['D1'] = 4
ws['E1'] = 5
ws.column_dimensions.group('B','E')
I know already how to group columns but can't find a way to give the group the behavior I need.
Have a nice day!
python grouping openpyxl
asked 18 hours ago
TeeDoubleview
12
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
in Python I want to group a set of columns and have it behave as if the checkbox "Summary Columns to the Right of Detail" in excel under data->outline would be unchecked.
Here is the code I have so far:
wb = openpyxl.Workbook()
ws = wb.create_sheet()
ws = wb.active
ws['A1'] = 1
ws['B1'] = 2
ws['C1'] = 3
ws['D1'] = 4
ws['E1'] = 5
ws.column_dimensions.group('B','E')
I know already how to group columns but can't find a way to give the group the behavior I need.
Have a nice day!
python grouping openpyxl
asked 18 hours ago
TeeDoubleview
12
in Python I want to group a set of columns and have it behave as if the checkbox "Summary Columns to the Right of Detail" in excel under data->outline would be unchecked.
Here is the code I have so far:
wb = openpyxl.Workbook()
ws = wb.create_sheet()
ws = wb.active
ws['A1'] = 1
ws['B1'] = 2
ws['C1'] = 3
ws['D1'] = 4
ws['E1'] = 5
ws.column_dimensions.group('B','E')
I know already how to group columns but can't find a way to give the group the behavior I need.
Have a nice day!
python grouping openpyxl
python grouping openpyxl
asked 18 hours ago
TeeDoubleview
12
asked 18 hours ago
TeeDoubleview
12
asked 18 hours ago
TeeDoubleview
12
asked 18 hours ago
TeeDoubleview
12
asked 18 hours ago
TeeDoubleview
12
12
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53371134%2fopenpyxl-group-columns-with-summary-columns-to-the-right-of-detail-unchecked%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
