如何在所有拆分的CSV文件中存储头？

Question

import java.io.*;
import java.util.Scanner;
import java.io.File;
import java.io.FileInputStream;
import java.util.Iterator;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class split {

    public static void main(String args[]) {
        try {
            String inputfile = "E:/Sumit/csv-splitting-2/Proposal_Details__c.csv";
            System.out.println("Input Path is :- " + inputfile);
            
            double nol = 100000.0;
            
            File file = new File(inputfile);
            Scanner scanner = new Scanner(file);
            
            int count = 0;
            while (scanner.hasNextLine()) {
                scanner.nextLine();
                count++;
            }
            System.out.println("Lines in the file: " + count);

            double temp = (count / nol);
            int temp1 = (int) temp;
            int nof = 0;
            if (temp1 == temp) {
                nof = temp1;
            } else {
                nof = temp1 + 1;
            }
            System.out.println("No. of files to be generated :" + nof);

            FileInputStream fstream = new FileInputStream(inputfile);
            DataInputStream in = new DataInputStream(fstream);

            BufferedReader br = new BufferedReader(new InputStreamReader(in));
            String strLine;

            for (int j = 1; j <= nof; j++) {
                String outputpath = "E:/Sumit/csv-splitting-2/";
                String outputfile = "File-2-Proposal_Details__c" + j + ".csv";

                System.out.println(outputpath + outputfile);
                FileWriter fstream1 = new FileWriter(outputpath + outputfile);

                BufferedWriter out = new BufferedWriter(fstream1);
                for (int i = 1; i <= nol; i++) {
                    strLine = br.readLine();
                    if (strLine != null) {
                        out.write(strLine);
                        if (i != nol) {
                            out.newLine();
                        }
                    }
                }
                out.close();
            }
            in.close();
        } catch (Exception e) {
            System.err.println("Error: " + e.getMessage());
        }
    }
} 

Answer 1

假设您的第一行是头，您可以有一个字符串头；来获取第一行的读数，例如:header=br.readline()；。

在nof（我假定这意味着number_of_files)的for循环中，创建新文件时总是将头作为第一行添加。

应该是这样的：

null

null

null