Reading from filtered datasheet Excel in vb.net

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts