Styjun

A quine of sorts

Could you fall off a planet if it was being accelerated by engines?

What's the point of stochastic volatiliy models if you can use local volatility?

Does a lens with a bigger max. aperture focus faster than a lens with a smaller max. aperture?

What is the meaning of "it" in "as luck would have it"?

Do electrons really perform instantaneous quantum leaps?

Robots in a spaceship

What does 'in attendance' mean on an England death certificate?

Processes in a session in an interactive shell vs in a script

Solve limit without using L'Hopital (first year problem for first year solution, not graduate level)

How to count the number of bytes in a file, grouping the same bytes?

What was the first science fiction or fantasy multiple choice book?

Is there a word for the act of simultaneously pulling and twisting an object?

I agreed to cancel a long-planned vacation (with travel costs) due to project deadlines, but now the timeline has all changed again

Russian equivalents of 能骗就骗 (if you can cheat, then cheat)

Any Tips On Writing Extended Recollection In A Novel

Reaction mechanism of rearrangement

Avoiding repetition when using the "snprintf idiom" to write text

LaTeX Make Word Appear

Why will we fail creating a self sustaining off world colony?

Active wildlife outside the window- Good or Bad for Cat psychology?

Does "boire un jus" tend to mean "coffee" or "juice of fruit"?

Enterprise Layers and Naming Conventions

How to remove system locales

Check in python if an excel cell is already formatted

How do I check if a list is empty?How do I check whether a file exists without exceptions?Calling an external command in PythonWhat are metaclasses in Python?Finding the index of an item given a list containing it in PythonHow can I safely create a nested directory?Does Python have a ternary conditional operator?Check if a given key already exists in a dictionaryDoes Python have a string 'contains' substring method?String formatting: % vs. .format

0

I have an excel file with some cells being formated (e.g. background-color is yellow). I want to parse every cell of my excel file in python and check whether each cell has been formatted or not.
And if not, call some function.

I tried to look at the documentation https://xlsxwriter.readthedocs.io/worksheet.html but could not find how to check if a cell is formatted or what is the cell format.

Here is the code I use to parse my excel cells:

import pandas as pd
import xlsxwriter
import xlrd

workbook = xlsxwriter.Workbook('output.xlsx')
wb = xlrd.open_workbook('input.xlsx')

# get sheet names
snames = wb.sheet_names()
print('sheets = '.format(snames))

for sname in snames:

 worksheet = workbook.add_worksheet(sname)

 df = pd.read_excel('input.xlsx', sheet_name=sname, header=None)

 for column in df.columns:
 print('*****')
 col_idx = df.columns.get_loc(column)
 for i, row in enumerate(df[column]):
 print('row nb = , row col = '.format(i, col_idx))
 if is_formatted(row):
 # call some function

workbook.close()

How would look is_formatted()function like ?

Thank you

python pandas xlsxwriter

share|improve this question

asked Mar 25 at 16:35

zakk8889zakk8889

3566 bronze badges

add a comment | 

0

I have an excel file with some cells being formated (e.g. background-color is yellow). I want to parse every cell of my excel file in python and check whether each cell has been formatted or not.
And if not, call some function.

I tried to look at the documentation https://xlsxwriter.readthedocs.io/worksheet.html but could not find how to check if a cell is formatted or what is the cell format.

Here is the code I use to parse my excel cells:

import pandas as pd
import xlsxwriter
import xlrd

workbook = xlsxwriter.Workbook('output.xlsx')
wb = xlrd.open_workbook('input.xlsx')

# get sheet names
snames = wb.sheet_names()
print('sheets = '.format(snames))

for sname in snames:

 worksheet = workbook.add_worksheet(sname)

 df = pd.read_excel('input.xlsx', sheet_name=sname, header=None)

 for column in df.columns:
 print('*****')
 col_idx = df.columns.get_loc(column)
 for i, row in enumerate(df[column]):
 print('row nb = , row col = '.format(i, col_idx))
 if is_formatted(row):
 # call some function

workbook.close()

How would look is_formatted()function like ?

Thank you

python pandas xlsxwriter

share|improve this question

asked Mar 25 at 16:35

zakk8889zakk8889

3566 bronze badges

add a comment | 

I have an excel file with some cells being formated (e.g. background-color is yellow). I want to parse every cell of my excel file in python and check whether each cell has been formatted or not.
And if not, call some function.

I tried to look at the documentation https://xlsxwriter.readthedocs.io/worksheet.html but could not find how to check if a cell is formatted or what is the cell format.

Here is the code I use to parse my excel cells:

import pandas as pd
import xlsxwriter
import xlrd

workbook = xlsxwriter.Workbook('output.xlsx')
wb = xlrd.open_workbook('input.xlsx')

# get sheet names
snames = wb.sheet_names()
print('sheets = '.format(snames))

for sname in snames:

 worksheet = workbook.add_worksheet(sname)

 df = pd.read_excel('input.xlsx', sheet_name=sname, header=None)

 for column in df.columns:
 print('*****')
 col_idx = df.columns.get_loc(column)
 for i, row in enumerate(df[column]):
 print('row nb = , row col = '.format(i, col_idx))
 if is_formatted(row):
 # call some function

workbook.close()

How would look is_formatted()function like ?

Thank you

python pandas xlsxwriter

share|improve this question

asked Mar 25 at 16:35

zakk8889zakk8889

3566 bronze badges

import pandas as pd
import xlsxwriter
import xlrd

workbook = xlsxwriter.Workbook('output.xlsx')
wb = xlrd.open_workbook('input.xlsx')

# get sheet names
snames = wb.sheet_names()
print('sheets = '.format(snames))

for sname in snames:

 worksheet = workbook.add_worksheet(sname)

 df = pd.read_excel('input.xlsx', sheet_name=sname, header=None)

 for column in df.columns:
 print('*****')
 col_idx = df.columns.get_loc(column)
 for i, row in enumerate(df[column]):
 print('row nb = , row col = '.format(i, col_idx))
 if is_formatted(row):
 # call some function

workbook.close()

share|improve this question

asked Mar 25 at 16:35

zakk8889zakk8889

3566 bronze badges

share|improve this question

asked Mar 25 at 16:35

zakk8889zakk8889

3566 bronze badges

asked Mar 25 at 16:35

zakk8889zakk8889

3566 bronze badges

asked Mar 25 at 16:35

zakk8889zakk8889

3566 bronze badges