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

Conditional formatting giving AttributeError: 'NoneType' object has no attribute 'group'

I am trying to run a conditional format for one of my column in excel using xlswriter. I want to have the blank rows in the column in a certain format. Below I have attached the code snippet. But it is giving me an AttributeError:'NoneType' object…
Ramya
  • 13
  • 3
0
votes
1 answer

having issues formatting output to excel from dataframes, using xlsxwriter

I have a series of SQL database queries, that I am writing to Excel, using Xlswriter/Pandas. I am using a simple global format, for font type and size. Each table is different, so the only thing I want to do, is present a standard font and size. …
C0ppert0p
  • 634
  • 2
  • 7
  • 23
0
votes
1 answer

Increace respond from foreach in php

In fetching data from file_get_contents function to add the data in array. The data then added to excel with XLSXWriter. It looks like the respond to foreach is limited to 100. Is this possible to change so it could be a larger amount? $data =…
Addis1406
  • 15
  • 4
0
votes
1 answer

Trying to get just values and not the formulas from excel file with multiple sheets, on linux using Python

I have a large excel file that has many sheets, and the main sheet in its formulas uses values from the other sheets. I need the main sheet exported or loaded with just the precalculated values and not the formulas or NaNs. I want to do that using…
Petar Petrovic
  • 113
  • 3
0
votes
1 answer

Issue writing dictionary with xlsxwriter

I was adding a list of dictionaries into a dictionary using xlsxwriter but i am getting errors: Type error: Unsupported type in write() Code below: from xlsxwriter import Workbook my_dict = [{'test_case_Id': '', 'stepdata':…
MRINMOY DEB
  • 21
  • 3
0
votes
1 answer

How to combine multi excel workbook into single workbook with multiple worksheets

I have 3 workboooks with single sheets.I need to combine all workbooks into single workbook with 3 sheets. I tried the below code : from pandas import ExcelWriter writer = ExcelWriter("Sample.xlsx") for filename in glob.glob("*.xlsx"): …
Sparrow
  • 15
  • 6
0
votes
1 answer

XlsxWriter - Line with Gradient Fill

I am trying to plot the light spectrum with the XlsxWriter library. For this I would like to color the line with a gradient. Unfortunately this does not work for me, the line stays in the default color. This is the code I tried: …
JanIsMyName
  • 1
  • 1
0
votes
1 answer

How to conditionally format columns pertaining to a cell value

I'm trying to color cells within Column J a yellow color where it's cell value is N. I'm able to achieve this but I also want to color the corresponding cells in columns H & I when Column J is N and am having difficulty doing so. Does anyone have…
Nantourakis
  • 107
  • 1
  • 8
0
votes
1 answer

How to convert multiple CSV files to XLXS in Python?

I'm trying to convert all CSV files within a directory into one XLXS file with each csv file becoming a separate worksheet. The code below works except when I provide the input path in this Line "for filename in glob.glob(InputPath + "*.csv"):" I…
Nantourakis
  • 107
  • 1
  • 8
0
votes
0 answers

Python error : 'tuple' object is not callable on xlxswriter

I m trying to write some data in an excel file. rounds= [[(0, 2), (1, 3)], [(2, 0), (1, 3)], [(2, 1), (0, 3)], [(0, 3), (2, 1)], [(3, 0), (1, 2)], [(2, 0), (3, 1)]] And I want to write them in a list as below: (round is the index of the sub-list…
ToErotimatiko
  • 179
  • 2
  • 3
  • 14
0
votes
1 answer

How can i data frames to different worksheets?

I'm currently working on a code that scrapes a website for football match data, and I want it to put the data tables from the last 5 seasons into one excel workbook but on different sheets for each season. The code below works fine until the point…
daniel
  • 1
0
votes
1 answer

Why is my xlsxwriter conditional formatting not working?

I have two columns in a dataframe named FirstName and LastName. I need to make the font color of any cell's text in the FirstName column red if any cell in the LastName is not blank. writer = pd.ExcelWriter(fileName,…
user390480
  • 1,655
  • 4
  • 28
  • 61
0
votes
1 answer

How to save to a new Excel file every time i run jupyter notebook

I run daily reports using python and xlsxwriter. The way i currently have it set up the file is overwritten every time i run it, is there a way for jupyter to save to a new file under the same Folder, for example when i run my report it will save…
Bean boy
  • 1
  • 1
0
votes
0 answers

How to return a pandas Series from an inner function

This script is a simplified version of what I have as its too long to put here. I have tried to include all necessary information. class data(): def collect_data(self): def reader(n): self.df[n] =…
shoggananna
  • 545
  • 5
  • 9
0
votes
1 answer

Python - save a column in Excel with a lot of rows with random UUIDs

I have the following code: import xlsxwriter import numpy as np import pandas as pd import random import uuid LIMIT=1000 workbook = xlsxwriter.Workbook('test.xlsx') worksheet = workbook.add_worksheet() for row in range(0,LIMIT): …
Munchkin
  • 857
  • 5
  • 24
  • 51
1 2 3
…
99
100