You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Donahue, Michael" <mi...@pearson.com> on 2007/03/08 16:52:39 UTC
RE: Read Excel sheet after editing it inside the browser
Zep -
I'm pretty sure you are going to have to save the file locally and then
upload the file back to the server as a regular file upload. Not the
prettiest solution, unless you want to write your own web based GUI or
plug-in for Excel files.
Good luck...
- Mike
---
Michael J. Donahue
Vangent, Inc.
845 Capitol Drive SW. (CRW - 500)
Cedar Rapids, IA 52404
office: 319-841-4941
fax: 319-841-4985
email & IM: michael.donahue@pearson.com
---
That's when I made up my mind to keep one foot in the Ideal Plane and
the other in the real world. --Father Mulcahy M*A*S*H
-----Original Message-----
From: Zep [mailto:sebasao@gmail.com]
Sent: Thursday, March 08, 2007 7:56 AM
To: poi-user@jakarta.apache.org
Subject: Read Excel sheet after editing it inside the brower
Hi everyone!
I've successfully opened an Excel file inside the browser, but now after
editing the sheet, I'm needing to submit the file to read it from a
Servlet.
In other words I need this:
step 1: display an Excel sheet inside the browser (successfully done).
step 2: edit the sheet (successfully done).
step 3: send the sheet data to a Servlet to read it.
- Im using IE 6
Anyone could help me?
Thanks a lot!!!
--
View this message in context:
http://www.nabble.com/Read-Excel-sheet-after-editing-it-inside-the-browe
r-tf3369115.html#a9374164
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
****************************************************************************
This email may contain confidential material.
If you were not an intended recipient,
Please notify the sender and delete all copies.
We may monitor email to and from our network.
****************************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Inserting row, column
Posted by Khanh Tran <tr...@gmail.com>.
Is there any way to insert a column berofe an existing column in HSSFSheet?
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
RE: no. of sheets in one excel file
Posted by Davis Varkey Koottala <da...@sg.systemaccess.com>.
Hi Harkirat,
This method is there in the API document of 3.0 version.
Regards,
Davis
"Harkirat Guron" <ha...@wispry.com>
03/10/2007 07:18 AM
Please respond to
"POI Users List" <po...@jakarta.apache.org>
To
"POI Users List" <po...@jakarta.apache.org>
cc
Subject
RE: no. of sheets in one excel file
Thanks Vilaplana for your help this is what I was looking for. I looked in
API couldn't find it.
Thanks
Harkirat Guron
WiSpry, Inc.
20 Fairbanks
Irvine, CA 92618
-----Original Message-----
From: grimborg@gmail.com [mailto:grimborg@gmail.com] On Behalf Of Òscar
Álvarez Vilaplana
Sent: Friday, March 09, 2007 3:11 PM
To: POI Users List
Subject: Re: no. of sheets in one excel file
Hello,
There is a getNumberOfSheets() method in HSSFWorkbook:
HSSFWorkbook wb = new HSSFWorkbook(is);
int numberOfSheets = wb.getNumberOfSheets();
Regards,
2007/3/9, Harkirat Guron <ha...@wispry.com>:
> Hello All,
> Is there any method to return no of sheets in an excel file?
>
>
>
>
>
>
>
> Harkirat Guron
> WiSpry, Inc.
> 20 Fairbanks
> Irvine, CA 92618
> -----Original Message-----
> From: Donahue, Michael [mailto:michael.donahue@pearson.com]
> Sent: Thursday, March 08, 2007 7:53 AM
> To: POI Users List
> Subject: RE: Read Excel sheet after editing it inside the browser
>
> Zep -
>
> I'm pretty sure you are going to have to save the file locally and then
> upload the file back to the server as a regular file upload. Not the
> prettiest solution, unless you want to write your own web based GUI or
> plug-in for Excel files.
>
> Good luck...
>
> - Mike
>
> ---
> Michael J. Donahue
> Vangent, Inc.
> 845 Capitol Drive SW. (CRW - 500)
> Cedar Rapids, IA 52404
> office: 319-841-4941
> fax: 319-841-4985
> email & IM: michael.donahue@pearson.com
> ---
> That's when I made up my mind to keep one foot in the Ideal Plane and
> the other in the real world. --Father Mulcahy M*A*S*H
>
> -----Original Message-----
> From: Zep [mailto:sebasao@gmail.com]
> Sent: Thursday, March 08, 2007 7:56 AM
> To: poi-user@jakarta.apache.org
> Subject: Read Excel sheet after editing it inside the brower
>
>
> Hi everyone!
>
> I've successfully opened an Excel file inside the browser, but now after
> editing the sheet, I'm needing to submit the file to read it from a
> Servlet.
>
> In other words I need this:
> step 1: display an Excel sheet inside the browser (successfully done).
> step 2: edit the sheet (successfully done).
> step 3: send the sheet data to a Servlet to read it.
>
> - Im using IE 6
>
> Anyone could help me?
> Thanks a lot!!!
> --
> View this message in context:
> http://www.nabble.com/Read-Excel-sheet-after-editing-it-inside-the-browe
> r-tf3369115.html#a9374164
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
> ************************************************************************
> ****
> This email may contain confidential material.
> If you were not an intended recipient,
> Please notify the sender and delete all copies.
> We may monitor email to and from our network.
> ************************************************************************
> ****
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
RE: no. of sheets in one excel file
Posted by Harkirat Guron <ha...@wispry.com>.
Thanks Vilaplana for your help this is what I was looking for. I looked in API couldn't find it.
Thanks
Harkirat Guron
WiSpry, Inc.
20 Fairbanks
Irvine, CA 92618
-----Original Message-----
From: grimborg@gmail.com [mailto:grimborg@gmail.com] On Behalf Of Òscar Álvarez Vilaplana
Sent: Friday, March 09, 2007 3:11 PM
To: POI Users List
Subject: Re: no. of sheets in one excel file
Hello,
There is a getNumberOfSheets() method in HSSFWorkbook:
HSSFWorkbook wb = new HSSFWorkbook(is);
int numberOfSheets = wb.getNumberOfSheets();
Regards,
2007/3/9, Harkirat Guron <ha...@wispry.com>:
> Hello All,
> Is there any method to return no of sheets in an excel file?
>
>
>
>
>
>
>
> Harkirat Guron
> WiSpry, Inc.
> 20 Fairbanks
> Irvine, CA 92618
> -----Original Message-----
> From: Donahue, Michael [mailto:michael.donahue@pearson.com]
> Sent: Thursday, March 08, 2007 7:53 AM
> To: POI Users List
> Subject: RE: Read Excel sheet after editing it inside the browser
>
> Zep -
>
> I'm pretty sure you are going to have to save the file locally and then
> upload the file back to the server as a regular file upload. Not the
> prettiest solution, unless you want to write your own web based GUI or
> plug-in for Excel files.
>
> Good luck...
>
> - Mike
>
> ---
> Michael J. Donahue
> Vangent, Inc.
> 845 Capitol Drive SW. (CRW - 500)
> Cedar Rapids, IA 52404
> office: 319-841-4941
> fax: 319-841-4985
> email & IM: michael.donahue@pearson.com
> ---
> That's when I made up my mind to keep one foot in the Ideal Plane and
> the other in the real world. --Father Mulcahy M*A*S*H
>
> -----Original Message-----
> From: Zep [mailto:sebasao@gmail.com]
> Sent: Thursday, March 08, 2007 7:56 AM
> To: poi-user@jakarta.apache.org
> Subject: Read Excel sheet after editing it inside the brower
>
>
> Hi everyone!
>
> I've successfully opened an Excel file inside the browser, but now after
> editing the sheet, I'm needing to submit the file to read it from a
> Servlet.
>
> In other words I need this:
> step 1: display an Excel sheet inside the browser (successfully done).
> step 2: edit the sheet (successfully done).
> step 3: send the sheet data to a Servlet to read it.
>
> - Im using IE 6
>
> Anyone could help me?
> Thanks a lot!!!
> --
> View this message in context:
> http://www.nabble.com/Read-Excel-sheet-after-editing-it-inside-the-browe
> r-tf3369115.html#a9374164
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
> ************************************************************************
> ****
> This email may contain confidential material.
> If you were not an intended recipient,
> Please notify the sender and delete all copies.
> We may monitor email to and from our network.
> ************************************************************************
> ****
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: no. of sheets in one excel file
Posted by Òscar Álvarez Vilaplana <os...@poal.org>.
Hello,
There is a getNumberOfSheets() method in HSSFWorkbook:
HSSFWorkbook wb = new HSSFWorkbook(is);
int numberOfSheets = wb.getNumberOfSheets();
Regards,
2007/3/9, Harkirat Guron <ha...@wispry.com>:
> Hello All,
> Is there any method to return no of sheets in an excel file?
>
>
>
>
>
>
>
> Harkirat Guron
> WiSpry, Inc.
> 20 Fairbanks
> Irvine, CA 92618
> -----Original Message-----
> From: Donahue, Michael [mailto:michael.donahue@pearson.com]
> Sent: Thursday, March 08, 2007 7:53 AM
> To: POI Users List
> Subject: RE: Read Excel sheet after editing it inside the browser
>
> Zep -
>
> I'm pretty sure you are going to have to save the file locally and then
> upload the file back to the server as a regular file upload. Not the
> prettiest solution, unless you want to write your own web based GUI or
> plug-in for Excel files.
>
> Good luck...
>
> - Mike
>
> ---
> Michael J. Donahue
> Vangent, Inc.
> 845 Capitol Drive SW. (CRW - 500)
> Cedar Rapids, IA 52404
> office: 319-841-4941
> fax: 319-841-4985
> email & IM: michael.donahue@pearson.com
> ---
> That's when I made up my mind to keep one foot in the Ideal Plane and
> the other in the real world. --Father Mulcahy M*A*S*H
>
> -----Original Message-----
> From: Zep [mailto:sebasao@gmail.com]
> Sent: Thursday, March 08, 2007 7:56 AM
> To: poi-user@jakarta.apache.org
> Subject: Read Excel sheet after editing it inside the brower
>
>
> Hi everyone!
>
> I've successfully opened an Excel file inside the browser, but now after
> editing the sheet, I'm needing to submit the file to read it from a
> Servlet.
>
> In other words I need this:
> step 1: display an Excel sheet inside the browser (successfully done).
> step 2: edit the sheet (successfully done).
> step 3: send the sheet data to a Servlet to read it.
>
> - Im using IE 6
>
> Anyone could help me?
> Thanks a lot!!!
> --
> View this message in context:
> http://www.nabble.com/Read-Excel-sheet-after-editing-it-inside-the-browe
> r-tf3369115.html#a9374164
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
> ************************************************************************
> ****
> This email may contain confidential material.
> If you were not an intended recipient,
> Please notify the sender and delete all copies.
> We may monitor email to and from our network.
> ************************************************************************
> ****
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
no. of sheets in one excel file
Posted by Harkirat Guron <ha...@wispry.com>.
Hello All,
Is there any method to return no of sheets in an excel file?
Harkirat Guron
WiSpry, Inc.
20 Fairbanks
Irvine, CA 92618
-----Original Message-----
From: Donahue, Michael [mailto:michael.donahue@pearson.com]
Sent: Thursday, March 08, 2007 7:53 AM
To: POI Users List
Subject: RE: Read Excel sheet after editing it inside the browser
Zep -
I'm pretty sure you are going to have to save the file locally and then
upload the file back to the server as a regular file upload. Not the
prettiest solution, unless you want to write your own web based GUI or
plug-in for Excel files.
Good luck...
- Mike
---
Michael J. Donahue
Vangent, Inc.
845 Capitol Drive SW. (CRW - 500)
Cedar Rapids, IA 52404
office: 319-841-4941
fax: 319-841-4985
email & IM: michael.donahue@pearson.com
---
That's when I made up my mind to keep one foot in the Ideal Plane and
the other in the real world. --Father Mulcahy M*A*S*H
-----Original Message-----
From: Zep [mailto:sebasao@gmail.com]
Sent: Thursday, March 08, 2007 7:56 AM
To: poi-user@jakarta.apache.org
Subject: Read Excel sheet after editing it inside the brower
Hi everyone!
I've successfully opened an Excel file inside the browser, but now after
editing the sheet, I'm needing to submit the file to read it from a
Servlet.
In other words I need this:
step 1: display an Excel sheet inside the browser (successfully done).
step 2: edit the sheet (successfully done).
step 3: send the sheet data to a Servlet to read it.
- Im using IE 6
Anyone could help me?
Thanks a lot!!!
--
View this message in context:
http://www.nabble.com/Read-Excel-sheet-after-editing-it-inside-the-browe
r-tf3369115.html#a9374164
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
************************************************************************
****
This email may contain confidential material.
If you were not an intended recipient,
Please notify the sender and delete all copies.
We may monitor email to and from our network.
************************************************************************
****
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
RE: Read Excel sheet after editing it inside the browser
Posted by Tahir Akhtar <ta...@spectrum-tech.com>.
Zep,
I agree with Mike. Your solution will require
* Excel installed on each client pc
* Users must (temporarily) save the file on there PC
* File will need to be uploaded.
You may find browser security issues when trying to do local-save and upload
behind the scenes (without user noticing temporary file save step).
Unless you are writing a small tool to be used by a select few users, the
approach won't take you far. For more sophisticated control you may want to
explore other alternatives.
In one of our commercial product, we provided a swing based worksheet editor
(using JTable) that stored the data in a internal form. This internal form
would then be converted into excel workbook using POI (on demand).
Also there are tools that use AJAX techniques to create a spreadsheet editor
within the browser (see google spreadsheet for example).
Regards,
Tahir
> -----Original Message-----
> From: Donahue, Michael [mailto:michael.donahue@pearson.com]
> Sent: Thursday, March 08, 2007 8:53 PM
> To: POI Users List
> Subject: RE: Read Excel sheet after editing it inside the browser
>
> Zep -
>
> I'm pretty sure you are going to have to save the file locally and then
> upload the file back to the server as a regular file upload. Not the
> prettiest solution, unless you want to write your own web based GUI or
> plug-in for Excel files.
>
> Good luck...
>
> - Mike
>
> ---
> Michael J. Donahue
> Vangent, Inc.
> 845 Capitol Drive SW. (CRW - 500)
> Cedar Rapids, IA 52404
> office: 319-841-4941
> fax: 319-841-4985
> email & IM: michael.donahue@pearson.com
> ---
> That's when I made up my mind to keep one foot in the Ideal Plane and
> the other in the real world. --Father Mulcahy M*A*S*H
>
> -----Original Message-----
> From: Zep [mailto:sebasao@gmail.com]
> Sent: Thursday, March 08, 2007 7:56 AM
> To: poi-user@jakarta.apache.org
> Subject: Read Excel sheet after editing it inside the brower
>
>
> Hi everyone!
>
> I've successfully opened an Excel file inside the browser, but now after
> editing the sheet, I'm needing to submit the file to read it from a
> Servlet.
>
> In other words I need this:
> step 1: display an Excel sheet inside the browser (successfully done).
> step 2: edit the sheet (successfully done).
> step 3: send the sheet data to a Servlet to read it.
>
> - Im using IE 6
>
> Anyone could help me?
> Thanks a lot!!!
> --
> View this message in context:
> http://www.nabble.com/Read-Excel-sheet-after-editing-it-inside-the-browe
> r-tf3369115.html#a9374164
> Sent from the POI - User mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
> **************************************************************************
> **
> This email may contain confidential material.
> If you were not an intended recipient,
> Please notify the sender and delete all copies.
> We may monitor email to and from our network.
> **************************************************************************
> **
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/