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#a11497945
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
