import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import javax.swing.JOptionPane;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFFont;
import org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class Excel_read_write {
public static void exceloy() throws Exception {
int i,x;
int i1,c1;
/// SCHREIBEN
System.out.println(" ");
System.out.println("Lesen");
System.out.println("");
// InputStream file = Excel_read_write.class.getClass().getResourceAsStream("res/excel.xlsx");
FileInputStream file = new FileInputStream("res/excel.xlsx");
XSSFWorkbook workbook1 =new XSSFWorkbook(file);
XSSFSheet sheet = workbook1.getSheetAt(0);
XSSFSheet sheet1 = workbook1.getSheetAt(1);
XSSFSheet sheet2 = workbook1.getSheetAt(2);
XSSFSheet sheet3 = workbook1.getSheetAt(3);
for(i1=3; i1<14+3; i1++){
for(c1=37; c1<31+37; c1++){
if(sheet.getRow(i1+1)!=null){
if(sheet.getRow(i1+1).getCell(c1+1)==null){
XSSFRow r= sheet.getRow(i1+1);
XSSFCell c=r.createCell(c1+1);
c.setCellValue(33);
}else{
XSSFRow row2 = sheet.getRow(i1+1);
XSSFCell cell2 =row2.getCell(c1+1);
cell2.setCellValue(55);
}
}else{
XSSFCell Row2= sheet.createRow(i1+1).createCell(c1+1);
Row2.setCellValue(44);
}
}
XSSFRow row = sheet1.createRow(35);
XSSFCell cellx1= row.createCell(0);
file.close();
try {
XSSFFormulaEvaluator.evaluateAllFormulaCells(workbook1);
FileOutputStream fos = new FileOutputStream(new File ("C:/Neuer Ordner/new_grid.xlsx"));
workbook1.write(fos);
fos.close();
} catch (Exception e) {
e.printStackTrace();
}
}
System.out.println("done");
}
}
