Error when writing header column in xlsxwriter
1
I am trying to write the column names to the first row of an excel sheet using xlsxwriter module.
The below code prints out the column names of my SQL:
title = [i[0] for i in dwh_cursor.description]
print(title)
To write this to the excel sheet I am trying the below:
current_row = 0
for data in title:
worksheet1.write(current_row, data)
Get the below error:
TypeError: write() takes at least 4 arguments (3 given)
python xlsxwriter
asked Nov 21 '18 at 19:43
dark horsedark horse
14310
add a comment |
1
I am trying to write the column names to the first row of an excel sheet using xlsxwriter module.
The below code prints out the column names of my SQL:
title = [i[0] for i in dwh_cursor.description]
print(title)
To write this to the excel sheet I am trying the below:
current_row = 0
for data in title:
worksheet1.write(current_row, data)
Get the below error:
TypeError: write() takes at least 4 arguments (3 given)
python xlsxwriter
asked Nov 21 '18 at 19:43
dark horsedark horse
14310
Based on the docs for the XlsxWriter Worksheet this should "just work." Can you show how you set upworksheet1?
– s3cur3
Nov 21 '18 at 19:54
1
@s3cur3: This is only True if you dowrite('A1', *args), but usingrow/colyou have to dowrite(row, col, *args).
– stovfl
Nov 21 '18 at 20:20
Ah, right you are @stovfl!
– s3cur3
Nov 21 '18 at 20:22
add a comment |
1
1
1
I am trying to write the column names to the first row of an excel sheet using xlsxwriter module.
The below code prints out the column names of my SQL:
title = [i[0] for i in dwh_cursor.description]
print(title)
To write this to the excel sheet I am trying the below:
current_row = 0
for data in title:
worksheet1.write(current_row, data)
Get the below error:
TypeError: write() takes at least 4 arguments (3 given)
python xlsxwriter
asked Nov 21 '18 at 19:43
dark horsedark horse
14310
I am trying to write the column names to the first row of an excel sheet using xlsxwriter module.
The below code prints out the column names of my SQL:
title = [i[0] for i in dwh_cursor.description]
print(title)
To write this to the excel sheet I am trying the below:
current_row = 0
for data in title:
worksheet1.write(current_row, data)
Get the below error:
TypeError: write() takes at least 4 arguments (3 given)
python xlsxwriter
python xlsxwriter
asked Nov 21 '18 at 19:43
dark horsedark horse
14310
asked Nov 21 '18 at 19:43
dark horsedark horse
14310
asked Nov 21 '18 at 19:43
dark horsedark horse
14310
asked Nov 21 '18 at 19:43
dark horsedark horse
14310
asked Nov 21 '18 at 19:43
dark horsedark horse
14310
14310
Based on the docs for the XlsxWriter Worksheet this should "just work." Can you show how you set upworksheet1?
– s3cur3
Nov 21 '18 at 19:54
1
@s3cur3: This is only True if you dowrite('A1', *args), but usingrow/colyou have to dowrite(row, col, *args).
– stovfl
Nov 21 '18 at 20:20
Ah, right you are @stovfl!
– s3cur3
Nov 21 '18 at 20:22
add a comment |
Based on the docs for the XlsxWriter Worksheet this should "just work." Can you show how you set upworksheet1?
– s3cur3
Nov 21 '18 at 19:54
1
@s3cur3: This is only True if you dowrite('A1', *args), but usingrow/colyou have to dowrite(row, col, *args).
– stovfl
Nov 21 '18 at 20:20
Ah, right you are @stovfl!
– s3cur3
Nov 21 '18 at 20:22
Based on the docs for the XlsxWriter Worksheet this should "just work." Can you show how you set up
worksheet1?– s3cur3
Nov 21 '18 at 19:54
Based on the docs for the XlsxWriter Worksheet this should "just work." Can you show how you set up
worksheet1?– s3cur3
Nov 21 '18 at 19:54
1
1
@s3cur3: This is only True if you do
write('A1', *args), but using row/col you have to do write(row, col, *args).– stovfl
Nov 21 '18 at 20:20
@s3cur3: This is only True if you do
write('A1', *args), but using row/col you have to do write(row, col, *args).– stovfl
Nov 21 '18 at 20:20
Ah, right you are @stovfl!
– s3cur3
Nov 21 '18 at 20:22
Ah, right you are @stovfl!
– s3cur3
Nov 21 '18 at 20:22
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
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%2f53419462%2ferror-when-writing-header-column-in-xlsxwriter%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
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%2f53419462%2ferror-when-writing-header-column-in-xlsxwriter%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
Based on the docs for the XlsxWriter Worksheet this should "just work." Can you show how you set up
worksheet1?– s3cur3
Nov 21 '18 at 19:54
1
@s3cur3: This is only True if you do
write('A1', *args), but usingrow/colyou have to dowrite(row, col, *args).– stovfl
Nov 21 '18 at 20:20
Ah, right you are @stovfl!
– s3cur3
Nov 21 '18 at 20:22