Re: Excel formula values

Hi Phako Perez,

Use the below statement will solve your problem.

Sheet5.Range("B1").Value or Sheet5.Range("B" & i).Value, i as an variable.

On Sat, 25 Aug 2018 at 06:43, Phako Perez <13.phakman@gmail.com> wrote:

Hi everyone,

I'm trying to get data from an excel file.
Every thing goes fine till cell contains an excel formula, such cases is getting null values


Here I open the book
———————-
report_book = openpyxl.load_workbook(filename, data_only=True)
sheet_list = report_book.sheetnames
worksheet = report_book[sheet_list[0]]

Here I get value for each column
———————-
row_num = 3
for k in COL_H[row_num]['CL']:
                bb = BASE + k
                value = worksheet.cell(row=row_num, column=bb).value


Thanks in advance
Happy weekend!!!

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/E2D6C45B-9C53-41A7-9959-AF7AA101EE2C%40gmail.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAF3dtbLsNwts1okBbFbFaT_qCnbnxmQsJWQjhG%2BhZWvBaDsv0Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.