导出为excel java_JAva 导出到Excel表中

我希望将代码中的Xnew[]Ynew[]导出到到Excel表中第一列存Xnew数组第二列存Ynew数组[]麻烦各位大神给个代码参考谢谢真的很感激importjava.io.*;importjxl.*;importjxl.write.*;importj...

我希望将代码中的Xnew[] Ynew[]导出到到Excel表中 第一列存Xnew数组 第二列存Ynew数组[] 麻烦各位大神给个代码参考 谢谢 真的很感激

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 double Xnew[];

public double 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]);

}

}

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

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

System.out.println(Xnew.length);

}

}

展开