I don't think this is so easy. Been looking at it a little, and I believe that when you create a button (radio button, checkbox, or push button) you actually create a tiny VBA macro. So it's not just another record type. It's another stream in which you would read with POIFS. And something like HAMF (Horrible Application Macro Format) which of course does not exist.
-----Original Message----- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 8:44 AM To: POI Users List Subject: Re: Checkboxes, Radio buttons, etc.. I mean its something that hasn't been implemented "Obj Record" refers to the low level binary construct. If you're interested in contributing and learning HSSF-speak, grab a copy of the "Microsoft Excel 97 Developer's Kit". Its out of print but available used/cheap on Amazon. Otherwise, I'm sure someone will port this some day. You can also take a looksie with the "java org.apache.poi.hssf.dev.BiffViewer bla.xls" utility. We redirect the output to a file and diff it against other files and thats how we learn what the structures are and how they change. -Andy Eric de Groot wrote: > Thanks for the response Andrew. Ok, understood. Could you give any > more details? What exactly do you mean by "the OBJ record"? What > existing parts of the POI project would be used for this? I read the > excel file format PDF, searched google many many times, etc.. and I > haven't seen anything about these form controls. Any kind of leads > you could give would be great. Thanks again. > > -Eric de Groot > > > > On Sunday, March 23, 2003, at 11:34 PM, Andrew C. Oliver wrote: > >> Not yet. These wouldn't be HPSF. Its the OBJ record. We don't do >> that just yet. Its a contribution opportunity. >> >> Eric de Groot wrote: >> >>> Does anyone know if it is possible to read the values of checkboxes >>> and radio buttons from an excel sheet? Possibly using HPSF? That's >>> the way i've been going so far at least, but I haven't come up with >>> anything at all. I only need to read the values of checkboxes and >>> the value of combo option sets. Thanks a lot. >>> >>> -Eric de Groot >>> >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>> For additional commands, e-mail: [EMAIL PROTECTED] >>> >>> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
