Hi everybody
I am trying to read some data from an excel file in python. Here is a part of my code:
for example I have a cell with "COUNTA(F5:H5)" formula and value "2",... I need to save value in a variable in python not the formula.
Does anybody can help me?
Thank you.
I am trying to read some data from an excel file in python. Here is a part of my code:
def main(): xl_element = utils.XlsxOpen(r'C:\..........sheet1.xlsx' ) value_1=utils.XlsxGetCellValue(xl_element, "Sheet1", 0 ,0) print (value_1) if __name__ == '__main__': main()The problem is that when it reads from excel, for the cells I have a formula it shows the formula , not the value calculated.
for example I have a cell with "COUNTA(F5:H5)" formula and value "2",... I need to save value in a variable in python not the formula.
Does anybody can help me?
Thank you.
Larz60+ write Oct-29-2020, 02:57 AM:
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.
Added for you this time. please use on future posts.
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.
Added for you this time. please use on future posts.