我希望将代码中的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);
}
}
展开