In certain cases, you need to copy rows and columns in an Excel file without copying the entire worksheet. To perform this operation programmatically, this article covers how to copy rows or columns in an Excel worksheet using Java.
- Java API to Copy Rows and Columns in Excel
- Copy Rows in Excel Worksheet using Java
- Copy Columns in Excel Worksheet using Java
Java API to Copy Rows and Columns in Excel
Aspose.Cells for Java lets you implement Excel automation features from within your Java applications. In addition, the API provides simple ways to copy rows and columns within or between the Excel workbooks. You can either download the API or install it using the following Maven configurations.
<repository>
<id>AsposeJavaAPI</id>
<name>Aspose Java API</name>
<url>https://repository.aspose.com/repo/</url>
</repository>
<dependency>
<groupId>com.aspose</groupId>
<artifactId>aspose-cells</artifactId>
<version>21.7</version>
</dependency>
Copy Rows in Excel Worksheet using Java
The following are the steps to copy a row in an Excel worksheet using Java.
- First, load the Excel file using Workbook class.
- Get the desired Worksheet from Workbook.getWorksheets() collection.
- Copy desired row by specifying the source and target row index in Worksheet.getCells().copyRow(Workheet.getCells(), sourceRowIndex, targetRowIndex)) method.
- Finally, save the updated Excel file using Workbook.save(string)) method.
The following code sample shows how to copy a row in an Excel worksheet using Java.
Copy Columns in Excel Worksheet using Java
The following are the steps to copy a column in an Excel worksheet using Java.
- First, load the Excel file using Workbook class.
- Get the desired Worksheet from Workbook.getWorksheets() collection.
- Copy desired column by specifying the source and target column index in Worksheet.getCells().copyColumn(Cells, sourceColumnIndex, targetColumnIndex)) method.
- Finally, save the updated Excel file using Workbook.save(string)) method.
The following code sample shows how to copy a column in an Excel worksheet using Java.
Get a Free License
You can use Aspose.Cells for Java without evaluation limitations using a temporary license.
Conclusion
In this article, you have learned how to copy rows and columns in Excel worksheets using Java. Moreover, you can use the provided code samples to copy rows or columns within different Excel workbooks as well. In addition, you can explore the documentation of Aspose.Cells for Java. In case you would have any queries, feel free to post to our forum.