ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ExecuteReader on empty Excel range hangs (https://www.excelbanter.com/excel-programming/418742-executereader-empty-excel-range-hangs.html)

Anber

ExecuteReader on empty Excel range hangs
 
With VB.NET (Visual Studio 2005), I am trying to read a range of cells from
an Excel-sheet, where the first rows and columns are empty. It's a sheet I
just created in Excel, so there has never been data in the first rows and
columns before. The actual data in the sheet starts at C4.
When I try to read a block of values which contains only empty cells, f.e.
A1:B2, ExecuteReader hangs.

Here is my code:

Dim ExcelConnectionString As String
Dim ExcelConnection As OleDbConnection

ExcelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
ExcelConnectionString += "C:\Temp\Test1.xls"
ExcelConnectionString += ";Extended Properties=""Excel
8.0;HDR=NO;IMEX=1"""
ExcelConnection = New OleDbConnection(ExcelConnectionString)
ExcelConnection.Open()

Dim command As New OleDbCommand("SELECT * FROM [Sheet1$A1:B2]",
ExcelConnection)
Dim reader As OleDbDataReader
reader = command.ExecuteReader()

When I open Excel, add values to the above range, then remove these values
and start the code again, the code works fine, the reader contains no rows
and that's what I want.

Does anyone know what's happening here?






All times are GMT +1. The time now is 01:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com