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”];