Thank you so much for your kind reply.
I have installed source. It's working fine.
I have one doubt.
If the empty field occurs, you have set the string "<Not Set>". That's fine.
1. How can I change the empty field box style in Red color. It's easy to
Identify. Because XL file may contains lot of empty fields.
2. And how can I add alt tag when I mouse over the empty field text box -
for eg. If I mouse over the empty field, It shows the empty field should not
be allowed.
3. After changing the file, what is save record button. How it works? Please
explain.
It's useful for me.
Thank you so much for all your kind reply.
It's really helpful to learn lot.
Regards,
Edi
Ayodeji Aladejebi wrote:
>
> meanwhile for the AjaxExcelGirdPanel, you have to click on the cell labels
> to edit them and you will require
> wicket-extensions along with the wicket jar to make it work
>
> regards
>
> On 7/4/07, Ayodeji Aladejebi <[EMAIL PROTECTED]> wrote:
>>
>> hmm..i have been busy
>>
>> but i worked a quick fix for you
>>
>> it is attached, its a netbeans project folder.
>>
>> I really hope you find it useful
>>
>> There are two panels there that meet your requirements
>> ExcelGridPanel and AjaxExcelGridPanel
>>
>> i does not support paging yet so that gagantic excel data wont scatter
>> the
>> screen
>>
>> I also realized that Loop and ListView have a lot of difference cuz
>> igor's
>> validation error notification code did not work with Loop until i
>> modified
>> it to ListView
>>
>> Either way, you could work your way from what is attached
>>
>> when i have more updates, i will let you know
>>
>> regards
>>
>>
>> On 7/2/07, Edi <[EMAIL PROTECTED]> wrote:
>> >
>> >
>> > Excuse me,
>> >
>> > ANy updates? please
>> >
>> >
>> >
>> > Ayodeji Aladejebi wrote:
>> > >
>> > > alas...igor has rescued us
>> > > pls give me some time to update the code wih this approach and send
>> it
>> > to
>> > > yu
>> > >
>> > > On 6/29/07, Igor Vaynberg <[EMAIL PROTECTED]> wrote:
>> > >>
>> > >> On 6/29/07, Ayodeji Aladejebi <[EMAIL PROTECTED] > wrote:
>> > >> >
>> > >> > that should be simple, although my wicket is bit rusty at the
>> > moment, I
>> > >> > think
>> > >> >
>> > >> > final TextField tx = new TextField("cell", new
>> > >> > PropertyModel(values[row][col],"data"));
>> > >> > tx.add(new IValidator(){
>> > >> > public void validate(FormComponent fc){
>> > >> >
>> > >> > if(fc.getValue () is greater than 20){
>> > >> > fc.add(new AttributeModifier("style",true, new
>> > >> > Model("background-color: #FF0000;")));
>> > >> > fc.error("error.toolongvalue ",null);
>> > >> > }else{
>> > >> > fc.add(new AttributeModifier("style",true, new
>> > >> > Model("background-color: normal-color;")));
>> > >> > }
>> > >> >
>> > >> > }
>> > >> > });
>> > >> > item.add(tx);
>> > >> >
>> > >> >
>> > >> > something like dat...just buzz around
>> > >>
>> > >>
>> > >> ayyayay, i guess no matter how you try to engineer the api people
>> > always
>> > >> find ways to abuse it :)
>> > >>
>> > >> TextField tf=new TextField(....) { oncomponenttag(tag) { if
>> > (!isvalid())
>> > >> {
>> > >> tag.put("class","error"); } }};
>> > >> tf.add(StringValidator.maxLength(20));
>> > >>
>> > >> -igor
>> > >>
>> > >>
>> > >>
>> > >> On 6/29/07, Edi < [EMAIL PROTECTED] > wrote:
>> > >> > >
>> > >> > >
>> > >> > > Or, tell me how to validate, if the text box value exceeds 20
>> > >> > > characters, I
>> > >> > > want to change the color of the text box. HOW?
>> > >> > >
>> > >> > >
>> > >> > >
>> > >> > > Ayodeji Aladejebi wrote:
>> > >> > > >
>> > >> > > > well,
>> > >> > > > yu can use String.length to do dat. but be aware it might
>> > jumble
>> > >> > > your
>> > >> > > > table
>> > >> > > > because some Text will be *This is a very long text that can
>> > expand
>> > >> > > the
>> > >> > > > Textfield too much* and some will be just "Hi".
>> > >> > > >
>> > >> > > > I had to make that trade off as well
>> > >> > > >
>> > >> > > > i am looking for some javascript technique maybe yu can show
>> me
>> > if
>> > >> > > yu
>> > >> > > > find.
>> > >> > > >
>> > >> > > > Look for a javascript library that can allow a user to
>> > dynamically
>> > >> > > expand
>> > >> > > > the textfield lenght with his mouse. so that we can attach
>> that
>> >
>> > >> > > Behavior
>> > >> > > > to
>> > >> > > > each Textfield
>> > >> > > >
>> > >> > > >
>> > >> > > >
>> > >> > > > On 6/29/07, Edi < [EMAIL PROTECTED]> wrote:
>> > >> > > >>
>> > >> > > >>
>> > >> > > >> Hi,
>> > >> > > >>
>> > >> > > >> In your sample code,
>> > >> > > >>
>> > >> > > >> tx.add (new AttributeModifier("size",true, new
>> > >> Model(String.valueOf
>> > >> > > (8))));
>> > >> > > >> It shows all the size of textbox is same.
>> > >> > > >>
>> > >> > > >> I want to change the size of text box value according to text
>> > each
>> > >> > > >> contents
>> > >> > > >>
>> > >> > > >>
>> > >> > > >>
>> > >> > > >> Ayodeji Aladejebi wrote:
>> > >> > > >> >
>> > >> > > >> > meanwhile,
>> > >> > > >> > if yu look at this code in the Wicket - JExcel example
>> > >> > > >> >
>> > >> > > >> > Cell cell = sheet.getCell(col, row);
>> > >> > > >> > values[row][col] = new
>> > >> > > XCell(row,
>> > >> > > >> > col,cell.getContents());
>> > >> > > >> >
>> > >> > > >> > return
>> > >> > > values[row][col].getData();
>> > >> > > >> >
>> > >> > > >> >
>> > >> > > >> > The Cell object is from JExcel and its where Datatype
>> should
>> > be
>> > >> > > >> retrieved
>> > >> > > >> > from
>> > >> > > >> >
>> > >> > > >> > 2. To validate,
>> > >> > > >> >
>> > >> > > >> > You can write a default wicket validator (See Validator
>> > >> > > examples),
>> > >> > > >> > The validator can access the Textfield arrays and then
>> check
>> > for
>> > >> > > >> validity
>> > >> > > >> >
>> > >> > > >> > its shouldn't be too difficult anyway
>> > >> > > >> >
>> > >> > > >> >
>> > >> > > >> >
>> > >> > > >> > On 6/28/07, Ayodeji Aladejebi <[EMAIL PROTECTED] > wrote:
>> > >> > > >> >>
>> > >> > > >> >> I think that is within the scope of the JExcel API and not
>> > a
>> > >> > > wicket
>> > >> > > >> >> thing.
>> > >> > > >> >> Refer to the JExcel API doc first
>> > >> > > >> >>
>> > >> > > >> >> On 6/28/07, Edi < [EMAIL PROTECTED] > wrote:
>> > >> > > >> >> >
>> > >> > > >> >> >
>> > >> > > >> >> > Hi,
>> > >> > > >> >> >
>> > >> > > >> >> > I am Newbie of Wicket. I have downloaded sample example
>> > to
>> > >> > > read XLS
>> > >> > > >> >> file
>> > >> > > >> >> >
>> > >> > > >> >> > using Wicket with JExcel.
>> > >> > > >> >> > It's working fine.
>> > >> > > >> >> >
>> > >> > > >> >> > My doubt is 1.How can I retrieve the datatype of each
>> > cell?
>> > >> > > and 2.
>> > >> > > >> How
>> > >> > > >> >> > to
>> > >> > > >> >> > validate the each cell values?
>> > >> > > >> >> >
>> > >> > > >> >> > Please give me some Suggestions.
>> > >> > > >> >> >
>> > >> > > >> >> > Thanking You.
>> > >> > > >> >> > Regards,
>> > >> > > >> >> > Edi
>> > >> > > >> >> > --
>> > >> > > >> >> > View this message in context:
>> > >> > > >> >> >
>> > >> > >
>> http://www.nabble.com/Wicket-with-JExcel-tf3994102.html#a11342103
>> > >> > > >> >> > Sent from the Wicket - User mailing list archive at
>> > >> Nabble.com
>> > >> > > .
>> > >> > > >> >> >
>> > >> > > >> >> >
>> > >> > > >> >> >
>> > >> > > >> >> >
>> > >> > > >> >>
>> > >> > > >>
>> > >> > >
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> > > >> >> > This SF.net email is sponsored by DB2 Express
>> > >> > > >> >> > Download DB2 Express C - the FREE version of DB2 express
>> > and
>> > >> > > take
>> > >> > > >> >> > control of your XML. No limits. Just data. Click to get
>> > it
>> > >> > > now.
>> > >> > > >> >> > http://sourceforge.net/powerbar/db2/
>> > >> > > >> >> > _______________________________________________
>> > >> > > >> >> > Wicket-user mailing list
>> > >> > > >> >> > Wicket-user@lists.sourceforge.net
>> > >> > > >> >> > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >> > > >> >> >
>> > >> > > >> >>
>> > >> > > >> >>
>> > >> > > >> >>
>> > >> > > >> >> --
>> > >> > > >> >>
>> > >> > > >> >>
>> > >> > > >> >
>> > >> > > >> >
>> > >> > > >>
>> > >> > >
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> > > >> > This SF.net email is sponsored by DB2 Express
>> > >> > > >> > Download DB2 Express C - the FREE version of DB2 express
>> and
>> > >> take
>> > >> > > >> > control of your XML. No limits. Just data. Click to get it
>> > now.
>> > >> > > >> > http://sourceforge.net/powerbar/db2/
>> > >> > > >> > _______________________________________________
>> > >> > > >> > Wicket-user mailing list
>> > >> > > >> > Wicket-user@lists.sourceforge.net
>> > >> > > >> > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >> > > >> >
>> > >> > > >> >
>> > >> > > >>
>> > >> > > >> --
>> > >> > > >> View this message in context:
>> > >> > > >>
>> > http://www.nabble.com/Wicket-with-JExcel-tf3994102.html#a11356793
>> > >> > > >> Sent from the Wicket - User mailing list archive at
>> Nabble.com
>> > .
>> > >> > > >>
>> > >> > > >>
>> > >> > > >>
>> > >> > >
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> > > >> This SF.net email is sponsored by DB2 Express
>> > >> > > >> Download DB2 Express C - the FREE version of DB2 express and
>> > take
>> > >> > > >> control of your XML. No limits. Just data. Click to get it
>> > now.
>> > >> > > >> http://sourceforge.net/powerbar/db2/
>> > >> > > >> _______________________________________________
>> > >> > > >> Wicket-user mailing list
>> > >> > > >> Wicket-user@lists.sourceforge.net
>> > >> > > >> https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >> > > >>
>> > >> > > >
>> > >> > > >
>> > >> > >
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> > > > This SF.net email is sponsored by DB2 Express
>> > >> > > > Download DB2 Express C - the FREE version of DB2 express and
>> > take
>> > >> > > > control of your XML. No limits. Just data. Click to get it
>> now.
>> >
>> > >> > > > http://sourceforge.net/powerbar/db2/
>> > >> > > > _______________________________________________
>> > >> > > > Wicket-user mailing list
>> > >> > > > Wicket-user@lists.sourceforge.net
>> > >> > > > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >> > > >
>> > >> > > >
>> > >> > >
>> > >> > > --
>> > >> > > View this message in context:
>> > >> > >
>> http://www.nabble.com/Wicket-with-JExcel-tf3994102.html#a11357007
>> > >> > > Sent from the Wicket - User mailing list archive at Nabble.com.
>> > >> > >
>> > >> > >
>> > >> > >
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> > >
>> > >> > > This SF.net email is sponsored by DB2 Express
>> > >> > > Download DB2 Express C - the FREE version of DB2 express and
>> take
>> >
>> > >> > > control of your XML. No limits. Just data. Click to get it now.
>> > >> > > http://sourceforge.net/powerbar/db2/
>> > >> > > _______________________________________________
>> > >> > > Wicket-user mailing list
>> > >> > > Wicket-user@lists.sourceforge.net
>> > >> > > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >> > >
>> > >> >
>> > >> >
>> > >> >
>> > >> >
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> > This SF.net email is sponsored by DB2 Express
>> > >> > Download DB2 Express C - the FREE version of DB2 express and take
>> > >> > control of your XML. No limits. Just data. Click to get it now.
>> > >> > http://sourceforge.net/powerbar/db2/
>> > >> > _______________________________________________
>> > >> > Wicket-user mailing list
>> > >> > Wicket-user@lists.sourceforge.net
>> > >> > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >> >
>> > >> >
>> > >>
>> > >>
>> >
>> -------------------------------------------------------------------------
>> > >> This SF.net email is sponsored by DB2 Express
>> > >> Download DB2 Express C - the FREE version of DB2 express and take
>> > >> control of your XML. No limits. Just data. Click to get it now.
>> > >> http://sourceforge.net/powerbar/db2/
>> > >> _______________________________________________
>> > >> Wicket-user mailing list
>> > >> Wicket-user@lists.sourceforge.net
>> > >> https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >>
>> > >>
>> > >
>> > >
>> >
>> -------------------------------------------------------------------------
>> > > This SF.net email is sponsored by DB2 Express
>> > > Download DB2 Express C - the FREE version of DB2 express and take
>> > > control of your XML. No limits. Just data. Click to get it now.
>> > > http://sourceforge.net/powerbar/db2/
>> > > _______________________________________________
>> > > Wicket-user mailing list
>> > > Wicket-user@lists.sourceforge.net
>> > > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> > >
>> > >
>> >
>> > --
>> > View this message in context:
>> > http://www.nabble.com/Wicket-with-JExcel-tf3994102.html#a11394181
>> > Sent from the Wicket - User mailing list archive at Nabble.com.
>> >
>> >
>> >
>> >
>> -------------------------------------------------------------------------
>> > This SF.net email is sponsored by DB2 Express
>> > Download DB2 Express C - the FREE version of DB2 express and take
>> > control of your XML. No limits. Just data. Click to get it now.
>> > http://sourceforge.net/powerbar/db2/
>> > _______________________________________________
>> > Wicket-user mailing list
>> > Wicket-user@lists.sourceforge.net
>> > https://lists.sourceforge.net/lists/listinfo/wicket-user
>> >
>>
>>
>>
>>
>>
>>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Wicket-user mailing list
> Wicket-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wicket-user
>
>
--
View this message in context:
http://www.nabble.com/Wicket-with-JExcel-tf3994102.html#a11424736
Sent from the Wicket - User mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Wicket-user mailing list
Wicket-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wicket-user
