Free Support Forum -

Why can't I read value from excel?


I had a excel file, and I can see the value in cell[“D10”] ~ [“D15”]
But when I can’t use the component to read it.
It always tell me the cell contains no data.

Can you help me to resolve the question??

There is a hidden worksheet in your file.

Please choose : Tools->Macro->Visual Basic Editor.

In the project explorer window, you can see the hidden worksheet.

You can get those values by:

Worksheet sheet = excel.Worksheets[“Cost Breakdown Summary”];
Cell cell = sheet.Cells[“D10”];