How to write headers list in Python using csvwriter?

Question

I am trying with the following code

cursor = connect.cursor()
    sqlSelect = "SELECT to_char(t.create_date, 'DD-MM-YYYY') AS CreatedDate,t.ticket_number AS TicketNo,p.name AS Priority,t.person_name AS Person,t.subject AS Subject,s.name AS State, to_char(t.close_date, 'DD-MM-YYYY') AS ClosedDate FROM website_support_ticket t INNER JOIN website_support_ticket_priority p ON p.id = t.priority_id INNER JOIN website_support_ticket_state s ON s.id = t.state_id ORDER BY CreatedDate"
    try:
        cursor.execute(sqlSelect)
        results = cursor.fetchall()
        headers = [i[0] for i in cursor.description]
        csvFile = csv.writer(open(filePath + fileName, 'w'),
                             delimiter=',', lineterminator='\r\n',
                             quoting=csv.QUOTE_ALL, escapechar='\\')

        csvFile.writerows(headers)
        csvFile.writerows(results)

When I print the headers Output is like

('headers', ['createddate', 'ticketno', 'priority', 'person', 'subject', 'state', 'closeddate'])

and headers just dont write into CSV like headers,

any suggestions how I can print the headers only on the top first row? As of now, every letter of header goes into different rows.

Any suggestion or fix would be really helpful.

@All, Any ways to apply bold format to headers?

Shravy
– Shravy

2021-04-16 13:07:51 +00:00
Commented Apr 16, 2021 at 13:07 — Shravy
– Shravy, Commented Apr 16, 2021 at 13:07

hexbioc · Accepted Answer · 2021-04-16 11:24:45Z

4

Use writerow to add a single row passed as a list:

csvFile.writerow(headers)

answered Apr 16, 2021 at 11:24

hexbioc

1,6066 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Amiga500 · Accepted Answer · 2021-04-16 11:27:22Z

1

Try:

headers = ", ".join(cursor.description)

Not sure if the cursor.description is passed back as a list or not.

So quick check on my own stuff and it comes back as a tuple. Which will screw up the above.

headers = ", ".join([i[0] for i in cursor.description])

edited Apr 16, 2021 at 11:27

answered Apr 16, 2021 at 11:19

Amiga500

1,2851 gold badge7 silver badges12 bronze badges

2 Comments

Amiga500 Over a year ago

Use hexbioc's solution, its neater than this

Shravy Over a year ago

Yes @Amiga500, tried hexbioc's solution, it worked. Thank you for your efforts as well.

Collectives™ on Stack Overflow

How to write headers list in Python using csvwriter?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related