I think the way you need to do this is to get a list of the cells you
want to copy from the old sheet, create new cells on the new sheet, and
copy the attributes over from cell to cell. It's been a long time since
I've had to do anything like this but I don't think there's a copy
function.
Matt
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[
mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of DLee@xxxxxxxx
Sent: Wednesday, April 25, 2007 4:41 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: POI excel - copy/Inserting cells
Afternoon all.
I have a problem I'm trying to workout with POI excel sheets
My users have some worksheets where I am updating certain cells each
quarter, and this is working fine, and they love it.
Currently at the beginning of a new year, the user manually inserts a
set
of 3 new cells at the beginning of the existing sheet for each row in
the
sheet, which will be where the new years data will be stored. They
manually do this to about 100 workbooks
What I want to do is generate those 3 new cells by copying and inserting
the previous years 3 cells and formulas and cell styles to the new
location.
This will save the users from doing it themselves, and messing up the
formulas and cell styles, and causing me problems down the way.
I know how to create new sheets and rows, and update cells in sheets,
but
how to copy/insert cells is a mystery.
I didn't see anything in Scott's work, that I could use, but maybe I'm
missing something. I also looked thru the UserModel source for some
hint
about how to do this but nothing rang a bell for me.
Appreciate any help.
Darrell Lee
Information Technology
Extension 7127
midrange.com
