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
Re: [Wicket-user] Wicket with JExcel
wait i have an update and will surely upload it for you
On 7/24/07, Edi [EMAIL PROTECTED] wrote:
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
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 and
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
Re: [Wicket-user] Wicket with JExcel
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 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
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
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() {
Re: [Wicket-user] Wicket with JExcel
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 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
Re: [Wicket-user] Wicket with JExcel
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?
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
.
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 the
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
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
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
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://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
Re: [Wicket-user] Wicket with JExcel
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://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
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:
Re: [Wicket-user] Wicket with JExcel
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:
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
Re: [Wicket-user] Wicket with JExcel
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:
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
[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
Re: [Wicket-user] Wicket with JExcel
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 -- Aladejebi Ayodeji A., DabarObjects Solutions Phone: +234 9 481 7 156 Mobile: +234 803 589 1780 Email: [EMAIL PROTECTED] Web: www.dabarobjects.com Blog: blog.dabarobjects.com Participate, Collaborate, Innovate Join Community: http://www.cowblock.net/ Get A Free Blog: http://blogs.cowblock.net/ - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ Wicket-user mailing list Wicket-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wicket-user
Re: [Wicket-user] Wicket with JExcel
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
