Package au.com.bytecode.opencsv

Examples of au.com.bytecode.opencsv.CSVWriter


      }
    };
  }

  public static void metadataToCsv(Metadata metadata, OutputStream outputStream) throws IOException {
    CSVWriter writer = new CSVWriter(new OutputStreamWriter(outputStream, "UTF-8"));

    for (String name : metadata.names()) {
      String[] values = metadata.getValues(name);
      ArrayList<String> list = new ArrayList<String>(values.length+1);
      list.add(name);
      list.addAll(Arrays.asList(values));
      writer.writeNext(list.toArray(values));
    }

    writer.close();
  }
View Full Code Here


   * Little util to parse swaption tickers into a csv for further analysis.
   * @param args command line params
   */
  public static void main(String[] args) {  // CSIGNORE
    CSVReader csvReader = null;
    CSVWriter csvWriter = null;
    try {
      csvReader = new CSVReader(new BufferedReader(new FileReader(args[0])));
      csvWriter = new CSVWriter(new BufferedWriter(new FileWriter(args[1])));
      String[] line;
      Pattern pattern = Pattern.compile("^(\\w\\w\\w).*?(\\d+)(M|Y)(\\d+)(M|Y)\\s*?(PY|RC)\\s*?(.*)$");
      BloombergReferenceDataProvider rawBbgRefDataProvider = getBloombergSecurityFileLoader();
      MongoDBValueCachingReferenceDataProvider bbgRefDataProvider = MongoCachedReferenceData.makeMongoProvider(rawBbgRefDataProvider, BloombergSwaptionFileLoader.class);
      while ((line = csvReader.readNext()) != null) {
        String name = line[NAME_FIELD];
        Matcher matcher = pattern.matcher(name);
        if (matcher.matches()) {
          String ccy = matcher.group(1);
          String swapTenorSize = matcher.group(2);
          String swapTenorUnit = matcher.group(3);
          String optionTenorSize = matcher.group(4);
          String optionTenorUnit = matcher.group(5);
          String payReceive = matcher.group(6);
          String distanceATM = matcher.group(7);
         
          String buid = "/buid/" + line[BUID_FIELD];
          String value = bbgRefDataProvider.getReferenceDataValue(buid, "TICKER");
          csvWriter.writeNext(new String[] {name, ccy, swapTenorSize, swapTenorUnit, optionTenorSize, optionTenorUnit, payReceive, distanceATM, value });
        } else {
          s_logger.error("Couldn't parse " + name + " field");
        }
       
      }
View Full Code Here

    // Open file
    OutputStream fileOutputStream = openFile(filename);

    // Set up CSV Writer
    _csvWriter = new CSVWriter(new OutputStreamWriter(fileOutputStream));
   
    // Set columns
    setColumns(columns);
   
    // Write the column row
View Full Code Here

   
    ArgumentChecker.notNull(outputStream, "outputStream");
    ArgumentChecker.notNull(columns, "columns");

    // Set up CSV Writer
    _csvWriter = new CSVWriter(new OutputStreamWriter(outputStream));
   
    // Set columns
    setColumns(columns);
   
    // Write the column row
View Full Code Here

@Scriptable
public class SecurityFieldMappingTemplateGenerator extends AbstractTool<ToolContext> {
  private static final Logger s_logger = LoggerFactory.getLogger(SecurityFieldMappingTemplateGenerator.class);
  @Override
  protected void doRun() throws Exception {
    CSVWriter csvWriter = new CSVWriter(new FileWriter(getCommandLine().getArgs()[0]));
    SecurityMaster securityMaster = getToolContext().getSecurityMaster();
    SecurityMetaDataRequest metaRequest = new SecurityMetaDataRequest();
    SecurityMetaDataResult metaData = securityMaster.metaData(metaRequest);
    for (String securityType : metaData.getSecurityTypes()) {
      s_logger.info("Processing security type " + securityType);
      SecuritySearchRequest searchRequest = new SecuritySearchRequest();
      searchRequest.setName("*");
      searchRequest.setSecurityType(securityType);
      searchRequest.setPagingRequest(PagingRequest.ONE);
      SecuritySearchResult search = securityMaster.search(searchRequest);
      s_logger.info("Search returned " + search.getPaging().getTotalItems() + " securities");
      dumpSecurityStructure(csvWriter, securityType, search.getFirstSecurity());
    }
    csvWriter.close();
  }
View Full Code Here

    for (GridColumn gridColumn : columns) {
      header2[index++] = gridColumn.getHeader();
    }
   
    StringWriter stringWriter = new StringWriter();
    @SuppressWarnings("resource")
    CSVWriter csvWriter = new CSVWriter(stringWriter);
   
    csvWriter.writeNext(header1);
    csvWriter.writeNext(header2);
   
    List<ResultsCell> viewportCells = viewportResults.getResults();
    Iterable<List<ResultsCell>> results = Iterables.partition(viewportCells, columnGroups.getColumnCount());
    for (List<ResultsCell> row : results) {
      String[] rowArray = new String[row.size()];
      int col = 0;
      for (ResultsCell cell : row) {
        Object cellValue = cell.getValue();
        if (cellValue instanceof RowTarget) {
          rowArray[col++] = ((RowTarget) cellValue).getName();
          continue;
        }
       
        ValueSpecification cellValueSpec = cell.getValueSpecification();
        Object formattedValue = _formatter.format(cellValue, cellValueSpec, cell.getFormat(), cell.getInlineKey());
        if (formattedValue instanceof String) {
          rowArray[col++] = (String) formattedValue;
        } else {
          rowArray[col++] = formattedValue.toString();
        }
      }
      csvWriter.writeNext(rowArray);
    }
    return stringWriter.toString();
  }
View Full Code Here

  }

  //-------------------------------------------------------------------------
  String dumpContentsToCsv(ViewComputationResultModel result) {
    StringWriter stringWriter = new StringWriter();
    try (CSVWriter csvWriter = new CSVWriter(stringWriter)) {
      String[][] columnHeaders = getCsvColumnHeaders();
      if (columnHeaders != null) {
        for (String[] header : columnHeaders) {
          csvWriter.writeNext(header);
        }
      }
      String[][] rows = getCsvRows(result);
      if (rows != null) {
        for (String[] row : rows) {
          csvWriter.writeNext(row);
        }
      }
      return stringWriter.toString();
    } catch (IOException ex) {
      throw new OpenGammaRuntimeException(ex.getMessage(), ex);
View Full Code Here

  @GET
  @Produces(RestUtils.TEXT_CSV)
  public String getCSV() {
    StringWriter stringWriter  = new StringWriter();
    @SuppressWarnings("resource")
    CSVWriter csvWriter = new CSVWriter(stringWriter);
    csvWriter.writeNext(new String[] {"Time", "Value"});
    for (Map.Entry<?, Double> entry : data().getTimeSeries().getTimeSeries()) {
      csvWriter.writeNext(new String[] {entry.getKey().toString(), entry.getValue().toString()});
    }
    return stringWriter.toString();
  }
View Full Code Here

        String columns = ThucydidesSystemProperty.THUCYDIDES_CSV_EXTRA_COLUMNS.from(environmentVariables,"");
        return ImmutableList.copyOf(Splitter.on(",").omitEmptyStrings().trimResults().split(columns));
    }

    public File generateReportFor(TestOutcomes testOutcomes, String reportName) throws IOException {
        CSVWriter writer = new CSVWriter(new java.io.OutputStreamWriter(new java.io.FileOutputStream(getOutputFile(reportName)), encoding));
        writeTitleRow(writer);
        writeEachRow(testOutcomes.withHistory(), writer);
        writer.close();
        return getOutputFile(reportName);
    }
View Full Code Here

                }

                // form csv properties
                StringWriter sw = new StringWriter();
                try {
                    CSVWriter writer = new CSVWriter(sw);
                    Iterator it = propertyMap.entrySet().iterator();
                    while (it.hasNext()) {
                        Map.Entry<String, String> pairs = (Map.Entry) it.next();
                        writer.writeNext(new String[]{pairs.getKey(), pairs.getValue()});
                    }
                    writer.close();
                } catch (Exception ex) {
                    LogUtil.error(getClass().getName(), ex, "");
                }
                String pluginProps = sw.toString();
                activityPlugin.setPluginProperties(pluginProps);
View Full Code Here

TOP

Related Classes of au.com.bytecode.opencsv.CSVWriter

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.