Identify Hidden rows in xls

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Identify Hidden rows in xls

ayonsarkar
Unladen Swallow

Posts: 2

Threads: 1

Joined: Apr 2018

Reputation: 0

Apr-10-2018, 01:59 AM

Hi,

I have a xls file which is large and I am using xlrd to read the file. However there are hidden rows in the xls which i donot want to read.

I am using open_workbook to open the file, and getting the sheet object by workbook.sheet_by_name.

How can i check if a certain row is hidden? Can you please suggest? From the forums I see people are suggesting to use xlrd.sheet.RowInfo, but how i do set the row info from the sheet object?

It says, rowinfo is Derived from ROW records. How can i get Row records? Any help will be appreicated?

Find

Messages In This Thread

Identify Hidden rows in xls - by ayonsarkar - Apr-10-2018, 01:59 AM

RE: Identify Hidden rows in xls - by ayonsarkar - Apr-10-2018, 02:59 AM

RE: Identify Hidden rows in xls - by ljmetzger - Apr-10-2018, 08:33 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	identify not white pixels in bmp	flash77	17	2,508	Nov-10-2023, 09:21 PM Last Post: flash77
	Copy only hidden files and folders with rsync	Cannondale	2	1,018	Mar-04-2023, 02:48 PM Last Post: Cannondale
	Can ZipFile be used to extract hidden files?	AiedailEclipsed	0	1,637	Mar-22-2022, 05:21 PM Last Post: AiedailEclipsed
	The code I have written removes the desired number of rows, but wrong rows	Jdesi1983	0	1,636	Dec-08-2021, 04:42 AM Last Post: Jdesi1983
	guys please help me , pycharm is not able to identify my xlsx file	CrazyGreenYT7	1	2,024	Jun-13-2021, 02:22 PM Last Post: Larz60+
	Pandas DataFrame combine rows by column value, where Date Rows are NULL	rhat398	0	2,123	May-04-2021, 10:51 PM Last Post: rhat398
	Indexing [::-1] to Reverse ALL 2D Array Rows, ALL 3D, 4D Array Columns & Rows Python	Jeremy7	8	7,148	Mar-02-2021, 01:54 AM Last Post: Jeremy7
	Need to identify only files created today.	tester_V	5	4,659	Feb-18-2021, 06:32 AM Last Post: tester_V
	Run hidden exe	samuelbachorik	0	2,721	Aug-02-2020, 03:10 PM Last Post: samuelbachorik
	Rock, Paper, Scissors.. Help..hidden bug	xxunknownxx	4	2,680	Mar-19-2020, 02:46 AM Last Post: jefsummers

Users browsing this thread: 2 Guest(s)

View a Printable Version

Identify Hidden rows in xls

User Panel Messages

Announcements