JAVA POI 直接展现EXCEL成HTML (代码,测试中)
使用POI读取EXCEL中的信息生成HTML
第一个类 ,转换EXCEL颜色
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
1
public class ExcelColorHelper
2![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
{
3
public ExcelColorHelper()
4![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
5
}
6![](/Images/OutliningIndicators/InBlock.gif)
7
public static String getHex(String strHex)
8![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
9
if(strHex.length() > 0)
10![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
11
String[] a = strHex.split(":");
12
strHex = "";
13
for(int n = 0;n < a.length;n++)
14![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
15
if(a[n].length() > 0)
16![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
17
if(a[n].length() < 2)
18![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
19
strHex += "0" + a[n];
20
}
21
else
22![](/Images/OutliningIndicators/InBlock.gif)
23![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
24
strHex += a[n].substring(0,2);
25
}
26
}
27
}
28
}
29
return strHex.length() > 0 ? strHex : null;
30![](/Images/OutliningIndicators/InBlock.gif)
31
}
32![](/Images/OutliningIndicators/InBlock.gif)
33
public static String getHex(HSSFColor c)
34![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
35
return getHex(c == null ? "" : c.getHexString());
36
}
37![](/Images/OutliningIndicators/InBlock.gif)
38
public static String getHex(int nColor)
39![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
40
String strHex = "";
41
if(nColor == HSSFColor.LIGHT_CORNFLOWER_BLUE.index)
42![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
43
strHex = HSSFColor.LIGHT_CORNFLOWER_BLUE.hexString;
44
}
45
if(nColor == HSSFColor.ROYAL_BLUE.index)
46![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
47
strHex = HSSFColor.ROYAL_BLUE.hexString;
48
}
49
if(nColor == HSSFColor.CORAL.index)
50![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
51
strHex = HSSFColor.CORAL.hexString;
52
}
53
if(nColor == HSSFColor.ORCHID.index)
54![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
55
strHex = HSSFColor.ORCHID.hexString;
56
}
57
if(nColor == HSSFColor.MAROON.index)
58![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
59
strHex = HSSFColor.MAROON.hexString;
60
}
61
if(nColor == HSSFColor.LEMON_CHIFFON.index)
62![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
63
strHex = HSSFColor.LEMON_CHIFFON.hexString;
64
}
65
if(nColor == HSSFColor.CORNFLOWER_BLUE.index)
66![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
67
strHex = HSSFColor.CORNFLOWER_BLUE.hexString;
68
}
69
if(nColor == HSSFColor.WHITE.index)
70![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
71
strHex = HSSFColor.WHITE.hexString;
72
}
73
if(nColor == HSSFColor.LAVENDER.index)
74![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
75
strHex = HSSFColor.LAVENDER.hexString;
76
}
77
if(nColor == HSSFColor.PALE_BLUE.index)
78![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
79
strHex = HSSFColor.PALE_BLUE.hexString;
80
}
81
if(nColor == HSSFColor.LIGHT_TURQUOISE.index)
82![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
83
strHex = HSSFColor.LIGHT_TURQUOISE.hexString;
84
}
85
if(nColor == HSSFColor.LIGHT_GREEN.index)
86![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
87
strHex = HSSFColor.LIGHT_GREEN.hexString;
88
}
89
if(nColor == HSSFColor.LIGHT_YELLOW.index)
90![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
91
strHex = HSSFColor.LIGHT_YELLOW.hexString;
92
}
93
if(nColor == HSSFColor.TAN.index)
94![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
95
strHex = HSSFColor.TAN.hexString;
96
}
97
if(nColor == HSSFColor.ROSE.index)
98![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
99
strHex = HSSFColor.ROSE.hexString;
100
}
101
if(nColor == HSSFColor.GREY_25_PERCENT.index)
102![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
103
strHex = HSSFColor.GREY_25_PERCENT.hexString;
104
}
105
if(nColor == HSSFColor.PLUM.index)
106![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
107
strHex = HSSFColor.PLUM.hexString;
108
}
109
if(nColor == HSSFColor.SKY_BLUE.index)
110![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
111
strHex = HSSFColor.SKY_BLUE.hexString;
112
}
113
if(nColor == HSSFColor.TURQUOISE.index)
114![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
115
strHex = HSSFColor.TURQUOISE.hexString;
116
}
117
if(nColor == HSSFColor.BRIGHT_GREEN.index)
118![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
119
strHex = HSSFColor.BRIGHT_GREEN.hexString;
120
}
121
if(nColor == HSSFColor.YELLOW.index)
122![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
123
strHex = HSSFColor.YELLOW.hexString;
124
}
125
if(nColor == HSSFColor.GOLD.index)
126![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
127
strHex = HSSFColor.GOLD.hexString;
128
}
129
if(nColor == HSSFColor.PINK.index)
130![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
131
strHex = HSSFColor.PINK.hexString;
132
}
133
if(nColor == HSSFColor.GREY_40_PERCENT.index)
134![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
135
strHex = HSSFColor.GREY_40_PERCENT.hexString;
136
}
137
if(nColor == HSSFColor.VIOLET.index)
138![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
139
strHex = HSSFColor.VIOLET.hexString;
140
}
141
if(nColor == HSSFColor.LIGHT_BLUE.index)
142![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
143
strHex = HSSFColor.LIGHT_BLUE.hexString;
144
}
145
if(nColor == HSSFColor.AQUA.index)
146![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
147
strHex = HSSFColor.AQUA.hexString;
148
}
149
if(nColor == HSSFColor.SEA_GREEN.index)
150![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
151
strHex = HSSFColor.SEA_GREEN.hexString;
152
}
153
if(nColor == HSSFColor.LIME.index)
154![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
155
strHex = HSSFColor.LIME.hexString;
156
}
157
if(nColor == HSSFColor.LIGHT_ORANGE.index)
158![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
159
strHex = HSSFColor.LIGHT_ORANGE.hexString;
160
}
161
if(nColor == HSSFColor.RED.index)
162![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
163
strHex = HSSFColor.RED.hexString;
164
}
165
if(nColor == HSSFColor.GREY_50_PERCENT.index)
166![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
167
strHex = HSSFColor.GREY_50_PERCENT.hexString;
168
}
169
if(nColor == HSSFColor.BLUE_GREY.index)
170![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
171
strHex = HSSFColor.BLUE_GREY.hexString;
172
}
173
if(nColor == HSSFColor.BLUE.index)
174![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
175
strHex = HSSFColor.BLUE.hexString;
176
}
177
if(nColor == HSSFColor.TEAL.index)
178![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
179
strHex = HSSFColor.TEAL.hexString;
180
}
181
if(nColor == HSSFColor.GREEN.index)
182![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
183
strHex = HSSFColor.GREEN.hexString;
184
}
185
if(nColor == HSSFColor.DARK_YELLOW.index)
186![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
187
strHex = HSSFColor.DARK_YELLOW.hexString;
188
}
189
if(nColor == HSSFColor.ORANGE.index)
190![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
191
strHex = HSSFColor.ORANGE.hexString;
192
}
193
if(nColor == HSSFColor.DARK_RED.index)
194![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
195
strHex = HSSFColor.DARK_RED.hexString;
196
}
197
if(nColor == HSSFColor.GREY_80_PERCENT.index)
198![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
199
strHex = HSSFColor.GREY_80_PERCENT.hexString;
200
}
201
if(nColor == HSSFColor.INDIGO.index)
202![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
203
strHex = HSSFColor.INDIGO.hexString;
204
}
205
if(nColor == HSSFColor.DARK_BLUE.index)
206![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
207
strHex = HSSFColor.DARK_BLUE.hexString;
208
}
209
if(nColor == HSSFColor.DARK_TEAL.index)
210![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
211
strHex = HSSFColor.DARK_TEAL.hexString;
212
}
213
if(nColor == HSSFColor.DARK_GREEN.index)
214![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
215
strHex = HSSFColor.DARK_GREEN.hexString;
216
}
217
if(nColor == HSSFColor.BROWN.index)
218![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
219
strHex = HSSFColor.BROWN.hexString;
220
}
221
if(nColor == HSSFColor.BLACK.index)
222![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
223
strHex = HSSFColor.BLACK.hexString;
224
}
225
return getHex(strHex);
226
}
227![](/Images/OutliningIndicators/InBlock.gif)
228
}第二个类帮助类
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
1
public class ExcelHelper
2![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
{
3
public ExcelHelper()
4![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
5
}
6
public static String convertString2Html(String strMsg)
7![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
8
if(strMsg == null || strMsg.length() < 1)
9![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
10
return "";
11
}
12
String str = "";
13
for(int i = 0;i < strMsg.length();i++)
14![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
15
char c = strMsg.charAt(i);
16
if(c == '\r')
17![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
18
continue;
19
}
20
else if(c == '\n')
21![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
22
str += "<br>";
23
}
24
else if(c == '\t')
25![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
26
str += " ";
27
}
28
else if(c == ' ')
29![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
30
str += " ";
31
}
32
else
33![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
34
str += c;
35
}
36
}
37
return str;
38
}
39![](/Images/OutliningIndicators/InBlock.gif)
40
public static String getCellBackgroundColorInHtml(HSSFWorkbook wb,HSSFCell cell)
41![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
42
if(null == wb || null == cell)
43![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
44
return null;
45
}
46
return getCellBackgroundColorInHtml( wb.getCustomPalette(),cell);
47
}
48
public static String getCellBackgroundColorInHtml(HSSFPalette pa,HSSFCell cell)
49![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
50
if(null == pa || null == cell)
51![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
52
return null;
53
}
54
String cBack = ExcelColorHelper.getHex(pa == null ? null : pa.getColor(cell.getCellStyle().getFillForegroundColor()));
55
if(null == cBack)
56![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
57
cBack = ExcelColorHelper.getHex(pa == null ? null : pa.getColor(cell.getCellStyle().getFillBackgroundColor()));
58
}
59
if(null == cBack)
60![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
61
cBack = ExcelColorHelper.getHex(cell.getCellStyle().getFillBackgroundColor());
62
}
63
return cBack;
64
}
65![](/Images/OutliningIndicators/InBlock.gif)
66
public static int getExcelHeaderColumn(String strColumnHeader)
67![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
68
if(null == strColumnHeader)
69![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
70
return -1;
71
}
72
int nCol = 0;
73
if(strColumnHeader.length() > 1)
74![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
75
nCol = ((int) (strColumnHeader.charAt(0)) - (int) 'a' + 1) * 26 +
76
((int) (strColumnHeader.charAt(1)) - (int) 'a');
77
}
78
else
79![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
80
nCol = (int) (strColumnHeader.charAt(0)) - (int) 'a';
81
}
82
return nCol;
83
}
84
}两个辅助类
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
1
public class ExcelCellValue
2![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
{
3
private int m_nRowID = -1;
4
private int m_nColID =-1;
5
private Object m_objValue=null;
6
public ExcelCellValue(int nRow,int nCell,Object obj)
7![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
8
m_nRowID = nRow;
9
m_nColID = nCell;
10
m_objValue= obj;
11
}
12
public int getRow()
13![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
14
return m_nRowID;
15
}
16
public int getCol()
17![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
18
return m_nColID;
19
}
20
public Object getValue()
21![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
22
return m_objValue;
23
}
24
public boolean isMatch(int nRow,int nCell)
25![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
26
return m_nRowID ==nRow && m_nColID == nCell;
27
}
28
public String toString()
29![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
30
return null == m_objValue?null:m_objValue.toString();
31
}
32
}
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
1
public class ExcelCellValueCollection
2![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
{
3
private java.util.Vector vect =new java.util.Vector();
4
public ExcelCellValueCollection()
5![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
6
}
7
public void clear()
8![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
9
vect.clear();
10
}
11
public int size()
12![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
13
return vect.size();
14
}
15
public void addElement(ExcelCellValue cell)
16![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
17
if(null!=cell)
18![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
19
vect.addElement(cell);
20
}
21
}
22
public void removeElementAt(int nIndex)
23![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
24
vect.removeElementAt(nIndex);
25
}
26
public void insertElementAt(ExcelCellValue cell,int nIndex)
27![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
28
vect.insertElementAt(cell,nIndex);
29
}
30
public ExcelCellValue elementAt(int nIndex)
31![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
32
return (ExcelCellValue)vect.elementAt(nIndex);
33
}
34
public Object getValueAt(int nRow,int nCell)
35![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
36
for(int i =0;i<vect.size();i++)
37![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
38
ExcelCellValue cell =this.elementAt(i);
39
if(null==cell)
40![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
41
continue;
42
}
43
if(cell.isMatch(nRow,nCell))
44![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
45
return cell.getValue();
46
}
47
}
48
return null;
49
}
50![](/Images/OutliningIndicators/InBlock.gif)
51
}
最后主类 ProcessSheet
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
1
public class ExcelToHtml
2![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
{
3
private POIFSFileSystem m_excelFile = null;
4
private HSSFWorkbook m_workBook = null;
5
private HSSFPalette m_palette=null;
6
public ExcelToHtml()
7![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
8
}
9![](/Images/OutliningIndicators/InBlock.gif)
10
public void open(String strFileName)
11
throws Exception
12![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
13
m_excelFile = new POIFSFileSystem(new FileInputStream(strFileName));
14
m_workBook = new HSSFWorkbook(m_excelFile);
15
m_palette = m_workBook.getCustomPalette();
16
}
17
public void close()
18![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
19
m_palette=null;
20
m_workBook=null;
21
m_excelFile=null;
22
}
23
public int getSheetIndexFromName(String strName)
24![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
25
if(null == m_workBook)
26![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
27
return -1;
28
}
29
for(int nSheet = 0; nSheet < m_workBook.getNumberOfSheets();nSheet++)
30![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
31
if( m_workBook.getSheetName(nSheet).equals(strName))
32![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
33
return nSheet;
34
}
35
}
36
return -1;
37
}
38
public int getNumberOfSheets()
39![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
40
return null!=m_workBook?m_workBook.getNumberOfSheets():0;
41
}
42
private String getCellValue(HSSFCell cell)
43![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
44
if(null == cell)
45![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
46
return "";
47
}
48
int nCellType = cell.getCellType();
49
String strValue = "";
50
switch(nCellType)
51![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
52
case HSSFCell.CELL_TYPE_BLANK:
53
strValue = "";
54
break;
55
case HSSFCell.CELL_TYPE_BOOLEAN:
56
strValue = cell.getBooleanCellValue() ? "true" : "false";
57
break;
58
case HSSFCell.CELL_TYPE_ERROR:
59
strValue = "Error :" + cell.getErrorCellValue();
60
break;
61
case HSSFCell.CELL_TYPE_FORMULA:
62
strValue = cell.getCellFormula();
63
break;
64
case HSSFCell.CELL_TYPE_NUMERIC:
65
strValue = get4s5r(cell.getNumericCellValue(),2);
66
break;
67
case HSSFCell.CELL_TYPE_STRING:
68
strValue = cell.getStringCellValue();
69
break;
70
default:
71
strValue = "";
72
}
73![](/Images/OutliningIndicators/InBlock.gif)
74
return strValue;
75
}
76![](/Images/OutliningIndicators/InBlock.gif)
77
public static String get4s5r(double f,long nBase)
78![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
79
nBase = java.lang.Math.round(java.lang.Math.pow(10,nBase));
80
f = java.lang.Math.round(f * nBase);
81
f = f / nBase;
82
if(f == 0)
83![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
84
return "0";
85
}
86
String strBak = java.text.NumberFormat.getInstance().format(f);
87
String str = "";
88
for(int i = 0;i < strBak.length();i++)
89![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
90
if(strBak.charAt(i) != ',')
91![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
92
str += strBak.charAt(i);
93
}
94
}
95
return str;
96
}
97![](/Images/OutliningIndicators/InBlock.gif)
98
private boolean isResideInRegion(HSSFSheet sheet,int nRow,short nCol)
99![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
100
if(sheet == null)
101![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
102
return false;
103
}
104
for(int nM = 0;nM < sheet.getNumMergedRegions();nM++)
105![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
106
Region region = sheet.getMergedRegionAt(nM);
107
if(region.contains(nRow,nCol))
108![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
109
return true;
110
}
111
}
112
return false;
113![](/Images/OutliningIndicators/InBlock.gif)
114
}
115![](/Images/OutliningIndicators/InBlock.gif)
116
private Region getTopRegion(HSSFSheet sheet,int nRow,short nCol)
117![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
118
if(sheet == null)
119![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
120
return null;
121
}
122
for(int nM = 0;nM < sheet.getNumMergedRegions();nM++)
123![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
124
Region region = sheet.getMergedRegionAt(nM);
125
if(region.contains(nRow,nCol))
126![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
127
if(region.getRowFrom() == nRow &&
128
region.getColumnFrom() == nCol)
129![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
130
return region;
131
}
132
}
133
}
134
return null;
135
}
136![](/Images/OutliningIndicators/InBlock.gif)
137
public StringBuffer processSheet(int nSheetIndex,ExcelCellValueCollection cellValues)
138
throws Exception
139![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
140
if(null == m_workBook)
141![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
142
return null;
143
}
144
HSSFSheet sheet = m_workBook.getSheetAt(nSheetIndex);
145
if(null == sheet)
146![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
147
return null;
148
}
149
StringBuffer strRet =new StringBuffer();
150
strRet.append("<table border='1'" +
151
" cellspacing='1'" +
152
" style='border-collapse: collapse'>");
153
for(int nRow = sheet.getFirstRowNum();nRow < sheet.getLastRowNum();nRow++)
154![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
155
HSSFRow row = sheet.getRow(nRow);
156
if(null == row)
157![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
158
continue;
159
}
160
strRet.append( "<tr height='" + row.getHeightInPoints() + "pt'>\n");
161![](/Images/OutliningIndicators/InBlock.gif)
162
for(short nCell = 0;nCell < row.getLastCellNum();nCell++)
163![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
164
HSSFCell cell = row.getCell(nCell);
165
if(cell == null)
166![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
167
continue;
168
}
169
String strColSpanRowSpan = "";
170
//检查Rowspan 和ColSpan
171
Region region = this.getTopRegion(sheet,nRow,nCell);
172
if(null != region)
173![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
174
int nColSpan = region.getColumnTo() - region.getColumnFrom() + 1;
175
int nRowSpan = region.getRowTo() - region.getRowFrom() + 1;
176
strColSpanRowSpan = "";
177
if(nColSpan > 1)
178![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
179
strColSpanRowSpan += " colspan=" + nColSpan;
180
}
181
if(nRowSpan > 1)
182![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
183
strColSpanRowSpan += " rowspan=" + nRowSpan;
184
}
185
}
186
else if(this.isResideInRegion(sheet,nRow,nCell))
187![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
188
continue;
189
}
190
String cBack = ExcelHelper.getCellBackgroundColorInHtml(m_palette,cell);
191
strRet.append( "<td " + strColSpanRowSpan);
192
if(null != cBack)
193![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
194
strRet.append(" bgcolor=#" + cBack);
195
}
196
if(cell.getCellStyle().getAlignment() == HSSFCellStyle.ALIGN_RIGHT)
197![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
198
strRet.append(" align=right");
199
}
200
else if(cell.getCellStyle().getAlignment() == HSSFCellStyle.ALIGN_CENTER)
201![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
202
strRet.append(" align=center");
203
}
204![](/Images/OutliningIndicators/InBlock.gif)
205
String strCellValue = getCellValue(cell);
206
if(null!=cellValues)
207![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
208
Object obj = cellValues.getValueAt(nRow,nCell);
209
if(null!=obj)
210![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
211
strCellValue = obj.toString();
212
}
213
}
214
strCellValue = ExcelHelper.convertString2Html(strCellValue);
215
HSSFFont font = m_workBook.getFontAt(cell.getCellStyle().getFontIndex());
216
if(null != font)
217![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
218
if(font.getBoldweight() == font.BOLDWEIGHT_BOLD)
219![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
220
strCellValue = "<b>" + strCellValue + "</b>";
221
}
222
String cFore = ExcelColorHelper.getHex(font.getColor());
223
if(null == cFore)
224![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
225
cFore = ExcelColorHelper.getHex(m_palette == null ? null :
226
m_palette.getColor(font.getColor()));
227
}
228
if(null != cFore)
229![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
230
strCellValue = "<font style='font-size:" + font.getFontHeightInPoints() + "pt' face='" + font.getFontName() + "' color=#" + cFore + ">" + strCellValue + "</font>";
231
}
232
}
233
strRet.append( ">");
234
strRet.append( strCellValue + "</td>");
235
}
236
strRet.append( "\n");
237
}
238
strRet.append("</tr>\n");
239
strRet.append("</table>");
240
return strRet;
241
}
242![](/Images/OutliningIndicators/InBlock.gif)
243
public static void main(String[] strargvs)
244
throws Exception
245![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
246
ExcelToHtml excel = new ExcelToHtml();
247
excel.open("d:\\jituan1231.xls");
248
}
249
}
没有解决问题:
EXCEL隐藏列问题
EXCEL列宽问题
第一个类 ,转换EXCEL颜色
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
1
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
5
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/InBlock.gif)
8
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
17
![](/Images/OutliningIndicators/InBlock.gif)
18
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
19
![](/Images/OutliningIndicators/InBlock.gif)
20
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
26
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
27
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
28
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
29
![](/Images/OutliningIndicators/InBlock.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
32
![](/Images/OutliningIndicators/InBlock.gif)
33
![](/Images/OutliningIndicators/InBlock.gif)
34
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
35
![](/Images/OutliningIndicators/InBlock.gif)
36
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
37
![](/Images/OutliningIndicators/InBlock.gif)
38
![](/Images/OutliningIndicators/InBlock.gif)
39
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
40
![](/Images/OutliningIndicators/InBlock.gif)
41
![](/Images/OutliningIndicators/InBlock.gif)
42
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
43
![](/Images/OutliningIndicators/InBlock.gif)
44
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
45
![](/Images/OutliningIndicators/InBlock.gif)
46
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
47
![](/Images/OutliningIndicators/InBlock.gif)
48
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
49
![](/Images/OutliningIndicators/InBlock.gif)
50
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
51
![](/Images/OutliningIndicators/InBlock.gif)
52
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
53
![](/Images/OutliningIndicators/InBlock.gif)
54
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
55
![](/Images/OutliningIndicators/InBlock.gif)
56
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
57
![](/Images/OutliningIndicators/InBlock.gif)
58
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
59
![](/Images/OutliningIndicators/InBlock.gif)
60
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
61
![](/Images/OutliningIndicators/InBlock.gif)
62
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
63
![](/Images/OutliningIndicators/InBlock.gif)
64
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
65
![](/Images/OutliningIndicators/InBlock.gif)
66
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
67
![](/Images/OutliningIndicators/InBlock.gif)
68
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
69
![](/Images/OutliningIndicators/InBlock.gif)
70
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
71
![](/Images/OutliningIndicators/InBlock.gif)
72
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
73
![](/Images/OutliningIndicators/InBlock.gif)
74
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
75
![](/Images/OutliningIndicators/InBlock.gif)
76
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
77
![](/Images/OutliningIndicators/InBlock.gif)
78
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
79
![](/Images/OutliningIndicators/InBlock.gif)
80
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
81
![](/Images/OutliningIndicators/InBlock.gif)
82
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
83
![](/Images/OutliningIndicators/InBlock.gif)
84
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
85
![](/Images/OutliningIndicators/InBlock.gif)
86
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
87
![](/Images/OutliningIndicators/InBlock.gif)
88
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
89
![](/Images/OutliningIndicators/InBlock.gif)
90
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
91
![](/Images/OutliningIndicators/InBlock.gif)
92
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
93
![](/Images/OutliningIndicators/InBlock.gif)
94
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
95
![](/Images/OutliningIndicators/InBlock.gif)
96
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
97
![](/Images/OutliningIndicators/InBlock.gif)
98
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
99
![](/Images/OutliningIndicators/InBlock.gif)
100
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
101
![](/Images/OutliningIndicators/InBlock.gif)
102
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
103
![](/Images/OutliningIndicators/InBlock.gif)
104
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
105
![](/Images/OutliningIndicators/InBlock.gif)
106
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
107
![](/Images/OutliningIndicators/InBlock.gif)
108
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
109
![](/Images/OutliningIndicators/InBlock.gif)
110
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
111
![](/Images/OutliningIndicators/InBlock.gif)
112
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
113
![](/Images/OutliningIndicators/InBlock.gif)
114
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
115
![](/Images/OutliningIndicators/InBlock.gif)
116
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
117
![](/Images/OutliningIndicators/InBlock.gif)
118
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
119
![](/Images/OutliningIndicators/InBlock.gif)
120
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
121
![](/Images/OutliningIndicators/InBlock.gif)
122
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
123
![](/Images/OutliningIndicators/InBlock.gif)
124
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
125
![](/Images/OutliningIndicators/InBlock.gif)
126
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
127
![](/Images/OutliningIndicators/InBlock.gif)
128
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
129
![](/Images/OutliningIndicators/InBlock.gif)
130
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
131
![](/Images/OutliningIndicators/InBlock.gif)
132
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
133
![](/Images/OutliningIndicators/InBlock.gif)
134
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
135
![](/Images/OutliningIndicators/InBlock.gif)
136
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
137
![](/Images/OutliningIndicators/InBlock.gif)
138
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
139
![](/Images/OutliningIndicators/InBlock.gif)
140
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
141
![](/Images/OutliningIndicators/InBlock.gif)
142
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
143
![](/Images/OutliningIndicators/InBlock.gif)
144
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
145
![](/Images/OutliningIndicators/InBlock.gif)
146
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
147
![](/Images/OutliningIndicators/InBlock.gif)
148
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
149
![](/Images/OutliningIndicators/InBlock.gif)
150
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
151
![](/Images/OutliningIndicators/InBlock.gif)
152
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
153
![](/Images/OutliningIndicators/InBlock.gif)
154
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
155
![](/Images/OutliningIndicators/InBlock.gif)
156
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
157
![](/Images/OutliningIndicators/InBlock.gif)
158
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
159
![](/Images/OutliningIndicators/InBlock.gif)
160
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
161
![](/Images/OutliningIndicators/InBlock.gif)
162
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
163
![](/Images/OutliningIndicators/InBlock.gif)
164
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
165
![](/Images/OutliningIndicators/InBlock.gif)
166
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
167
![](/Images/OutliningIndicators/InBlock.gif)
168
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
169
![](/Images/OutliningIndicators/InBlock.gif)
170
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
171
![](/Images/OutliningIndicators/InBlock.gif)
172
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
173
![](/Images/OutliningIndicators/InBlock.gif)
174
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
175
![](/Images/OutliningIndicators/InBlock.gif)
176
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
177
![](/Images/OutliningIndicators/InBlock.gif)
178
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
179
![](/Images/OutliningIndicators/InBlock.gif)
180
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
181
![](/Images/OutliningIndicators/InBlock.gif)
182
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
183
![](/Images/OutliningIndicators/InBlock.gif)
184
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
185
![](/Images/OutliningIndicators/InBlock.gif)
186
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
187
![](/Images/OutliningIndicators/InBlock.gif)
188
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
189
![](/Images/OutliningIndicators/InBlock.gif)
190
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
191
![](/Images/OutliningIndicators/InBlock.gif)
192
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
193
![](/Images/OutliningIndicators/InBlock.gif)
194
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
195
![](/Images/OutliningIndicators/InBlock.gif)
196
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
197
![](/Images/OutliningIndicators/InBlock.gif)
198
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
199
![](/Images/OutliningIndicators/InBlock.gif)
200
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
201
![](/Images/OutliningIndicators/InBlock.gif)
202
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
203
![](/Images/OutliningIndicators/InBlock.gif)
204
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
205
![](/Images/OutliningIndicators/InBlock.gif)
206
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
207
![](/Images/OutliningIndicators/InBlock.gif)
208
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
209
![](/Images/OutliningIndicators/InBlock.gif)
210
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
211
![](/Images/OutliningIndicators/InBlock.gif)
212
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
213
![](/Images/OutliningIndicators/InBlock.gif)
214
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
215
![](/Images/OutliningIndicators/InBlock.gif)
216
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
217
![](/Images/OutliningIndicators/InBlock.gif)
218
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
219
![](/Images/OutliningIndicators/InBlock.gif)
220
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
221
![](/Images/OutliningIndicators/InBlock.gif)
222
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
223
![](/Images/OutliningIndicators/InBlock.gif)
224
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
225
![](/Images/OutliningIndicators/InBlock.gif)
226
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
227
![](/Images/OutliningIndicators/InBlock.gif)
228
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
1
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
5
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
17
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
32
![](/Images/OutliningIndicators/InBlock.gif)
33
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
34
![](/Images/OutliningIndicators/InBlock.gif)
35
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
36
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
37
![](/Images/OutliningIndicators/InBlock.gif)
38
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
39
![](/Images/OutliningIndicators/InBlock.gif)
40
![](/Images/OutliningIndicators/InBlock.gif)
41
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
42
![](/Images/OutliningIndicators/InBlock.gif)
43
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
44
![](/Images/OutliningIndicators/InBlock.gif)
45
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
46
![](/Images/OutliningIndicators/InBlock.gif)
47
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
48
![](/Images/OutliningIndicators/InBlock.gif)
49
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
50
![](/Images/OutliningIndicators/InBlock.gif)
51
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
52
![](/Images/OutliningIndicators/InBlock.gif)
53
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
54
![](/Images/OutliningIndicators/InBlock.gif)
55
![](/Images/OutliningIndicators/InBlock.gif)
56
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
57
![](/Images/OutliningIndicators/InBlock.gif)
58
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
59
![](/Images/OutliningIndicators/InBlock.gif)
60
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
61
![](/Images/OutliningIndicators/InBlock.gif)
62
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
63
![](/Images/OutliningIndicators/InBlock.gif)
64
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
65
![](/Images/OutliningIndicators/InBlock.gif)
66
![](/Images/OutliningIndicators/InBlock.gif)
67
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
68
![](/Images/OutliningIndicators/InBlock.gif)
69
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
70
![](/Images/OutliningIndicators/InBlock.gif)
71
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
72
![](/Images/OutliningIndicators/InBlock.gif)
73
![](/Images/OutliningIndicators/InBlock.gif)
74
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
75
![](/Images/OutliningIndicators/InBlock.gif)
76
![](/Images/OutliningIndicators/InBlock.gif)
77
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
78
![](/Images/OutliningIndicators/InBlock.gif)
79
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
80
![](/Images/OutliningIndicators/InBlock.gif)
81
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
82
![](/Images/OutliningIndicators/InBlock.gif)
83
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
84
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
1
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/InBlock.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
14
![](/Images/OutliningIndicators/InBlock.gif)
15
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
17
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
32
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
1
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/InBlock.gif)
5
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
6
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
7
![](/Images/OutliningIndicators/InBlock.gif)
8
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
17
![](/Images/OutliningIndicators/InBlock.gif)
18
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
19
![](/Images/OutliningIndicators/InBlock.gif)
20
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
21
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
32
![](/Images/OutliningIndicators/InBlock.gif)
33
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
34
![](/Images/OutliningIndicators/InBlock.gif)
35
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
36
![](/Images/OutliningIndicators/InBlock.gif)
37
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
38
![](/Images/OutliningIndicators/InBlock.gif)
39
![](/Images/OutliningIndicators/InBlock.gif)
40
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
41
![](/Images/OutliningIndicators/InBlock.gif)
42
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
43
![](/Images/OutliningIndicators/InBlock.gif)
44
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
45
![](/Images/OutliningIndicators/InBlock.gif)
46
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
47
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
48
![](/Images/OutliningIndicators/InBlock.gif)
49
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
50
![](/Images/OutliningIndicators/InBlock.gif)
51
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
最后主类 ProcessSheet
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
1
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/InBlock.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
8
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/InBlock.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
17
![](/Images/OutliningIndicators/InBlock.gif)
18
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
19
![](/Images/OutliningIndicators/InBlock.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
23
![](/Images/OutliningIndicators/InBlock.gif)
24
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
25
![](/Images/OutliningIndicators/InBlock.gif)
26
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
27
![](/Images/OutliningIndicators/InBlock.gif)
28
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
29
![](/Images/OutliningIndicators/InBlock.gif)
30
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
31
![](/Images/OutliningIndicators/InBlock.gif)
32
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
33
![](/Images/OutliningIndicators/InBlock.gif)
34
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
35
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
36
![](/Images/OutliningIndicators/InBlock.gif)
37
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
38
![](/Images/OutliningIndicators/InBlock.gif)
39
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
40
![](/Images/OutliningIndicators/InBlock.gif)
41
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
42
![](/Images/OutliningIndicators/InBlock.gif)
43
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
44
![](/Images/OutliningIndicators/InBlock.gif)
45
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
46
![](/Images/OutliningIndicators/InBlock.gif)
47
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
48
![](/Images/OutliningIndicators/InBlock.gif)
49
![](/Images/OutliningIndicators/InBlock.gif)
50
![](/Images/OutliningIndicators/InBlock.gif)
51
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
52
![](/Images/OutliningIndicators/InBlock.gif)
53
![](/Images/OutliningIndicators/InBlock.gif)
54
![](/Images/OutliningIndicators/InBlock.gif)
55
![](/Images/OutliningIndicators/InBlock.gif)
56
![](/Images/OutliningIndicators/InBlock.gif)
57
![](/Images/OutliningIndicators/InBlock.gif)
58
![](/Images/OutliningIndicators/InBlock.gif)
59
![](/Images/OutliningIndicators/InBlock.gif)
60
![](/Images/OutliningIndicators/InBlock.gif)
61
![](/Images/OutliningIndicators/InBlock.gif)
62
![](/Images/OutliningIndicators/InBlock.gif)
63
![](/Images/OutliningIndicators/InBlock.gif)
64
![](/Images/OutliningIndicators/InBlock.gif)
65
![](/Images/OutliningIndicators/InBlock.gif)
66
![](/Images/OutliningIndicators/InBlock.gif)
67
![](/Images/OutliningIndicators/InBlock.gif)
68
![](/Images/OutliningIndicators/InBlock.gif)
69
![](/Images/OutliningIndicators/InBlock.gif)
70
![](/Images/OutliningIndicators/InBlock.gif)
71
![](/Images/OutliningIndicators/InBlock.gif)
72
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
73
![](/Images/OutliningIndicators/InBlock.gif)
74
![](/Images/OutliningIndicators/InBlock.gif)
75
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
76
![](/Images/OutliningIndicators/InBlock.gif)
77
![](/Images/OutliningIndicators/InBlock.gif)
78
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
79
![](/Images/OutliningIndicators/InBlock.gif)
80
![](/Images/OutliningIndicators/InBlock.gif)
81
![](/Images/OutliningIndicators/InBlock.gif)
82
![](/Images/OutliningIndicators/InBlock.gif)
83
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
84
![](/Images/OutliningIndicators/InBlock.gif)
85
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
86
![](/Images/OutliningIndicators/InBlock.gif)
87
![](/Images/OutliningIndicators/InBlock.gif)
88
![](/Images/OutliningIndicators/InBlock.gif)
89
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
90
![](/Images/OutliningIndicators/InBlock.gif)
91
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
92
![](/Images/OutliningIndicators/InBlock.gif)
93
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
94
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
95
![](/Images/OutliningIndicators/InBlock.gif)
96
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
97
![](/Images/OutliningIndicators/InBlock.gif)
98
![](/Images/OutliningIndicators/InBlock.gif)
99
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
100
![](/Images/OutliningIndicators/InBlock.gif)
101
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
102
![](/Images/OutliningIndicators/InBlock.gif)
103
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
104
![](/Images/OutliningIndicators/InBlock.gif)
105
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
106
![](/Images/OutliningIndicators/InBlock.gif)
107
![](/Images/OutliningIndicators/InBlock.gif)
108
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
109
![](/Images/OutliningIndicators/InBlock.gif)
110
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
111
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
112
![](/Images/OutliningIndicators/InBlock.gif)
113
![](/Images/OutliningIndicators/InBlock.gif)
114
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
115
![](/Images/OutliningIndicators/InBlock.gif)
116
![](/Images/OutliningIndicators/InBlock.gif)
117
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
118
![](/Images/OutliningIndicators/InBlock.gif)
119
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
120
![](/Images/OutliningIndicators/InBlock.gif)
121
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
122
![](/Images/OutliningIndicators/InBlock.gif)
123
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
124
![](/Images/OutliningIndicators/InBlock.gif)
125
![](/Images/OutliningIndicators/InBlock.gif)
126
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
127
![](/Images/OutliningIndicators/InBlock.gif)
128
![](/Images/OutliningIndicators/InBlock.gif)
129
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
130
![](/Images/OutliningIndicators/InBlock.gif)
131
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
132
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
133
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
134
![](/Images/OutliningIndicators/InBlock.gif)
135
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
136
![](/Images/OutliningIndicators/InBlock.gif)
137
![](/Images/OutliningIndicators/InBlock.gif)
138
![](/Images/OutliningIndicators/InBlock.gif)
139
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
140
![](/Images/OutliningIndicators/InBlock.gif)
141
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
142
![](/Images/OutliningIndicators/InBlock.gif)
143
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
144
![](/Images/OutliningIndicators/InBlock.gif)
145
![](/Images/OutliningIndicators/InBlock.gif)
146
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
147
![](/Images/OutliningIndicators/InBlock.gif)
148
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
149
![](/Images/OutliningIndicators/InBlock.gif)
150
![](/Images/OutliningIndicators/InBlock.gif)
151
![](/Images/OutliningIndicators/InBlock.gif)
152
![](/Images/OutliningIndicators/InBlock.gif)
153
![](/Images/OutliningIndicators/InBlock.gif)
154
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
155
![](/Images/OutliningIndicators/InBlock.gif)
156
![](/Images/OutliningIndicators/InBlock.gif)
157
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
158
![](/Images/OutliningIndicators/InBlock.gif)
159
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
160
![](/Images/OutliningIndicators/InBlock.gif)
161
![](/Images/OutliningIndicators/InBlock.gif)
162
![](/Images/OutliningIndicators/InBlock.gif)
163
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
164
![](/Images/OutliningIndicators/InBlock.gif)
165
![](/Images/OutliningIndicators/InBlock.gif)
166
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
167
![](/Images/OutliningIndicators/InBlock.gif)
168
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
169
![](/Images/OutliningIndicators/InBlock.gif)
170
![](/Images/OutliningIndicators/InBlock.gif)
171
![](/Images/OutliningIndicators/InBlock.gif)
172
![](/Images/OutliningIndicators/InBlock.gif)
173
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
174
![](/Images/OutliningIndicators/InBlock.gif)
175
![](/Images/OutliningIndicators/InBlock.gif)
176
![](/Images/OutliningIndicators/InBlock.gif)
177
![](/Images/OutliningIndicators/InBlock.gif)
178
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
179
![](/Images/OutliningIndicators/InBlock.gif)
180
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
181
![](/Images/OutliningIndicators/InBlock.gif)
182
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
183
![](/Images/OutliningIndicators/InBlock.gif)
184
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
185
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
186
![](/Images/OutliningIndicators/InBlock.gif)
187
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
188
![](/Images/OutliningIndicators/InBlock.gif)
189
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
190
![](/Images/OutliningIndicators/InBlock.gif)
191
![](/Images/OutliningIndicators/InBlock.gif)
192
![](/Images/OutliningIndicators/InBlock.gif)
193
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
194
![](/Images/OutliningIndicators/InBlock.gif)
195
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
196
![](/Images/OutliningIndicators/InBlock.gif)
197
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
198
![](/Images/OutliningIndicators/InBlock.gif)
199
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
200
![](/Images/OutliningIndicators/InBlock.gif)
201
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
202
![](/Images/OutliningIndicators/InBlock.gif)
203
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
204
![](/Images/OutliningIndicators/InBlock.gif)
205
![](/Images/OutliningIndicators/InBlock.gif)
206
![](/Images/OutliningIndicators/InBlock.gif)
207
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
208
![](/Images/OutliningIndicators/InBlock.gif)
209
![](/Images/OutliningIndicators/InBlock.gif)
210
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
211
![](/Images/OutliningIndicators/InBlock.gif)
212
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
213
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
214
![](/Images/OutliningIndicators/InBlock.gif)
215
![](/Images/OutliningIndicators/InBlock.gif)
216
![](/Images/OutliningIndicators/InBlock.gif)
217
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
218
![](/Images/OutliningIndicators/InBlock.gif)
219
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
220
![](/Images/OutliningIndicators/InBlock.gif)
221
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
222
![](/Images/OutliningIndicators/InBlock.gif)
223
![](/Images/OutliningIndicators/InBlock.gif)
224
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
225
![](/Images/OutliningIndicators/InBlock.gif)
226
![](/Images/OutliningIndicators/InBlock.gif)
227
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
228
![](/Images/OutliningIndicators/InBlock.gif)
229
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
230
![](/Images/OutliningIndicators/InBlock.gif)
231
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
232
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
233
![](/Images/OutliningIndicators/InBlock.gif)
234
![](/Images/OutliningIndicators/InBlock.gif)
235
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
236
![](/Images/OutliningIndicators/InBlock.gif)
237
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
238
![](/Images/OutliningIndicators/InBlock.gif)
239
![](/Images/OutliningIndicators/InBlock.gif)
240
![](/Images/OutliningIndicators/InBlock.gif)
241
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
242
![](/Images/OutliningIndicators/InBlock.gif)
243
![](/Images/OutliningIndicators/InBlock.gif)
244
![](/Images/OutliningIndicators/InBlock.gif)
245
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
246
![](/Images/OutliningIndicators/InBlock.gif)
247
![](/Images/OutliningIndicators/InBlock.gif)
248
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
249
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
没有解决问题:
EXCEL隐藏列问题
EXCEL列宽问题