You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2009/02/11 22:23:29 UTC
DO NOT REPLY [Bug 46699] New: Unable to modify cell contents in a
spreadsheet
https://issues.apache.org/bugzilla/show_bug.cgi?id=46699
Summary: Unable to modify cell contents in a spreadsheet
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: enhancement
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: deepak_sathya@hotmail.com
This is just an enhancement request to make modifications to cell values in an
excel spreadsheet relatively easier.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46699] Unable to modify cell contents in a
spreadsheet
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46699
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |WORKSFORME
--- Comment #1 from Nick Burch <ni...@torchbox.com> 2009-02-11 15:18:38 PST ---
Editing contents of an excel spreadsheet is already fully supported by the hssf
usermodel
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46699] Unable to modify cell contents in a
spreadsheet
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46699
krishna81m@gmail.com <kr...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|WORKSFORME |
--- Comment #2 from krishna81m@gmail.com <kr...@gmail.com> 2010-02-26 15:27:27 UTC ---
Isn't the following code kind of an over kill to update a single cell in a huge
workbook with many sheets?
InputStream inp = new FileInputStream("wb.xls");
Workbook wb = WorkbookFactory.create(inp);
Sheet sheet = wb.getSheetAt([sheet index]);
Row row = sheet.getRow([row index]);
Cell cell = row.getCell([cell index]);
String cellContents = cell.getStringCellValue();
//Modify the cellContents here
// Write the output to a file
cell.setCellValue(cellContents);
FileOutputStream fileOut = new FileOutputStream("wb.xls");
wb.write(fileOut);
fileOut.close();
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: DO NOT REPLY [Bug 46699] Unable to modify cell contents in a
spreadsheet
Posted by MSB <ma...@tiscali.co.uk>.
Sorry to say this but I do not understand what the problem is. If you are
going to change the value of a cell you HAVE to open the file, gain access
to that cell, change it's value and then store the workbook away again.
How can you see the process being streamlined in any way?
Yours
Mark B
Bugzilla from bugzilla@apache.org wrote:
>
> https://issues.apache.org/bugzilla/show_bug.cgi?id=46699
>
> --- Comment #4 from krishna81m@gmail.com <kr...@gmail.com> 2010-02-26
> 18:21:13 UTC ---
> (In reply to comment #3)
>> Please ask questions on the list, rather than hijacking old bugs
>
> Hijack old bug? ;) I preferred to use an already requested enhancement
> (rather
> than a bug) as asking for an enhancement on a list wouldn't help!
>
> Sure, the title of the enhancement does not make sense to my context, in
> which
> case, you could have suggested me to raise a new enhancement or is my
> question
> incorrect, that I should ask for a solution on the list?
>
> --
> Configure bugmail:
> https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You are the assignee for the bug.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
>
>
>
--
View this message in context: http://old.nabble.com/DO-NOT-REPLY--Bug-46699--New%3A-Unable-to-modify-cell-contents-in-a-spreadsheet-tp21964581p27726406.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46699] Unable to modify cell contents in a
spreadsheet
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46699
--- Comment #4 from krishna81m@gmail.com <kr...@gmail.com> 2010-02-26 18:21:13 UTC ---
(In reply to comment #3)
> Please ask questions on the list, rather than hijacking old bugs
Hijack old bug? ;) I preferred to use an already requested enhancement (rather
than a bug) as asking for an enhancement on a list wouldn't help!
Sure, the title of the enhancement does not make sense to my context, in which
case, you could have suggested me to raise a new enhancement or is my question
incorrect, that I should ask for a solution on the list?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46699] Unable to modify cell contents in a
spreadsheet
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46699
Nick Burch <ni...@alfresco.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |RESOLVED
Resolution| |WORKSFORME
--- Comment #3 from Nick Burch <ni...@alfresco.com> 2010-02-26 15:42:03 UTC ---
Please ask questions on the list, rather than hijacking old bugs
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46699] Unable to modify cell contents in a
spreadsheet
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46699
krishna81m@gmail.com <kr...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |krishna81m@gmail.com
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org