Java Code Examples for com.opencsv.CSVWriter#DEFAULT_QUOTE_CHARACTER

protected void writeCsvDocument(BandData rootBand, OutputStream outputStream) {
    try {
        List<BandData> actualData = getActualData(rootBand);
        CSVWriter writer = new CSVWriter(new OutputStreamWriter(outputStream), separator, CSVWriter.DEFAULT_QUOTE_CHARACTER);

        writer.writeNext(header);

        for (BandData row : actualData) {
            String[] entries = new String[parametersToInsert.size()];
            for (int i = 0; i < parametersToInsert.size(); i++) {
                String parameterName = parametersToInsert.get(i);
                String fullParameterName = row.getName() + "." + parameterName;
                entries[i] = formatValue(row.getData().get(parameterName), parameterName, fullParameterName);
            }
            writer.writeNext(entries);
        }

        writer.close();
    } catch (IOException e) {
        throw new ReportFormattingException("Error while writing a csv document", e);
    }
}
 

CsvExporter(String title, String gradeType, String csvSep) {
    gradesBAOS = new ByteArrayOutputStream();
    OutputStreamWriter osw = new OutputStreamWriter(gradesBAOS, Charset.forName("UTF-8"));
    try {
        osw.write(BOM);
    } catch (IOException e) {
        // tried
    }
    gradesBuffer = new CSVWriter(osw, csvSep.charAt(0), CSVWriter.DEFAULT_QUOTE_CHARACTER, CSVWriter.DEFAULT_ESCAPE_CHARACTER, CSVWriter.RFC4180_LINE_END);
    addRow(title, gradeType);
    addRow("");
}
 

private void csvSpreadsheet(OutputStream os, List<SignupMeetingWrapper> meetingWrappers) throws IOException {
	
	CSVExport export = new CSVExport(meetingWrappers, getSakaiFacade());

	
	CSVWriter writer = new CSVWriter(new OutputStreamWriter(os), ',', CSVWriter.DEFAULT_QUOTE_CHARACTER, CSVWriter.DEFAULT_ESCAPE_CHARACTER, downloadVersion);
	//header
	List<String> header = export.getHeaderRow();
	
	int cols = header.size(); //total number of columns is based on header row
	
	String[] headerRow = new String[cols];
	headerRow = header.toArray(headerRow);
	writer.writeNext(headerRow);
	
	//data rows
	List<List<String>> data = export.getDataRows();
	Iterator<List<String>> iter = data.iterator();
	while(iter.hasNext()) {
		List<String> row = iter.next();
		String[] dataRow = new String[cols];
		dataRow = row.toArray(dataRow);
		writer.writeNext(dataRow);
	}
	
	writer.close();
	
}
 

CsvExporter(String title, String gradeType, String csvSep) {
    gradesBAOS = new ByteArrayOutputStream();
    OutputStreamWriter osw = new OutputStreamWriter(gradesBAOS, Charset.forName("UTF-8"));
    try {
        osw.write(BOM);
    } catch (IOException e) {
        // tried
    }
    gradesBuffer = new CSVWriter(osw, csvSep.charAt(0), CSVWriter.DEFAULT_QUOTE_CHARACTER, CSVWriter.DEFAULT_ESCAPE_CHARACTER, CSVWriter.RFC4180_LINE_END);
    addRow(title, gradeType);
    addRow("");
}
 

private void csvSpreadsheet(OutputStream os, List<SignupMeetingWrapper> meetingWrappers) throws IOException {
	
	CSVExport export = new CSVExport(meetingWrappers, getSakaiFacade());

	
	CSVWriter writer = new CSVWriter(new OutputStreamWriter(os), ',', CSVWriter.DEFAULT_QUOTE_CHARACTER, CSVWriter.DEFAULT_ESCAPE_CHARACTER, downloadVersion);
	//header
	List<String> header = export.getHeaderRow();
	
	int cols = header.size(); //total number of columns is based on header row
	
	String[] headerRow = new String[cols];
	headerRow = header.toArray(headerRow);
	writer.writeNext(headerRow);
	
	//data rows
	List<List<String>> data = export.getDataRows();
	Iterator<List<String>> iter = data.iterator();
	while(iter.hasNext()) {
		List<String> row = iter.next();
		String[] dataRow = new String[cols];
		dataRow = row.toArray(dataRow);
		writer.writeNext(dataRow);
	}
	
	writer.close();
	
}
 

protected void saveXlsxAsCsv(Document document, OutputStream outputStream) throws IOException, Docx4JException {
    CSVWriter writer = new CSVWriter(new OutputStreamWriter(outputStream), ';', CSVWriter.DEFAULT_QUOTE_CHARACTER);

    for (Document.SheetWrapper sheetWrapper : document.getWorksheets()) {
        Worksheet worksheet = sheetWrapper.getWorksheet().getContents();
        for (Row row : worksheet.getSheetData().getRow()) {
            String rows[] = new String[row.getC().size()];
            List<Cell> cells = row.getC();

            boolean emptyRow = true;
            for (int i = 0; i < cells.size(); i++) {
                checkThreadInterrupted();
                Cell cell = cells.get(i);
                String value = cell.getV();
                rows[i] = value;
                if (value != null && !value.isEmpty())
                    emptyRow = false;
            }

            if (!emptyRow)
                writer.writeNext(rows);
        }
    }
    writer.close();
}
 

static int export(Database db, String tableName, Writer csv, boolean withHeader, boolean applyQuotesToAll, String nullText) throws IOException{
	Table table = db.getTable(tableName);
	String[] buffer = new String[table.getColumnCount()];
	CSVWriter writer = new CSVWriter(new BufferedWriter(csv), CSVWriter.DEFAULT_SEPARATOR, CSVWriter.DEFAULT_QUOTE_CHARACTER);
	int rows = 0;
	try{
		if (withHeader) {
			int x = 0;
			for(Column col : table.getColumns()){
				buffer[x++] = col.getName();
			}
			writer.writeNext(buffer, applyQuotesToAll);
		}
           
		for(Row row : table){
			int i = 0;
			for (Object object : row.values()) {
				buffer[i++] = object == null ? nullText : object.toString();
			}
			writer.writeNext(buffer, applyQuotesToAll);
			rows++;
		}
	}finally{
		writer.close();
	}
	return rows;
}
 

protected Boolean doInBackground(final String... args) {
    if (exportDir == null) return false;

    File file = new File(exportDir, appPackageName + ".csv");
    try {
        file.createNewFile();
        CSVWriter csv = new CSVWriter(new FileWriter(file),
                CSVWriter.DEFAULT_SEPARATOR,
                CSVWriter.DEFAULT_QUOTE_CHARACTER,
                CSVWriter.DEFAULT_ESCAPE_CHARACTER,
                CSVWriter.RFC4180_LINE_END);

        Cursor data = trackerList.getAppInfo(appUid);
        if (data == null) return false;

        List<String> columnNames = new ArrayList<>();
        Collections.addAll(columnNames, data.getColumnNames());
        columnNames.add("Tracker Name");
        columnNames.add("Tracker Category");

        csv.writeNext(columnNames.toArray(new String[0]));
        while (data.moveToNext()) {
            String[] row = new String[data.getColumnNames().length + 2];
            for (int i = 0; i < data.getColumnNames().length; i++) {
                row[i] = data.getString(i);
            }

            String hostname = data.getString(data.getColumnIndex("daddr"));
            Tracker tracker = TrackerList.findTracker(hostname);
            if (tracker != null) {
                row[data.getColumnNames().length] = tracker.name;
                row[data.getColumnNames().length + 1] = tracker.category;
            } else {
                row[data.getColumnNames().length] = "";
                row[data.getColumnNames().length + 1] = "";
            }

            csv.writeNext(row);
        }
        csv.close();
        data.close();
    } catch (IOException e) {
        return false;
    }

    return true;
}