java中excel导出_java中导出到Excel

我想将两个一维数组导出到Excel中应该怎么执行弄了好久没弄出来指望大神知道一下Xnew排到第一列，Ynew排到第二列数组里面都是纯数字来的奖励不高下网帮帮忙代码如下packagejava12;imp...

我想将两个一维数组导出到Excel中 应该怎么执行 弄了好久 没弄出来 指望大神知道一下 Xnew排到第一列，Ynew排到第二列 数组里面都是纯数字来的 奖励不高 下网帮帮忙代码如下

package java12;

import java.io.*;

import jxl.*;

import jxl.write.*;

import jxl.write.biff.LabelRecord;

import jxl.write.biff.RowsExceededException;

import jxl.format.*;

import java.text.DecimalFormat;

import java.text.SimpleDateFormat;

import java.util.*;

import java.awt.Color;

import jxl.write.Number;

import jxl.write.Boolean;

public class tese {

public static String Xnew[];

public static String Ynew[];

public static void main(String[] args) throws Exception {

Workbook wb = Workbook.getWorkbook(new FileInputStream("D:/test.xls"));

Sheet[] sheets = wb.getSheets();

Sheet sheet = sheets[0];

String[] x = new String[sheet.getRows()];

String[] y = new String[sheet.getRows()];

double X[] = new double [sheet.getRows()];

double Y[] = new double [sheet.getRows()];

List xList = new ArrayList<>();

List yList = new ArrayList<>();

for (int i = 0; i < sheet.getRows(); i++) {

Cell[] cells = sheet.getRow(i);

x[i] = String.valueOf(((NumberCell)cells[0]).getValue());

y[i] = String.valueOf(((NumberCell)cells[1]).getValue());

}

for(int j =0; j

{

X[j]= Double.parseDouble(x[j]);

Y[j]= Double.parseDouble(y[j]);

}

for(int n=1 ;n

{

if((Y[n]>=Y[n-1])&&(Y[n]>Y[n+1])

||(Y[n]<=Y[n-1])&&(Y[n]

||(Y[n]>Y[n-1])&&(Y[n]>=Y[n+1])

||(Y[n]

{

xList.add(x[n]);

yList.add(y[n]);

}

}

E(xList);

F(yList);

}

public static String[] F(List yList) {

Ynew = yList.toArray(new String[yList.size()]);

return Ynew;

}

public static String[] E(List xList) {

// TODO Auto-generated method stub

Xnew = xList.toArray(new String[xList.size()]);

return Xnew;

}

}

展开