Dropdown control in OWC Spreadsheet

[Sathya]

I have situation to put an Dropdown control or List in the OWC spread sheet,
where the user can select values.

Is it possible, if so, can anybody provide me that piece of code, thanks.

sathya

 

[Alvin Bruney [MVP]]

No, it's not possible. If you feel experimental, the black book describes a
hack of sorts that places a control over the cells that can be made to line
up neatly so that it appears that the dropdown is part of the cell. However,
it has its issues because if the user resizes the form and you don't account
for it in code, your placement looks off.

How about using something like VSTO which allows that type of functionality?

 

[Sathya]

Hi Alvin,
Thanks for you reply.
I will tell u my situation, it will be great you can give me some suggestions.

Currently we have a project where we have some templates in Excel, which
when the user requests, we will load some data into the template and download
the excel to the user. the user will be making some changes or keyin some
data in the excel sheet and then upload it back.
we will read the excel and dump into our db.

currently we are using excel interop to do the whole process.

But we are moving to .net 2.0, thats 2005. Now there is a contraint that we
are not allowed to install word or excel or interops in the server. so we
tried using OWC, since there is some dropdowns i was wondering how to do it.

it will be great if you could suggest someway. btw, i will try some stuff in
VSTO and get back to u. btw doew VSTO needs to install office in the server?

 

[Alvin Bruney [MVP]]

If you want to go the OWC route, you'll have to redesign your application.
OWC can't read Excel files. You'd have to use xml, html or csv files, read
that in, parse it and dump it to the db. Not a whole lot of work but fairly
significant change.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley

 

[Sathya]

Hi Alvin,
Thanks for the reply. i cannot use the xml or HTML files. The problem i have
is that, the user have to see the data in excel format with data in it, in a
specified template format that has dropdowns. they will make change to it and
upload.
i doubt converting to xml, html or csv would solve the problem.

Please give me if you have any suggestions.

Thanks & REgards,
Sathya