java读取excel表头有空格,java实现表格行列数据操作

package com.change;

import java.io.File;

import java.io.IOException;

import jxl.Cell;

import jxl.Sheet;

import jxl.Workbook;

import jxl.read.biff.BiffException;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import jxl.write.WriteException;

import jxl.write.biff.RowsExceededException;

public class Change {

/**excel列转行

* @param n,表示截断excel的多少列为一行即数据数量

*/

public void rowcolumn( String inputfilename , String outputfilename) {

int n;

Workbook wb = null;

WritableSheet ws = null;

http://www.doczj.com/doc/a80efd269b89680202d8255d.htmlbel lable = null ;

WritableWorkbook wwb = null;

//大的第二行的插入行的起始位置

int starth = 0;

int c = 0;

try {

wb = Workbook.getWorkbook(new File(inputfilename));

} catch (BiffException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

if(wb == null)

{

return;

}

Sheet[] sheet = wb.getSheets();//获取工作簿表对象

if(sheet!=null && sheet.length > 0)

{

//创建一个工作簿对象