creating a table in excel using python

Question

I am using xlwt to write to cells in excel from python. I am wondering if there is some way to select the written cells and insert a table. I have references to the cell range. Please help out.

Kindly show us what you've tried so far?Until then,we won't be able to help you — Alok
– Alok, Commented Feb 21, 2014 at 6:31
Also, any samples of what data you have and how you want it to appear in excel would help clarify the question. — Sologoub
– Sologoub, Commented Feb 21, 2014 at 6:40
@shaktimaan: I imported the xlwt module and wrote values to cells in an Excel worksheet, like this: ws.write(0,0,'name'). Suppose the range of written cells is A1:C10, is it possible to insert a table for those cells alone? — raul
– raul, Commented Feb 25, 2014 at 8:54
@Sologoub: I have numbers in all the cells. I want them to appear as a table (like when you select a range of cells and go insert->table from the menu ribbon) — raul
– raul, Commented Feb 25, 2014 at 9:01

loki · Accepted Answer · 2014-02-21 06:31:28Z

3

I m not aware of xlwt. But you can try it using xlsxwriter.

https://xlsxwriter.readthedocs.org/working_with_tables.html

answered Feb 21, 2014 at 6:31

loki

3872 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

creating a table in excel using python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related