Stack Overflow
Stack Overflow

Questions tagged [xlsxwriter]

XlsxWriter is a python module for creating Excel XLSX files

XlsxWriter is a Python module for creating Excel XLSX files.

It can be used to write text, numbers, and formulas to multiple worksheets and it supports features such as formatting, images, charts, page setup, autofilters, conditional formatting and many others.

This module cannot be used to modify or write to an existing Excel XLSX file.

1959 questions
0
votes
1 answer

How to extend data in one column using xlsxwritter python

How to extend data in one column seperated by commas in xlsxwriter. for x in y: worksheet.merge_range("G"+str(row)+":"+"L"+str(row),x.multiple_values, centercell) row+=1 my data is dynamic for every loop i want to write values seperated by…
Israr Hussain Rao
  • 17
  • 2
0
votes
0 answers

How can I use XlsxWriter or other external libraries with PythonKit?

I've been trying to use my XlsxWriter based python script in my swift app with PythonKit. At first I tried installing XlsxWriter by running: pip3 install XlsxWriter It installed with no errors and the code runs fine in PyCharm when I import the…
Johnson
  • 161
  • 9
0
votes
1 answer

How to Create a Pandas DataFrame from multiple list of dictionaries

I want to create a pandas dataframe using the two list of dictionaries below: country_codes = [ { "id": 92, "name": "93", "position": 1, "description": "Afghanistan" }, { "id": 93, "name":…
Babayega
  • 33
  • 6
0
votes
0 answers

Heatmap to Excel Python

I have a heatmap which I plot in python and I want to export it to excel. I ve tried this: figure=sns.heatmap(df, cmap='viridis_r', annot=True, cbar=False).set(title=str(store)) in order to export it with xlsx writer. But i get the…
Κωνσταντίνος Μπεθάνης
  • 1
0
votes
2 answers

How to save excel file on android which is built using kivy app?

Can anyone help me with this please...I'm new to kivy and I had developed an app using python's kivy framework. In which I had used xlsxwriter for creating excel file. But the perplexing thing is when I run it on my windows that excel file is…
Reivanth K
  • 3
  • 2
0
votes
1 answer

How do I add the format for underlining text in xlsxwriter?

Just want to know how to create a variable for underlining text in the package xlsxwriter. For example, this is the one I created for making it bold: bold_format = workbook.add_format({'bold': True}) Sorry if the answer is blatantly obvious, I…
BenDeagle
  • 1
  • 1
0
votes
0 answers

Combine files in the folder to one excel workbook with different sheets

I would like to convert multiple csv file within the folder into xlsx file and then combine them into one single excel workbook with different sheets. For example: I have the following files in the folder: asia (P) 2022-11-21_10_52.csv as (P)…
yosif
  • 7
  • 1
  • 3
0
votes
0 answers

How to update table of Excel file used as template?

I'm trying to update an excel table (named DATA) in sheet Data of an existing Excel file. The table is empty and only has header row and first row below empty since the workbook works as a template. I've tried with xlswriter and successfully created…
Rasec Malkic
  • 373
  • 1
  • 8
0
votes
1 answer

How to put/stream data into an Excel file on sftp

What works With the following code, I can write the content of TheList into a CSV on an SFTP. import paramiko import csv # code part to make and open sftp connection TheList = [['name', 'address'], [ 'peter', 'london']] with sftp.open(SftpPath +…
Gamsner
  • 117
  • 1
  • 9
0
votes
1 answer

Formatting a cell in way so that only values specific format can be entered

I am using excel to store some data. The column stores some kind of output id which has to be in a certain format . The string should be in the format FP-2#-#### for example FP-22-1234 should be valid something like px423 should not be valid and the…
Pulkit Kalhan
  • 1
  • 1
0
votes
0 answers

How to set background color for row with specific column range?

How to set background color for row using set_bg_color -> https://xlsxwriter.readthedocs.io/format.html#set_bg_color but for specific column range? I mean not for entire row but from A2 to G2. This is what I've done: header_format =…
user19263504
  • 17
  • 7
0
votes
0 answers

Trying to create sub category within an Excel list

Image- enter image description here Image-enter image description here I am trying to use Xlsx Writer framework provided in python. I want my drop down to contain Province/ state two digit code grouped under Province section and other suppliers…
Pulkit Kalhan
  • 1
  • 1
0
votes
0 answers

ModuleNotFoundError: No module named 'xlsxwriter'

Need some help understanding why XlsxWriter cannot be imported when run directly from script. I have venv installed, however, tried to run without venv with the same results. Tried with Python 37 and 39. Same results. Works fine on another Windows…
Seven Twenty
  • 1
0
votes
0 answers

xlsxwriter doesn't change date alignment on data from pandas.to_excel()

example data: A B 1 2020/10/01 2 2021/10/01 Im using pandas.to_excel like so: df = pd.DataFrame(list(data)) writer = pd.ExcelWriter("excel.xlsx", engine='xlsxwriter', date_format="dd/mm/yyyy;@") df.to_excel(writer_head,…
Fath-Likki
  • 35
  • 5
0
votes
0 answers

Python - How can I write data from/to an Excel file, then rerun the code with a new input

im currently making a code in Python that goes onto a website, inputs texts, searches for the text, then copies over some data into an excel file. Im using xlsxwriter to do the excel part. However, I want to be able to do another search input and…
sadsapien
  • 1
  • 1
1 2 3
…
99 100