[Wicket-user] Compare JSP Vs Wicket
Please send me all your suggestions. including the below question In jsp, I can pass the values using query string for eg. form action=actionJSP.jsp?userName=edipassword=edi using request.getParameter(userName); I can get the userName. using request.getParameter(password); I can get the password. In wicket, how can we do that? And send all notes regarding Compare JSP Vs Wicket Thanking You. -- View this message in context: http://www.nabble.com/Compare-JSP-Vs-Wicket-tf4242739.html#a12072743 Sent from the Wicket - User (OLD) mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ IMPORTANT NOTICE: This mailing list is shutting down. Please subscribe to the Apache Wicket user list. Send a message to: users-subscribe at wicket.apache.org and follow the instructions. ___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
Re: [Wicket-user] Compare JSP Vs Wicket
I am a Java, JSP Programmer. Now I am studying wicket. That's why I am asking Your all Suggestions. Thanking You. Johan Compagner wrote: for bookmarkable pages see pageparamer constructor, else RequestCycle.get.getRequest().getParameters(). But you should be looking at what you are trying to do.. think differently On 8/9/07, Edi [EMAIL PROTECTED] wrote: Please send me all your suggestions. including the below question In jsp, I can pass the values using query string for eg. form action=actionJSP.jsp?userName=edipassword=edi using request.getParameter(userName); I can get the userName. using request.getParameter(password); I can get the password. In wicket, how can we do that? And send all notes regarding Compare JSP Vs Wicket Thanking You. -- View this message in context: http://www.nabble.com/Compare-JSP-Vs-Wicket-tf4242739.html#a12072743 Sent from the Wicket - User (OLD) mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ IMPORTANT NOTICE: This mailing list is shutting down. Please subscribe to the Apache Wicket user list. Send a message to: users-subscribe at wicket.apache.org and follow the instructions. ___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ IMPORTANT NOTICE: This mailing list is shutting down. Please subscribe to the Apache Wicket user list. Send a message to: users-subscribe at wicket.apache.org and follow the instructions. ___ 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/Compare-JSP-Vs-Wicket-tf4242739.html#a12085069 Sent from the Wicket - User (OLD) mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ IMPORTANT NOTICE: This mailing list is shutting down. Please subscribe to the Apache Wicket user list. Send a message to: users-subscribe at wicket.apache.org and follow the instructions. ___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
[Wicket-user] Regarding Wicket Run-time exceptions?
Hi, I am using wicket + jexcel, I got the following error, wicket.WicketRuntimeException: Internal error cloning object. Make sure all dependent objects implement Serializable. Class: com.ui.page.MainPage Caused by: java.io.NotSerializableException: jxl.read.biff.LabelSSTRecord Please tell your suggestions to solve this problem Thanking you. Regards, Edi -- View this message in context: http://www.nabble.com/Regarding-Wicket-Run-time-exceptions--tf4149569.html#a11804823 Sent from the Wicket - User mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ IMPORTANT NOTICE: This mailing list is shutting down. Please subscribe to the Apache Wicket user list. Send a message to: users-subscribe at wicket.apache.org and follow the instructions. ___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
Re: [Wicket-user] Regarding Wicket Run-time exceptions?
Ok. I will Check. But When I get the cellType of each cell. It shows wrong type. for e.g Testing shows :: Date - wrong 12/12/07 shows :: Date- correct 200.00 shows :: Date - wrong. It looks like confusing. Please advise. Thanking You. Regards, Edi Ayodeji Aladejebi wrote: i suppose its a Jexcel issue because the Cell implementations are not Serializable so you should not make them a dependent object in your application like having private Cell cell; in your webpage or panel you could make it transient to avoid making it a serialization concern or if you follow my example you will see that placing such dependents in a WebPage or Panel was avoided Take a Look at ScrollableExcelGrid when you check the Panels, you will notice their is no JExcel object that is a dependent object however when you look at the Models, ExcelWorkbookModel and then CellWritableModel you only find references to the Workbook and i would consider that a problem because wicket gives you the freedom to use your models to build up your data. so stick to models On 7/26/07, Edi [EMAIL PROTECTED] wrote: Hi, I am using wicket + jexcel, I got the following error, wicket.WicketRuntimeException: Internal error cloning object. Make sure all dependent objects implement Serializable. Class: com.ui.page.MainPage Caused by: java.io.NotSerializableException: jxl.read.biff.LabelSSTRecord Please tell your suggestions to solve this problem Thanking you. Regards, Edi -- View this message in context: http://www.nabble.com/Regarding-Wicket-Run-time-exceptions--tf4149569.html#a11804823 Sent from the Wicket - User mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ IMPORTANT NOTICE: This mailing list is shutting down. Please subscribe to the Apache Wicket user list. Send a message to: users-subscribe at wicket.apache.org and follow the instructions. ___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ IMPORTANT NOTICE: This mailing list is shutting down. Please subscribe to the Apache Wicket user list. Send a message to: users-subscribe at wicket.apache.org and follow the instructions. ___ 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/Regarding-Wicket-Run-time-exceptions--tf4149569.html#a11808861 Sent from the Wicket - User mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ IMPORTANT NOTICE: This mailing list is shutting down. Please subscribe to the Apache Wicket user list. Send a message to: users-subscribe at wicket.apache.org and follow the instructions. ___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
Re: [Wicket-user] Regarding Wicket Run-time exceptions?
any reply, please Edi wrote: Ok. I will Check. But When I get the cellType of each cell. It shows wrong type. for e.g Testing shows :: Date - wrong 12/12/07 shows :: Date- correct 200.00 shows :: Date - wrong. It looks like confusing. I am using cell.getType() method. Actually my aim is, all the fieldname(header) and cell name(A1, B1, etc...), and data types, min value, max values of xls have stored in DB. I want to compare both db cell name(A1) data types and xls file cell name's(A1) data types. If it is wrong, I have to colored that text field or validated. How? Please advise and send your suggestions. Thanking You. Regards, Edi Ayodeji Aladejebi wrote: i suppose its a Jexcel issue because the Cell implementations are not Serializable so you should not make them a dependent object in your application like having private Cell cell; in your webpage or panel you could make it transient to avoid making it a serialization concern or if you follow my example you will see that placing such dependents in a WebPage or Panel was avoided Take a Look at ScrollableExcelGrid when you check the Panels, you will notice their is no JExcel object that is a dependent object however when you look at the Models, ExcelWorkbookModel and then CellWritableModel you only find references to the Workbook and i would consider that a problem because wicket gives you the freedom to use your models to build up your data. so stick to models On 7/26/07, Edi [EMAIL PROTECTED] wrote: Hi, I am using wicket + jexcel, I got the following error, wicket.WicketRuntimeException: Internal error cloning object. Make sure all dependent objects implement Serializable. Class: com.ui.page.MainPage Caused by: java.io.NotSerializableException: jxl.read.biff.LabelSSTRecord Please tell your suggestions to solve this problem Thanking you. Regards, Edi -- View this message in context: http://www.nabble.com/Regarding-Wicket-Run-time-exceptions--tf4149569.html#a11804823 Sent from the Wicket - User mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ IMPORTANT NOTICE: This mailing list is shutting down. Please subscribe to the Apache Wicket user list. Send a message to: users-subscribe at wicket.apache.org and follow the instructions. ___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ IMPORTANT NOTICE: This mailing list is shutting down. Please subscribe to the Apache Wicket user list. Send a message to: users-subscribe at wicket.apache.org and follow the instructions. ___ 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/Regarding-Wicket-Run-time-exceptions--tf4149569.html#a11822951 Sent from the Wicket - User mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ IMPORTANT NOTICE: This mailing list is shutting down. Please subscribe to the Apache Wicket user list. Send a message to: users-subscribe at wicket.apache.org and follow the instructions. ___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
Re: [Wicket-user] Wicket Excel Example
Hello Ayodeji Aladejebi, Could you tell me where can I download your file? Ayodeji Aladejebi wrote: Hi Edi, I have an excel example that you might like :) Attach the src.rar to any of your existing excel application and try it Features Update: 1. You can now write your modifications to disk 2. You can scroll now however, since wicket still lacks support for scrolling multiple lists with an IPageable instance, its hard to page the way one pages in Excel application There are still many bugs though and it only works well with strings and not numbers yet the more i can spend time to sit with the JExcel API, the more it can be improved -- 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: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ 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-Excel-Example-tf4140224.html#a11777398 Sent from the Wicket - User mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
Re: [Wicket-user] Wicket Excel Example
I have downloaded. I think you are spending your good time for me. Thank you so much. I will check. Regards, Edi Ayodeji Aladejebi wrote: You can download the Wicket Example at this link http://www.dabarobjects.com/downloads/ExcelExample.war and the src at http://www.dabarobjects.com/downloads/wicket-excel-src.rar Its not total or completed as more features will be added as i can make up some time regards On 7/25/07, Eelco Hillenius [EMAIL PROTECTED] wrote: On 7/25/07, Ayodeji Aladejebi [EMAIL PROTECTED] wrote: i have attached it to this email...check the attached RAR file I'm afraid attachements get filtered out, Aladejebi. Eelco - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ 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: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ 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-Excel-Example-tf4140224.html#a11779806 Sent from the Wicket - User mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
Re: [Wicket-user] Regarding Wicket with Dynamic Data
i am the newbie of wicket, so please provide some more hints to do the above problem Oleg Taranenko-2 wrote: Hello Edi, please visit www.databinder.net if you still have questions, welcome. Cheers, Monday, July 23, 2007, 2:24:47 PM, you wrote: Hi, my database is mssql/oracle or any. Consider I have one table name username and address. In table, I have 10 username and its addresses. I don't have any design pages for this table. My aim is, Initially When I click one link, I have to display username and addressess both textboxes should be displayed and search button also should be displayed. Is it possible? without declaring field id's(username, password), how can I display all the fiedls from DB? Please send your suggestions. Thanking You. Regards, Edi -- Best regards, Olegmailto:[EMAIL PROTECTED] - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ 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/Regarding-Wicket-with-Dynamic-Data-tf4129343.html#a11759225 Sent from the Wicket - User mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
Re: [Wicket-user] Wicket with JExcel
i have found A1,B1
I have downloaded your source, but
In createLoop, i got null pointer exception
java.lang.NullPointerException
at
com.enterra.vrm.qst.ui.page.reports.validatexl.AppletBasePanel.createLoop(AppletBasePanel.java:334)
Is there any exception hadler you added.
Ayodeji Aladejebi wrote:
I really dint get your question but from what i interpreted,
if you want an easy way to map between the Cell values and thier names
then,
develop an interpreting matrix that maps A1, A2, B1 to the 2-Dimension
model
array that contains the values,
For columns, you have A,B,C,D,E..AA (there is a common algorithm on
how
to generate this from 1,2,3,4,5...)
For rows, you have the 1,2,3,4,.
Then you have Cell[row][col] array or IModel[row][col] or
TextField[row][col], any one you choose,
then when you need the value of B4, then your interpreter translates it to
Column 2, Row 4
?
On 7/17/07, Edi [EMAIL PROTECTED] wrote:
Hello Ayodeji Aladejebi,
Thank you so much for your kind consideration regarding paginations.
and my question is how to find the each cell name.
for. eg. First cell name is A1 in the xl sheet, and its value may be
integer/float/general. I want to get the cell name A1 and it's value.
(we already get the value and displayed)
Hope you understand my question.
Thanking you.
Regards,
Edi
Ayodeji Aladejebi wrote:
hi Edi,
Concerning your question on Horizontal and vertical paging strategy, it
wont
be quite simple as ABC, i havent gotten time to do it but when i am
less
busy i will work on it.
i dint also pick your question on A1, B2, C1? you want to change it?,
On 7/16/07, Edi [EMAIL PROTECTED] wrote:
Hi, How to find each xl cell name,
Eg. A1, B2, C1 etc
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
[Wicket-user] Regarding Wicket with Dynamic Data
Hi, my database is mssql/oracle or any. Consider I have one table name username and address. In table, I have 10 username and its addresses. I don't have any design pages for this table. My aim is, Initially When I click one link, I have to display username and addressess both textboxes should be displayed and search button also should be displayed. Is it possible? without declaring field id's(username, password), how can I display all the fiedls from DB? Please send your suggestions. Thanking You. Regards, Edi -- View this message in context: http://www.nabble.com/Regarding-Wicket-with-Dynamic-Data-tf4129343.html#a11742646 Sent from the Wicket - User mailing list archive at Nabble.com. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
Re: [Wicket-user] Wicket with JExcel
Hi,
then when you need the value of B4, then your interpreter translates it to
Column 2, Row 4
Yes if col 2, row 4 means, it should B4. You are correct...
Any updates, please
Ayodeji Aladejebi wrote:
I really dint get your question but from what i interpreted,
if you want an easy way to map between the Cell values and thier names
then,
develop an interpreting matrix that maps A1, A2, B1 to the 2-Dimension
model
array that contains the values,
For columns, you have A,B,C,D,E..AA (there is a common algorithm on
how
to generate this from 1,2,3,4,5...)
For rows, you have the 1,2,3,4,.
Then you have Cell[row][col] array or IModel[row][col] or
TextField[row][col], any one you choose,
then when you need the value of B4, then your interpreter translates it to
Column 2, Row 4
?
On 7/17/07, Edi [EMAIL PROTECTED] wrote:
Hello Ayodeji Aladejebi,
Thank you so much for your kind consideration regarding paginations.
and my question is how to find the each cell name.
for. eg. First cell name is A1 in the xl sheet, and its value may be
integer/float/general. I want to get the cell name A1 and it's value.
(we already get the value and displayed)
Hope you understand my question.
Thanking you.
Regards,
Edi
Ayodeji Aladejebi wrote:
hi Edi,
Concerning your question on Horizontal and vertical paging strategy, it
wont
be quite simple as ABC, i havent gotten time to do it but when i am
less
busy i will work on it.
i dint also pick your question on A1, B2, C1? you want to change it?,
On 7/16/07, Edi [EMAIL PROTECTED] wrote:
Hi, How to find each xl cell name,
Eg. A1, B2, C1 etc
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
Re: [Wicket-user] Wicket with JExcel
Hello Ayodeji Aladejebi,
Thank you so much for your kind consideration regarding paginations.
and my question is how to find the each cell name.
for. eg. First cell name is A1 in the xl sheet, and its value may be
integer/float/general. I want to get the cell name A1 and it's value.
(we already get the value and displayed)
Hope you understand my question.
Thanking you.
Regards,
Edi
Ayodeji Aladejebi wrote:
hi Edi,
Concerning your question on Horizontal and vertical paging strategy, it
wont
be quite simple as ABC, i havent gotten time to do it but when i am less
busy i will work on it.
i dint also pick your question on A1, B2, C1? you want to change it?,
On 7/16/07, Edi [EMAIL PROTECTED] wrote:
Hi, How to find each xl cell name,
Eg. A1, B2, C1 etc
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
Re: [Wicket-user] Wicket with JExcel
Hello Ayodeji Aladejebi,
You already done, to select the particular file and load and view the file.
that's fine.
Now I want to validate each cell in easy manner. For example, if xl file
contains 1000 fields, most of the fields not validated - unvalidated fields
are colored.
so i want to list out easily with unvalidated fieldname, cellname, cell
value, error name. If I click that row/any link of that row, it should go to
edit page and after update, it should be stored xl file.
finally checked fields cell values should be stored in xl file in the
appropriate cell name.
Suppose, I have 2 fields not validated means, then the table looks like
Field Name/Column NameCellName CellValue error name
ColumnName1 A1 Ediname should
be atleast 20 characters
ColumnName2 B4(Column 2, Row 4) not-set
name should not be empty
-
all the fields should be checked empty field, field should be atleast 20
char.
Suppose, i have 100 unvalidated field, if i click submit, all the rows
should be with link is easy edit(consider the above table row, if i click
the first row, then onfocus the A1 Cell textbox value) and submit the record
and change the content of the appropriate cellname of the xl file.
if more than 20 fields then pagination is easy way to see the records.
This is my request. If you have doubt, please let me know.
Thanking you.
Regards,
Edi
Ayodeji Aladejebi wrote:
I really dint get your question but from what i interpreted,
if you want an easy way to map between the Cell values and thier names
then,
develop an interpreting matrix that maps A1, A2, B1 to the 2-Dimension
model
array that contains the values,
For columns, you have A,B,C,D,E..AA (there is a common algorithm on
how
to generate this from 1,2,3,4,5...)
For rows, you have the 1,2,3,4,.
Then you have Cell[row][col] array or IModel[row][col] or
TextField[row][col], any one you choose,
then when you need the value of B4, then your interpreter translates it to
Column 2, Row 4
?
On 7/17/07, Edi [EMAIL PROTECTED] wrote:
Hello Ayodeji Aladejebi,
Thank you so much for your kind consideration regarding paginations.
and my question is how to find the each cell name.
for. eg. First cell name is A1 in the xl sheet, and its value may be
integer/float/general. I want to get the cell name A1 and it's value.
(we already get the value and displayed)
Hope you understand my question.
Thanking you.
Regards,
Edi
Ayodeji Aladejebi wrote:
hi Edi,
Concerning your question on Horizontal and vertical paging strategy, it
wont
be quite simple as ABC, i havent gotten time to do it but when i am
less
busy i will work on it.
i dint also pick your question on A1, B2, C1? you want to change it?,
On 7/16/07, Edi [EMAIL PROTECTED] wrote:
Hi, How to find each xl cell name,
Eg. A1, B2, C1 etc
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
Re: [Wicket-user] Wicket with JExcel
Hi, How to find each xl cell name,
Eg. A1, B2, C1 etc
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: #FF;)));
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
[Wicket-user] Regarding onchange DropDown
Hi! I have one drop down like selectoptiontextbox/optionoptiontextarea/option/select in the above case, I have 2 items, 1.textbox 2.textarea. If I select textbox, text box should be displayed below the combo box. If I select textarea, textarea should be displayed but textbox should be hided. If I did not select anything, both textbox and textarea should be hided. I have done using javascript. But I don't know how it is in Wicket? I am newbie. So please give me your suggestions. Thanking You. Regards, Edi -- View this message in context: http://www.nabble.com/Regarding-onchange-DropDown-tf4072549.html#a11574089 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
Re: [Wicket-user] Regarding onchange DropDown
Could you please explain in detail manner? igor.vaynberg wrote: On 7/12/07, Edi [EMAIL PROTECTED] wrote: Hi! I have one drop down like selectoptiontextbox/optionoptiontextarea/option/select in the above case, I have 2 items, 1.textbox 2.textarea. If I select textbox, text box should be displayed below the combo box. If I select textarea, textarea should be displayed but textbox should be hided. If I did not select anything, both textbox and textarea should be hided. I have done using javascript. But I don't know how it is in Wicket? simplest way to do this would be to add two wicket HiddenFields - one for value of textbox and one for textarea, and then link them to the ones you created in the javascript. -igor I am newbie. So please give me your suggestions. Thanking You. Regards, Edi -- View this message in context: http://www.nabble.com/Regarding-onchange-DropDown-tf4072549.html#a11574089 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/Regarding-onchange-DropDown-tf4072549.html#a11574713 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
Re: [Wicket-user] Regarding onchange DropDown
That's fine.
How to get the value of selected item in dropdown box?
Regards,
edi
Dipu Seminlal wrote:
can you try target.addjavascript(javascript) or target.appendjavascript
(javascript)
regards
Dipu
On 7/13/07, Edi [EMAIL PROTECTED] wrote:
When onchange the DropDown box, how can I call the javascript function?
for eg;
makes.add(new AjaxFormComponentUpdatingBehavior(onchange)
{
protected void onUpdate(AjaxRequestTarget target)
{
target.addComponent(models);
//how to call javascript function here.
}
});
igor.vaynberg wrote:
On 7/13/07, Igor Vaynberg [EMAIL PROTECTED] wrote:
On 7/13/07, Edi [EMAIL PROTECTED] wrote:
Could you please explain in detail manner?
whats there to explain? in form.onsubmit or onchange event copy values
from your textarea/textfield to the appropriate hiddenfield element
via
javascript.
then when your form submits you can read the value out of that
hiddenfield
on serverside.
im not even sure you need the hiddenfield stuff, you might be able to
do
it
directly on textfield/textarea wicket components. just add both of
them.
afaik if the tag is hidden via javascript it will not submit its value
-
so
it should work automagically as long as you display:none one of them.
-igor
-igor
igor.vaynberg wrote:
On 7/12/07, Edi [EMAIL PROTECTED] wrote:
Hi!
I have one drop down like
selectoptiontextbox/optionoptiontextarea/option/select
in the above case, I have 2 items, 1.textbox 2.textarea.
If I select textbox, text box should be displayed below the combo
box. If
I
select textarea, textarea should be displayed but textbox should
be
hided.
If I did not select anything, both textbox and textarea should be
hided.
I have done using javascript. But I don't know how it is in
Wicket?
simplest way to do this would be to add two wicket HiddenFields -
one
for
value of textbox and one for textarea, and then link them to the
ones
you
created in the javascript.
-igor
I am newbie. So please give me your suggestions.
Thanking You.
Regards,
Edi
--
View this message in context:
http://www.nabble.com/Regarding-onchange-DropDown-tf4072549.html#a11574089
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/Regarding-onchange-DropDown-tf4072549.html#a11574713
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/Regarding-onchange-DropDown-tf4072549.html#a11576058
Sent from the Wicket - User mailing list archive at Nabble.com
Re: [Wicket-user] Regarding onchange DropDown
When onchange the DropDown box, how can I call the javascript function?
for eg;
makes.add(new AjaxFormComponentUpdatingBehavior(onchange)
{
protected void onUpdate(AjaxRequestTarget target)
{
target.addComponent(models);
//how to call javascript function here.
}
});
igor.vaynberg wrote:
On 7/13/07, Igor Vaynberg [EMAIL PROTECTED] wrote:
On 7/13/07, Edi [EMAIL PROTECTED] wrote:
Could you please explain in detail manner?
whats there to explain? in form.onsubmit or onchange event copy values
from your textarea/textfield to the appropriate hiddenfield element via
javascript.
then when your form submits you can read the value out of that
hiddenfield
on serverside.
im not even sure you need the hiddenfield stuff, you might be able to do
it
directly on textfield/textarea wicket components. just add both of them.
afaik if the tag is hidden via javascript it will not submit its value -
so
it should work automagically as long as you display:none one of them.
-igor
-igor
igor.vaynberg wrote:
On 7/12/07, Edi [EMAIL PROTECTED] wrote:
Hi!
I have one drop down like
selectoptiontextbox/optionoptiontextarea/option/select
in the above case, I have 2 items, 1.textbox 2.textarea.
If I select textbox, text box should be displayed below the combo
box. If
I
select textarea, textarea should be displayed but textbox should be
hided.
If I did not select anything, both textbox and textarea should be
hided.
I have done using javascript. But I don't know how it is in Wicket?
simplest way to do this would be to add two wicket HiddenFields - one
for
value of textbox and one for textarea, and then link them to the ones
you
created in the javascript.
-igor
I am newbie. So please give me your suggestions.
Thanking You.
Regards,
Edi
--
View this message in context:
http://www.nabble.com/Regarding-onchange-DropDown-tf4072549.html#a11574089
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/Regarding-onchange-DropDown-tf4072549.html#a11574713
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/Regarding-onchange-DropDown-tf4072549.html#a11576058
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
Re: [Wicket-user] Wicket with JExcel
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: #FF;)));
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
Re: [Wicket-user] Wicket with JExcel
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: #FF;)));
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
[Wicket-user] Get the input and diplay in the same page in xml format?
Hi, I have 3 fields, field name, data type, cell name If I enter the 3 fields, In the same page under the submit button, i want to show the given input data into XML. Is it possible, Suppose my input data looks like, Speed, string, and A1. it should show like fields field name =Speed data type = string cellvalue=A1/ /field Is it possible at run time? Thanking You Regards, Edi -- View this message in context: http://www.nabble.com/Get-the-input-and-diplay-in-the-same-page-in-xml-format--tf4034497.html#a11461311 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
Re: [Wicket-user] Wicket with JExcel
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: #FF;)));
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
Re: [Wicket-user] Wicket with JExcel
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: #FF;)));
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
Re: [Wicket-user] Wicket with JExcel
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: #FF;)));
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
Re: [Wicket-user] Wicket with JExcel
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
Re: [Wicket-user] Wicket with JExcel
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
Re: [Wicket-user] Wicket with JExcel
your first line shows
final TextField tx = new TextField(cell, new
PropertyModel(values[row][col],data));
But I got java.lang.IllegalArgumentException: Parameter modelObject cannot
be null
I have put
final TextField tx = new TextField(cell, model);
but this time I did not get any exception
BUt validate is not working. so i am not able validate. please explain. I am
using your code only.
Please check
http://cwiki.apache.org/WICKET/how-to-work-with-excel-in-wicket-using-jexcel-api.html
Ayodeji Aladejebi wrote:
and dont forget to create a resource key for the error.toolongvalue. You
should hae it in yor property file that maps to your class
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: #FF;)));
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
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
[Wicket-user] Wicket with JExcel
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
[Wicket-user] Wicket Fields with HTML Fields
Hello, I have one wicket page. It contains two text boxes (I have mentioned wicket:id). If I create text box in wicket page, wicket:id should be mentioned in Java file also. Right? In this wicket page, I have created 2 html text box also. But here no need to mention text name to java file. Correct? How can I submit and get normal html text box values in wicket page? Please explain. Thanking You Regards, Edi -- View this message in context: http://www.nabble.com/Wicket-Fields-with-HTML-Fields-tf3968846.html#a11265481 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
[Wicket-user] How to create Dynamic Label?
Hello Experts, I have one Label, and Text Box. If I enter any text in textbox, then it should be displayed in Label. How? Please explain. (I am newbie.) Thanking You. -- View this message in context: http://www.nabble.com/How-to-create-Dynamic-Label--tf3912921.html#a11093901 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
Re: [Wicket-user] How to create Dynamic Label?
Initially I have assigned one text in textbox like applet/applet But I have checked in view page source html, it looks like lt;appletgt; lt;/appletgt; I need to display applet/applet. Please explain. Carl-Eric Menzel-4 wrote: Simply give them both the same Model instance. To have it updated while typing, give the textfield an ajax updating behavior and repaint the label. Carl-Eric From: [EMAIL PROTECTED] on behalf of Edi Sent: Wed 6/13/2007 09:05 To: wicket-user@lists.sourceforge.net Subject: [Wicket-user] How to create Dynamic Label? Hello Experts, I have one Label, and Text Box. If I enter any text in textbox, then it should be displayed in Label. How? Please explain. (I am newbie.) Thanking You. - 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/How-to-create-Dynamic-Label--tf3912921.html#a11098554 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
Re: [Wicket-user] How to create Dynamic Label?
Hello Carl-Eric, It's working now. Thank you so much for your kind reply. Not working code is : Label msgLabel = new Label(msg, messageModel); add(msgLabel); Working Code is: Label msgLabel = new Label(msg, messageModel); msgLabel.setEscapeModelStrings(false); // Newly added Line add(msgLabel); Regards, Edi Carl-Eric Menzel-4 wrote: I think (didn't test it) that should work when you call setEscapeModelStrings(false) on the label. From: [EMAIL PROTECTED] on behalf of Edi Sent: Wed 6/13/2007 14:43 To: wicket-user@lists.sourceforge.net Subject: Re: [Wicket-user] How to create Dynamic Label? Initially I have assigned one text in textbox like applet/applet But I have checked in view page source html, it looks like lt;appletgt; lt;/appletgt; I need to display applet/applet. Please explain. Carl-Eric Menzel-4 wrote: Simply give them both the same Model instance. To have it updated while typing, give the textfield an ajax updating behavior and repaint the label. Carl-Eric From: [EMAIL PROTECTED] on behalf of Edi Sent: Wed 6/13/2007 09:05 To: wicket-user@lists.sourceforge.net Subject: [Wicket-user] How to create Dynamic Label? Hello Experts, I have one Label, and Text Box. If I enter any text in textbox, then it should be displayed in Label. How? Please explain. (I am newbie.) Thanking You. - 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/How-to-create-Dynamic-Label--tf3912921.html#a11098554 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/How-to-create-Dynamic-Label--tf3912921.html#a4100 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
[Wicket-user] Wicket set initial value
Hi, In HTML, input type=text name=name value=Edward, if value = edward, I can view In html page, In wicket How can I set ? -- View this message in context: http://www.nabble.com/Wicket-set-initial-value-tf3888763.html#a11023479 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
[Wicket-user] how to pass values to applet tags and display
Hi ! I have declared one applet file in display.html display.html looks like applet codebase=http://localhost:8080/project1; CODE=classname WIDTH=700 HEIGHT=350 /applet Using this hard coded values, I can view the person name Martin in applet. Consider I have one wicket button with text box with Label name person name. If I enter some name and click button, it should pass the applet tag. How can I pass the person name here. Please explain with details I am newbie of Wicket. Thank you for answering -- View this message in context: http://www.nabble.com/how-to-pass-values-to-applet-tags-and-display-tf3803180.html#a10761263 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
