Reading from filtered datasheet Excel in vb.net

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

I need to transfer data from excel to oracle using vb.net 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.




Responses

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

Up
0
Down
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
[Administrator]

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

Login to post response