OLEDB无法正确读取配方单元格。 [英] OLEDB not reading formula cells correctly.

问题描述

当我尝试使用OleDB读取Excel文件时，我遇到了一些问题，我对它的阅读方式存在疑问。我有IMEX = 1和HDR =是;例如：Col A中的Sheet1有一些值，比如前15行是空白的，并且第16行有下拉值
（下拉列表可以只有'X'）;   Sheet2  Col A链接到Sheet 1的Col A.现在，如果Sheet1的值为第16行，当我使用OleDB读取它时，我对15行获得'0'，而第16行对于Sheet2来说是空白。
不知道如何解决这个问题，我需要只读取Sheet2中的值。对我来说这是一个非常关键的问题，请你帮我解决一下。谢谢。

I am having some issues when I am trying to read Excel file using OleDB, I am having issues with the way it is read. I have IMEX=1 and HDR=Yes; Eg: Sheet1 in Col A has some values, say the first 15 rows are blank in this, and there are dropdown values from row 16(the dropdown can have only 'X');  Sheet2  Col A is linked to Col A of Sheet 1. Now if Sheet1 has a value in say 16th row, when I read it using OleDB, I am getting '0' for the 15 rows and row 16 is coming as blank for Sheet2. Not sure how I can fix this, I need to read values from only Sheet2. This is a very critical issue for me, could you please help me with this. Thanks.

Rpaul

推荐答案

您好RPaul18，

Hi RPaul18,

欢迎来到MSDN论坛。

Welcome to MSDN Forum.

请您出示一些代码片段让我们责备isseu？这是，所以我们可以更有效地帮助您。 ：）

Could you please show some code snippet for us to repro the isseu? This is, so we can help you more effectively. : )

最好的问候

这篇关于OLEDB无法正确读取配方单元格。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！