Reading from filtered datasheet Excel in

Posted by Ashpal under VB.NET on 6/9/2014 | Points: 10 | Views : 600 | Status : [Member] | Replies : 1

I need to transfer data from excel to oracle using windows application
Data in excel is filtered. (Filtered using excel data filter)
When I select the data with (Select * from [Supefile]) it is selecting all the data in the sheet
or sometimes it is selecting 20647 rows (excel default no of rows)
How can I just read the filtered data?
Please help.


Posted by: Vuyiswamb on: 7/6/2014 [Member] [MVP] [Administrator] NotApplicable | Points: 25

it will difficult to do this , but now if something is filtered, then it is filtered based on a certain condition. Why dont you retrieve the data is and Filter it before processing it based on the Filter that is being selected.

Thank you for posting at Dotnetfunda

Ashpal, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response