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.phak...@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+unsubscr...@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+unsubscr...@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.
