How do i Get the Values in Excel cells and not the formular Using any Pyhton Package and also how to read from a excel file using the same package

Question

openpyxl doesn't use Excel at all, so... I guess it does what you want out of the box? — ChrisGPT was on strike, Jun 05 '21 at 17:11

score 0 · Accepted Answer · answered Jun 04 '21 at 10:46

0

When you load the workbook, set the flag data_only to True

wb = openpyxl.load_workbook(filename, data_only=True)

answered Jun 04 '21 at 10:46

Joe Thor

I believe that is possible, but I would recommend researching it before opening a question. It also is beyond the scope of this specific question. Here is an article that goes into writing using openpyxl: https://www.tutorialspoint.com/read-and-write-to-an-excel-file-using-python-openpyxl-module – Joe Thor Jun 04 '21 at 10:56
thanks, You've made things easier for me – MOSES NOKNAN JOHN Jun 04 '21 at 11:04

1 Answers1