Btukfyl

date_format = workbook.add_format({'num_format': 'dd/mm/yyyy hh:mm:ss', 'font_size': 14})

worksheet1.write('A1', 'Sale_Date', date_format) 

# create an output stream

output = BytesIO()

writer = pd.ExcelWriter(output, engine='xlsxwriter')



# Create the workbook

workbook = writer.book

# Create and name the sheets

worksheet = workbook.add_worksheet('Cover Sheet')

worksheet1 = workbook.add_worksheet('Sample Data')



# Number formatting

number_format = workbook.add_format({'num_format': '####', 'font_size': 14})

date_format = workbook.add_format({'num_format': 'dd/mm/yyyy hh:mm:ss', 'font_size': 14})



for col in field_names:

    worksheet1.write('A1', col, date_format if 'created_at' in col else number_format)



# Defining Cover sheet format

worksheet.set_column('A:BZ', None, color_format)



# # header column

row = 0

col = 0



for data in title:

    worksheet1.write(row, col, data, number_format)

    col += 1



#Pulling monthly data for columns for weekly raw data sheet

current_row = 1



for values in output_file:

    for idx, value in enumerate(values):

        worksheet1.write(current_row, idx, value, number_format)

    current_row += 1



# the writer has done its job

writer.close()



# go back to the beginning of the stream

output.seek(0)



# finally return the file

return output

name, age,class,join_date,date_of_birth,filing_date

date_format = workbook.add_format({'num_format': 'dd/mm/yyyy hh:mm:ss', 'font_size': 14})

worksheet1.write('A1', 'Sale_Date', date_format) 

# create an output stream

output = BytesIO()

writer = pd.ExcelWriter(output, engine='xlsxwriter')



# Create the workbook

workbook = writer.book

# Create and name the sheets

worksheet = workbook.add_worksheet('Cover Sheet')

worksheet1 = workbook.add_worksheet('Sample Data')



# Number formatting

number_format = workbook.add_format({'num_format': '####', 'font_size': 14})

date_format = workbook.add_format({'num_format': 'dd/mm/yyyy hh:mm:ss', 'font_size': 14})



for col in field_names:

    worksheet1.write('A1', col, date_format if 'created_at' in col else number_format)



# Defining Cover sheet format

worksheet.set_column('A:BZ', None, color_format)



# # header column

row = 0

col = 0



for data in title:

    worksheet1.write(row, col, data, number_format)

    col += 1



#Pulling monthly data for columns for weekly raw data sheet

current_row = 1



for values in output_file:

    for idx, value in enumerate(values):

        worksheet1.write(current_row, idx, value, number_format)

    current_row += 1



# the writer has done its job

writer.close()



# go back to the beginning of the stream

output.seek(0)



# finally return the file

return output

name, age,class,join_date,date_of_birth,filing_date

date_format = workbook.add_format({'num_format': 'dd/mm/yyyy hh:mm:ss', 'font_size': 14})

worksheet1.write('A1', 'Sale_Date', date_format) 

# create an output stream

output = BytesIO()

writer = pd.ExcelWriter(output, engine='xlsxwriter')



# Create the workbook

workbook = writer.book

# Create and name the sheets

worksheet = workbook.add_worksheet('Cover Sheet')

worksheet1 = workbook.add_worksheet('Sample Data')



# Number formatting

number_format = workbook.add_format({'num_format': '####', 'font_size': 14})

date_format = workbook.add_format({'num_format': 'dd/mm/yyyy hh:mm:ss', 'font_size': 14})



for col in field_names:

    worksheet1.write('A1', col, date_format if 'created_at' in col else number_format)



# Defining Cover sheet format

worksheet.set_column('A:BZ', None, color_format)



# # header column

row = 0

col = 0



for data in title:

    worksheet1.write(row, col, data, number_format)

    col += 1



#Pulling monthly data for columns for weekly raw data sheet

current_row = 1



for values in output_file:

    for idx, value in enumerate(values):

        worksheet1.write(current_row, idx, value, number_format)

    current_row += 1



# the writer has done its job

writer.close()



# go back to the beginning of the stream

output.seek(0)



# finally return the file

return output

name, age,class,join_date,date_of_birth,filing_date

date_format = workbook.add_format({'num_format': 'dd/mm/yyyy hh:mm:ss', 'font_size': 14})

worksheet1.write('A1', 'Sale_Date', date_format) 

# create an output stream

output = BytesIO()

writer = pd.ExcelWriter(output, engine='xlsxwriter')



# Create the workbook

workbook = writer.book

# Create and name the sheets

worksheet = workbook.add_worksheet('Cover Sheet')

worksheet1 = workbook.add_worksheet('Sample Data')



# Number formatting

number_format = workbook.add_format({'num_format': '####', 'font_size': 14})

date_format = workbook.add_format({'num_format': 'dd/mm/yyyy hh:mm:ss', 'font_size': 14})



for col in field_names:

    worksheet1.write('A1', col, date_format if 'created_at' in col else number_format)



# Defining Cover sheet format

worksheet.set_column('A:BZ', None, color_format)



# # header column

row = 0

col = 0



for data in title:

    worksheet1.write(row, col, data, number_format)

    col += 1



#Pulling monthly data for columns for weekly raw data sheet

current_row = 1



for values in output_file:

    for idx, value in enumerate(values):

        worksheet1.write(current_row, idx, value, number_format)

    current_row += 1



# the writer has done its job

writer.close()



# go back to the beginning of the stream

output.seek(0)



# finally return the file

return output

name, age,class,join_date,date_of_birth,filing_date

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',
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
});


}
});