I work on python using XlsxWriter and I’ve been trying to solve this problem with no success: My app must create an Xlsx file in which data is shown in a table-like structure. That table has some empty cells. I’d like to set borders to some cells to make a grid for the table so I use: in order to
Tag: excel
Pandas: Looking up the list of sheets in an excel file
The new version of Pandas uses the following interface to load Excel files: but what if I don’t know the sheets that are available? For example, I am working with excel files that the following sheets Data 1, Data 2 …, Data N, foo, bar but I don’t know N a priori. Is there any way to get the…
Insert row into Excel spreadsheet using openpyxl in Python
I’m looking for the best approach for inserting a row into a spreadsheet using openpyxl. Effectively, I have a spreadsheet (Excel 2007) which has a header row, followed by (at most) a few thousand rows of data. I’m looking to insert the row as the first row of actual data, so after the header. My …
python win32 COM closing excel workbook
I open several different workbooks (excel xlsx format) in COM, and mess with them. As the program progresses I wish to close one specific workbook but keep the rest open. How do I close ONE workbook? (instead of the entire excel application) Answer The the Workbook COM object has a Close() method. Basically, …