Hello Ayodeji Aladejebi and all,
Please help me the regarding below feature.
thanking you
Regards
edi
Edi wrote:
>
> Thank you for all valuable solutions,
>
> Consider I have one xls file with lot of data. How can I paginate that
> xls file and Search the particular column data in the document and update
> the xls document.
>
> Thanking You.
> Regards,
> Edi
>
>
> Ayodeji Aladejebi wrote:
>>
>> thats why the source is open for you to hack into :)
>>
>> however,
>> 1. for the <Not Set> Stuff, check the XCell class for modification
>> 2. the one without ajax is easy, Look up the ExcelGridPanel class and
>> make
>> these modifications
>>
>> final XCell cell = ...
>> TextField celltx = new TextField("cell", new PropertyModel(cell,"data")){
>> public void onComponentTag(ComponentTag tag){
>> super.onComponentTag(tag);
>> if(!isValid()){
>> tag.put("class", "grid-error");
>>
>> }else
>> tag.put("class", "grid-normal");
>> //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.
>> if(cell.getContent().equals(""))
>> tag.put("class","grid-error");
>> //In xls one field contains more than 20 characters. When I upload that
>> xls,
>> //initially it shows the data only not in red color box. But when I click
>> the
>> //box only it shows red color. How can I show in red color when load the
>> //document.
>> if(cell.getContent().length() > 20)
>> tag.put("class", "grid-error");
>> //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.
>> if(cell.getContent().equals(""))
>> tag.put("alt","Empty Cells Not Allowed ");
>>
>> }
>> };
>>
>>>>After changing the file, what is save record button. How it works?
Please
>>>>explain.
>>
>> hmm... ok, depends on what you want to achieve but basically this is the
>> part of the code that you du what you got to do
>>
>> when i wrote the code, i used it for a project where ppl needed to upload
>> Mobile phone contacts into a database from Excel file, so our line of
>> purpose may be different. if you want to allow users to modify the Excel
>> Spreadsheet, its a different ball game
>>
>> Form gridForm = new Form("gridform"){
>>
>> public void onSubmit(){
>> //you could keep a reference to a XCell array and then
>> write
>> it back to the corresponding Cell instances from the Workbook
>> // NOte: that the code assumes every data in the Excel is a String. to
>> support multiple data types is another beast of code
>>
>> //so place your logic code here
>> }
>> }
>>
>>
>> Regards,
>>
>> On 7/4/07, Edi <[EMAIL PROTECTED]> wrote:
>>>
>>>
>>>
>>> In xls one field contains more than 20 characters. When I upload that
>>> xls,
>>> initially it shows the data only not in red color box. But when I click
>>> the
>>> box only it shows red color. How can I show in red color when load the
>>> document.
>>>
>>>
>>> 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#a11424912
>>> 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
>>>
>>
>>
>>
>> --
>> Aladejebi Ayodeji A.,
>> DabarObjects Solutions
>> Phone: +234 9 481 7 156
>> Mobile: +234 803 589 1780
>> Email: [EMAIL PROTECTED]
>> Web: www.dabarobjects.com
>> Blog: blog.dabarobjects.com
>>
>> Participate, Collaborate, Innovate
>> Join Community:
>> http://www.cowblock.net/
>>
>> Get A Free Blog:
>> http://blogs.cowblock.net/
>>
>> -------------------------------------------------------------------------
>> 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#a11553668
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
