Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Excel sheet with tabs

Former Member

‎2011 Apr 07 1:08 PM

0 Likes
489

Hi all,

I have an excel sheet with 2 spread sheets. 1 hidden and other visible.

1) How to read the excel so that the hidden fields dont come into the internal table in which the data is read?

2) when the data is read from the visible tab of the excel sheet, data from hidden tab is also getting added in the internal table.

How to avoid it?

Useful answers will be rewarded with points.

please help!!!

Hi all,

I have an excel sheet with 2 spread sheets. 1 hidden and other visible.

1) How to read the excel so that the hidden fields dont come into the internal table in which the data is read?

2) when the data is read from the visible tab of the excel sheet, data from hidden tab is also getting added in the internal table.

How to avoid it?

Useful answers will be rewarded with points.

please help!!!

Reply
1 REPLY 1
Read only

venkatasriram_mygapula
Contributor

‎2011 Apr 08 4:47 AM

0 Likes
386

Hi,

If you have 2 tabs in your excel sheet. Open one tab which you want to process save it. Now it should be process active tab only.

thanks,

Sriram.