PC Review


Reply
Thread Tools Rate Thread

Copying rows or cells using Java

 
 
=?Utf-8?B?R29yZG9u?=
Guest
Posts: n/a
 
      5th Aug 2007
I am creating reports in .xls format from a Java application using Jakarta
POI. For various reasons, I would like to be able to tweak the format of the
report interactively using Excel rather than POI. My approach to this is to
create a report template using Excel. My application will then open the
template and, for each row in the report, simply copy a row from the template
onto the report, and then fill in the values. However, I have not found a way
to copy a row or cell via POI in such a way that preserves formatting. Is it
possible to do this with POI? If not, is there any other Java API that
supports this? The copying of rows or cells would be between worksheets but
within the same workbook.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting certain Rows and Copying cells in those rows to new work Jinx123 Microsoft Excel Programming 1 8th Jun 2010 01:47 PM
Copying rows down into cells across until row=false ? jonski Microsoft Excel Worksheet Functions 5 27th Mar 2010 03:21 PM
insert rows and copying cells in column b,c, and d into new rows gbpg Microsoft Excel Programming 3 31st Dec 2009 01:05 AM
Adding Rows and copying cells Jeff S. Microsoft Excel New Users 2 5th Sep 2008 06:16 PM
copying cells into different rows in different worksheets =?Utf-8?B?c3RlcGhhbmll?= Microsoft Excel Programming 2 29th Nov 2004 03:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:32 AM.