In Excel, we often need to copy data from some worksheets to another worksheet. For example, we need to summarize the students ' scores from different worksheets to a new worksheet, and the number of references and the order of the worksheets are not identical, and they cannot be copied and pasted directly. At this point, if you use Excel's VLOOKUP, index, or offset functions, you can make the problem very simple. Let's take
use poi to read The data instances of version and above : Publiclist Test instance: @Test publicvoidtestreadexcel () { try{List use poi to read An instance of the 2003 version of Excel data Publiclist The test data is the same as before: Reference Articles ; http://www.cnblogs.com/hongten/p/java_poi_excel_xls_xlsx.html Work history: Import data from Excel using POI (Version 2003,
Read Excel data with Java Custom jar package support excel2007 and excel2003Download the required packages in http://download.csdn.net/detail/u010792467/8079355If you need excel2003 and excel2007 files you can go tohttp://download.csdn.net/detail/u010792467/8072009 DownloadDownload Project in http://download.csdn.net/detail/u010792467/8079345Example of custom jar package applicationCustom jar Package Source codeLost Jian fileReprint Please specify lin
After data entry in Excel, we typically use advanced filtering to handle deleting duplicate records, and Excel 2007 retains this feature while adding a "Remove duplicates" button to make the operation simpler and more flexible.
First, traditional methods: using advanced filtering
The steps are as follows:
1. Click the data area to select any one of the cells.
In the weeks, excel in the collection of a large number of information, often there will be some duplication of data, can not find these duplicate data, can not be deleted and other operations.
With Excel 2007, you can easily find these duplicate data.
For example, the following table of data, to find a part of the duplicate data, the operation is as follows:
Label:Page section Entity class section Public Class test{ Private String ID; private String name; Private String address; The following is the Get, set method (omitted) } Action section Get file by strusts2 private file file;Private String FileName;Private String Filecontenttype; Add a Get, set method Get Workbook Object Xssfworkbook WorkBook = new Xssfworkbook (File.getinputstream ()); define Worksheet Xssfsheet workSheet = null; Defines the data obtained from
Nonsense less say directly on the code, remember is poi3.8 version AH. The method entry is unique, automatically determines the format, uses the interface reference, and automatically chooses the execution method.Method Entry:public static arraylistarraylistWorkbook wb = null;try {WB = Get2003workbook (new FileInputStream (FileName));if (WB = = null) {WB = Get2007workbook (new FileInputStream (FileName));if (WB = = null) {throw new RuntimeException ("Unrecognized format, unexpected
To resolve this issue, after you apply the filter, save the workbook, and then close and reopen the workbook.
In addition, instead of selecting a range header, turn on AutoFilter, select the entire range or any cell within that range, and then turn on AutoFilter.
To apply a filter on an Excel 2007 worksheet, do the following:
1. Click Sort and filter in the Edit group on the Start Page tab.
2. Click Fil
When you use Excel to handle large amounts of data, you often encounter duplicate data, although we carefully and carefully check, but errors are unavoidable. This problem can be easily solved in Excel 2007.
1, data input to avoid duplication
In entering the student number, ID number and other data, we can be resolved by the following methods:
(1) First select
There are times when we need to do an interval summation of Excel 2007 worksheet data. If the work table format is not allowed or inconvenient to adjust, then how to smoothly and easily get the data we need?
This question is actually very simple. Many people who have just come in contact with Excel can also do it. Take the worksheet shown in Figure 1 as an
Solution:A chart is created in Excel 2007. How can I add an ordinate axis to the right of the chart?Click the data series for which you want to display the ordinate axis. In this example, click the blue bar chart that displays the average temperature. On the format tab, click set content format.The set Data Series Format dialog box is displayed.In the series options, locate the series draw option, select th
In Excel 2007, the AverageIf, AverageIfs, Sumifs, Countifs, and iferror Five functions are added, which can be calculated on a per-condition basis within a certain range. In particular, multiple conditional function averageifs, countifs and sumifs to our work has brought great convenience, such as in the grade of the total score table to calculate the average score of each class, passing rate and excellent
Click the Excel 2007 chart, or select the chart element for which you want to change the layout.
How to select a chart element from a list of chart elements
Click the chart to display the chart tools.
On the Format tab, in the current selection group, click the arrow next to the Chart elements box, and then select the chart element that you want.
Tip This displays the chart tool and adds the desi
In some of the more complex Excel2007 datasheets, we might want to be aware of the data changes in some of the cells in Excel 2007 at any time. For example, see changes in the total number of sales in different regions, or at the same time to see the distribution of different worksheets in the attendance, overtime, bonuses and other data. If it's a hassle to repeat the lookup every time, we use Excel2007 's
The Office2007 interface is quite different from previous versions, and the biggest change is the use of the Ribbon (Ribbon) instead of menus and toolbars from previous versions.
Today we detail the Excel 2007 Ribbon (Ribbon).
I. Overview of EXCEL 2007 Functional Area (Ribbon)
The following figure is the interface o
crosstab chart of the construction progress shown in 1.
Figure 1
1. Create a chart
Step 1: Start Excel 2007 and enter the construction progress data in a worksheet, as shown in 2.
Figure 2
Step 2: select the A2: C14 cell area and create a chart with the "bar chart-stacked bar chart" type, as shown in 3.
Figure 3
2. format the chart
Step 1: In the chart, click the "Start Date" series chart, select it, ri
Because of the job requirements, some Excel 2007 worksheets we don't want people who participate in data entry to see that the general hidden worksheet is done by clicking the "format → visibility → hide and unhide → hidden sheets" series of actions. But the level of this approach is a bit too simple to deal with "rookie". If someone follows the steps above and chooses the Unhide sheet option, the hidden fi
In Excel 2007 , you can use predefined border styles to make two or more cells in a cell or range of cells Range: a worksheet. Cells in a range can be contiguous or nonadjacent. To quickly add a border around it.
1. On the worksheet, select the cell or range of cells that you want to add a border to, change the border style, or delete a border.
tip to deselect a range of cells, click any cell in the w
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.