# FormatOptionsProperty

Represents a set of options that define the structure of either comma-separated value (CSV), Excel, or JSON input.

- Source: Generated code
- Type last changed: v2.93.0 · 23 Aug 2023

## Example

```ts
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { aws_databrew as databrew } from 'aws-cdk-lib';
const formatOptionsProperty: databrew.CfnDataset.FormatOptionsProperty = {
  csv: {
    delimiter: 'delimiter',
    headerRow: false,
  },
  excel: {
    headerRow: false,
    sheetIndexes: [123],
    sheetNames: ['sheetNames'],
  },
  json: {
    multiLine: false,
  },
};
```

## Properties

- `csv`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnDataset.CsvOptionsProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_databrew.CfnDataset.CsvOptionsProperty.html) — Options that define how CSV input is to be interpreted by DataBrew.

- `excel`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnDataset.ExcelOptionsProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_databrew.CfnDataset.ExcelOptionsProperty.html) — Options that define how Excel input is to be interpreted by DataBrew.

- `json`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnDataset.JsonOptionsProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_databrew.CfnDataset.JsonOptionsProperty.html) — Options that define how JSON input is to be interpreted by DataBrew.
