to understand better what I want to do, I'll show you a simple example. following a little script to create an excel file named "test.xlsx" via XlsxWriter module. in this document we have only a column called "NAMES" and the name "Vittorio Emanuele" in the A:2 cell:
[Image: 5dff0e1238092764.jpg]
what about if I want to add a second name, for example "Alessandro Manzoni" in A2 cell like before, but without overrite the name "Vittorio Emanuele"? I would very like to have this reluslt: "Vittorio Emanuele\nAlessandro Manzoni". see the picture:
[Image: d376781238093964.jpg]
I need to find a command to do that, and use it in others programs that I wtote.
import xlsxwriter workbook = xlsxwriter.Workbook('test.xlsx') worksheet = workbook.add_worksheet("TEST") cell_format_1 = workbook.add_format({'bold': True, 'valign': 'left'}) cell_format_2 = workbook.add_format({'valign': 'left'}) worksheet.write(0, 0, "NAMES", cell_format_1) worksheet.write(1, 0, "Vittorio Emanuele", cell_format_2) worksheet.set_column(0, 0, 16.71) workbook.close()following picture shows the script's result:
[Image: 5dff0e1238092764.jpg]
what about if I want to add a second name, for example "Alessandro Manzoni" in A2 cell like before, but without overrite the name "Vittorio Emanuele"? I would very like to have this reluslt: "Vittorio Emanuele\nAlessandro Manzoni". see the picture:
[Image: d376781238093964.jpg]
I need to find a command to do that, and use it in others programs that I wtote.