xlsxwriter Questions
2
I can use conditional format to set the cell background color, but I wish to set the whole line background according to one cell text value.
for example:
import pandas as pd
import numpy as np
im...
Mcnamara asked 1/2, 2015 at 4:3
1
Solved
When a dataframe is exported from Pandas to Excel using xlsxwriter, it seems to put the table at cell A1 by default.
Is there a way to change this? I don't mind inserting rows and columns to move ...
Powerhouse asked 30/4, 2016 at 16:8
1
Solved
Python xlsxwriter, change row height for all rows in the sheet,
following is available but apply to single row
worksheet.set_row(0, 20) # Set the height of Row 1 to 20.
Want to change height of...
Wasserman asked 19/3, 2016 at 10:34
1
Solved
I would like to order my worksheets in a specific order (not alphabetical). In the past I have used Pandas DataFrame that was followed by a list.
DataFrame(csv_dict_list)[self.ORDER_LIST]
Right ...
Flavius asked 16/3, 2016 at 14:3
1
Solved
I need help with python XlsxWriter. I need to add link styling for external file link columns. But Xlsxwriter doesn't recognize styling for links(its second column) (text: underline, text-color: bl...
Flabellum asked 2/3, 2016 at 11:7
1
Solved
I'm using the excellent xlsxwriter to build spreadsheets with Python. I've become aware of the issue where you can only write 40k or so URLS to a sheet before you start getting warned and the funct...
Claret asked 1/3, 2016 at 17:42
2
Solved
How would I change the following code to handle NaN values as just empty cells within my dataframe as I iterate through it line by line outputting values in column A?
excel = pd.ExcelWriter(f_name...
Anderlecht asked 24/2, 2016 at 14:36
1
Reviewing Tim Hoffman's answer to this broader question made me want to make my headers wrap.
I tried this with the following code:
import pandas.core.format
pandas.core.format.header_style["alig...
Lawrencelawrencium asked 14/2, 2016 at 20:45
1
Solved
(My ultimate purpose is to append clickable cells to existing XLSX.)
I use the code below to extract the cell's display value and the hyperlink.
from openpyxl import load_workbook
xlsFile='hello...
Indistinguishable asked 23/1, 2016 at 13:48
2
Solved
One can write data to a specific cell, using:
xlsworksheet.write('B5', 'Hello')
But if you try to write a whole dataframe, df2, starting in cell 'B5':
xlsworksheet.write('B5', df2)
TypeError:...
Particulate asked 2/12, 2015 at 14:29
2
Solved
From the docs, the insert_image function takes the following options:
{
'x_offset': 0,
'y_offset': 0,
'x_scale': 1,
'y_scale': 1,
'url': None,
'tip': None,
'image_data': None,
'positioning...
Chronon asked 12/11, 2015 at 13:42
1
Solved
I'm using Pandas and exporting data to excel using XlsxWriter.
One of the data columns has floats and needs to be formatted as percent, so this is how I do it:
percent_fmt = workbook.add_format(...
Horsley asked 6/10, 2015 at 18:56
2
Solved
I have relatively big Excel spreadsheets, where I am applying conditional formatting. However, the content of a cell is relatively short (max 3 letters). So, I need to match exactly a string.
For ...
Cidevant asked 18/8, 2015 at 8:9
2
Solved
How would i define a column width for the entire 'worksheet' or for each column when using write_row()?
For example i have:
workbook = xlsxwriter.Workbook(loc_path + 'monbatch_test1.xlsx')
worksh...
Exuberant asked 7/1, 2015 at 4:2
1
Solved
I am formatting all of my columns in an excel file using the xlsxwriter module:
def to_excel(video_report, feed):
# Create a Pandas Excel writer using XlsxWriter as the engine.
writer = pd.Excel...
Pulp asked 1/6, 2015 at 14:45
1
Solved
I am generating plots in pandas/matplotlib and wish to write them to an XLSX file. I am not looking to create native Excel charts; I am merely writing the plots as non-interactive images. I am usin...
Gilley asked 8/6, 2015 at 18:54
2
Solved
In the below code I apply number formatting to each of the columns in my excel sheet. However, I can't seem to figure out to apply multiple formattings to a specific column, either the centering or...
Preeminent asked 1/6, 2015 at 2:5
1
I have been using xlsxwriter for a while and find it to be really helpful.
I have used it for multiple purposes like custom data validation, custom formats etc
However there are two things i am not...
Gamble asked 19/4, 2015 at 8:31
2
Solved
I am using the xlsxwriter tool to write some data to a .xlsx from the user input.
(I am very new to programming in general so sorry if my code is awful, it would be appreciated if you suggested / c...
Halation asked 8/8, 2014 at 15:41
1
I have create a chart by calling
worksheet.insert_chart(chart_row, chart, {'x_scale': 2, 'y_scale': 1})
it is a stacked type.
I want to make the chart horizontal wider, I tried to change x_scale...
Foreleg asked 2/4, 2015 at 7:52
1
I tried to use one %, and double %%, both seem to multiply my number to 100 times bigger.
This is what it looks like:
percent_format = workbook.add_format({'num_format': '0.00%'})
result: ...
Tantalic asked 25/3, 2015 at 23:51
1
Solved
I want to merge several series of cell ranges in an Excel file using Python Xlsxwriter, I found the Python command in the Xlsxwriter documentation in this website
http://xlsxwriter.readthedocs.org/...
Turoff asked 10/11, 2014 at 6:19
1
Solved
Can xlsxwriter object use a template of another excel file?
I tried to use xlsr but it can't use a template.
I am using xlsxwriter since I am writing more the 65335 lines.
Thanks.
Hayner asked 6/11, 2014 at 8:4
1
I have a class whose objects contain pandas dataframes (self.before, and self.after below) and a save() method which uses xlsxwriter to export the data (which has two worksheets, "before" and "afte...
Arrogant asked 24/8, 2014 at 20:35
1
Solved
I use python 3.4, pandas 0.14.1 and XlsxWriter 0.5.6.
I create a graph called 'graph' using pandas with the following code
graph=data_iter['_DiffPrice'].hist()
, which produces a beautiful his...
Shanahan asked 23/7, 2014 at 9:49
© 2022 - 2024 — McMap. All rights reserved.