exelldata in a selected fields like labels or text boxes....

Posted by Surisetti.rajesh under C# on 2/8/2010 | Views : 1135 | Status : [Member] | Replies : 3
iam doing one project actually we are taking one ex cell sheet in this we are having nearly 10-20 fields in this i have to retrieve that data as per user requirements(ie,. 5 or 10 may 20 )also that based in that the text from each field will be displayed on for as per required that means it may be center or corner or top like that or line by line in the form like this... this is client requirement(or) else instead of using label shall we use any other controls like "text box" like that.... place help me regarding this




Thank u for dotnet funda member......
Regards,
Rajesh S




Responses

Posted by: Abhi2434 on: 2/10/2010 [Member] [Microsoft_MVP] [MVP] Silver

Up
0
Down
Here is what you are looking for :

http://www.codeproject.com/KB/miscctrl/Excel_data_access.aspx

Just create the Query to fetch data and do using MDAC elements.

www.abhisheksur.com

Surisetti.rajesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bubbly on: 2/10/2010 [Member] Bronze

Up
0
Down
Hello,

Not as such clear with what you want but is it that you need to retrieve control properties as per in the excel and apply to your project?

++
Thanks & Regards,
Deepika

Surisetti.rajesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nishithraj on: 2/11/2010 [Member] Bronze

Up
0
Down
Excel Text box is a activeX control and you need to do some macro codings to work out that.

If a user disables activeX or macro it won't work properly. The better thing you can do it is rely on excel cells. It will work any case....

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Surisetti.rajesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response