How to ignore formulas when reading excel file

Thread Rating:

Thread Modes

How to ignore formulas when reading excel file

buran

Posts: 8,090

Threads: 154

Joined: Sep 2016

Reputation: 582

Aug-16-2019, 04:04 PM

IMHO the problem is that single header value e.g. Model Date is split in multiple rows, not that you have formulas.

If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Messages In This Thread

RE: How to ignore formulas when reading excel file - by buran - Aug-16-2019, 04:04 PM

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

Users browsing this thread: 1 Guest(s)