![]() |
Search a spreadsheet for words in certain fields
Hi. I'd like to be able to search a spreadsheet for words in certain fields.
I have to copy data from different regions of the spreadsheet, say B1:F45 and B55:F100. There is fixed text the beginning and end of these ranges that I can query, but I'll never know exactly how many rows exist in between in the range. I can query the speadsheet with an OleDbDataReader (VB.NET), but only "SELECT *...", a named range, or a range of cells specifed in the query ([Sheet1$B1:F45]). Is what I want to do possible with ADO.NET? Thanks for the help! |
All times are GMT +1. The time now is 04:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com