0

is it possible to read/import formulas of excel sheet using pd.read_excel? If yes, How? If No, then is there any package which can do that along with keeping row 3 of excel file as header?

Amit Raghuwanshi
  • 23
  • 4
  • OpenPyXL p package can, you should check this out [How can I see the formulas of an excel spreadsheet in pandas / python?](https://stackoverflow.com/questions/42102674/how-can-i-see-the-formulas-of-an-excel-spreadsheet-in-pandas-python) – john taylor Sep 23 '20 at 14:37
  • Thanks John Taylor, I have been successful in reading the formulas with openpyxl but still finding a way to assign one of the row as header. Any suggestion would be appreciated. – Amit Raghuwanshi Sep 23 '20 at 15:17
  • you can also check this thread might be better (OpenPyXl: Mark row as heading)[https://stackoverflow.com/questions/55041209/openpyxl-mark-row-as-heading] – john taylor Sep 24 '20 at 14:29
  • it has two methods one using pandas and another using Freeze in OpenPyXL – john taylor Sep 24 '20 at 14:30

0 Answers0