Python Forum
How to ignore formulas when reading excel file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to ignore formulas when reading excel file
#3
My input data is as below:

Caegory    Model			        TM		
	       Date	       WAT	 Actual	Date	    Standard	Cal
N22HN	   2019-07-07	7	 Fail	2019-08-01	Noraml	    5/9
	       2019-07-22	12	 1.36	2019-08-02	Struck	    2/1.3
	       2019-07-30	62/9 6/1	2019-08-03	Miss	    4
TM--> "=HYPERLINK("#Sheet2!A1","TM")"

I still want to keep all the columns.
Reply


Messages In This Thread
RE: How to ignore formulas when reading excel file - by SriMekala - Aug-16-2019, 03:52 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Good way to ignore case when searching elements? Winfried 1 228 Apr-25-2024, 12:39 PM
Last Post: menator01
  Updating formulas in Excel - best solution MasterOfDestr 4 731 Mar-11-2024, 01:02 PM
Last Post: MasterOfDestr
  Python openyxl not updating Excel file MrBean12 1 387 Mar-03-2024, 12:16 AM
Last Post: MrBean12
  plotting based on the results of mathematical formulas Timur 1 380 Feb-08-2024, 07:22 PM
Last Post: Gribouillis
  Copy Paste excel files based on the first letters of the file name Viento 2 492 Feb-07-2024, 12:24 PM
Last Post: Viento
Sad problems with reading csv file. MassiJames 3 705 Nov-16-2023, 03:41 PM
Last Post: snippsat
  Search Excel File with a list of values huzzug 4 1,310 Nov-03-2023, 05:35 PM
Last Post: huzzug
  Updating sharepoint excel file odd results cubangt 1 911 Nov-03-2023, 05:13 PM
Last Post: noisefloor
  trouble reading string/module from excel as a list popular_dog 0 449 Oct-04-2023, 01:07 PM
Last Post: popular_dog
  Reading a file name fron a folder on my desktop Fiona 4 985 Aug-23-2023, 11:11 AM
Last Post: Axel_Erfurt

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020