Read data from Excel and pass it to textbox

[PrasadMani]

Hi there,

I want to read the data from an excel file and pass values into a textbox (I am automating a webapplication.)

Any help on this?

Thanks

[Juvigy]

For the EXCEL part check the Excel UDF. For the web part it may be more difficult , but the IE UDF should be enough.

[water]

Funcion _ExcelReadCell should do what you need.

[Myicq]

You're not being very specific. "I want to read the data" can be anything from "Read cell B4" to "Read entire sheet2 and create a sum on column B"

Give some examples and you will be helped better. Learn to ask good questions, and you will receive good answers.

[PrasadMani]

Thanks for ur reply. Your answers helped me out and worked well.