> For the complete documentation index, see [llms.txt](https://trillo.gitbook.io/trillo-workbench-java-sdk/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://trillo.gitbook.io/trillo-workbench-java-sdk/csvapi.md). # CSVApi ## csvGetAllRows Description... ``` CSVApi.csvGetAllRows(String filePath) or CSVApi.csvGetAllRows(String filePath, String separator) or CSVApi.csvGetAllRows(String filePath, String separator, String[] columnNames) or CSVApi.csvGetAllRows(String filePath, String separator, String[] columnNames, int columnNameLine) ``` #### Parameters ``` filePath separator columnNames columnNameLine ``` #### Returns ``` List> ``` ## csvGetPage Description... ``` CSVApi.csvGetPage(String fileName, String separatorStr, List columnNames, int columnNameLine, String query, int startIndex, int pageSize) or CSVApi.csvGetPage(String fileName, char separatorChar, List columnNames, int columnNameLine, String query, int startIndex, int pageSize) ``` #### Parameters ``` fileName separatorChar columnNames columnNameLine query startIndex pageSize ``` #### Returns ``` List> ``` ## getCSVIterator Description... ``` CSVApi.getCSVIterator(String fileName, int startIndex, int pageSize) or CSVApi.getCSVIterator(String fileName, String query, int startIndex, int pageSize) or CSVApi.getCSVIterator(String fileName, char separatorChar, String query, int startIndex, int pageSize) or CSVApi.getCSVIterator(String fileName, List columnNames, String query, int startIndex, int pageSize) or CSVApi.getCSVIterator(String fileName, char separatorChar, List columnNames, String query, int startIndex, int pageSize) or CSVApi.getCSVIterator(String fileName, List columnNames, int columnNameLine, String query, int startIndex, int pageSize) or CSVApi.getCSVIterator(String fileName, char separatorChar, List columnNames, int columnNameLine, String query, int startIndex, int pageSize) ``` #### Parameters ``` fileName startIndex pageSize query separatorChar columnNames columnNameLine ``` #### Returns ``` CSVIterator ``` ## getCSVIterator Description... ``` CSVApi.getCSVWriter(String fileName, FieldList fl) or CSVApi.getCSVWriter(String fileName, List columnNames) or CSVApi.getCSVWriter(String fileName, char separatorChar, FieldList fl) or CSVApi.getCSVWriter(String fileName, char separatorChar, List columnNames) or CSVApi.getCSVWriter(String fileName, char separatorChar, FieldList fl, int columnNameLine) or CSVApi.getCSVWriter(String fileName, char separatorChar, List columnNames, int columnNameLine) ``` #### Parameters ``` fileName fl separatorChar columnNames columnNameLine ``` #### Returns ``` CSVWriter ``` ## getCSVIterator Description... ``` CSVApi.getCSVWriter(String fileName, FieldList fl) or CSVApi.getCSVWriter(String fileName, List columnNames) or CSVApi.getCSVWriter(String fileName, char separatorChar, FieldList fl) or CSVApi.getCSVWriter(String fileName, char separatorChar, List columnNames) or CSVApi.getCSVWriter(String fileName, char separatorChar, FieldList fl, int columnNameLine) or CSVApi.getCSVWriter(String fileName, char separatorChar, List columnNames, int columnNameLine) ``` #### Parameters ``` fileName fl separatorChar columnNames columnNameLine ``` #### Returns ``` CSVWriter ``` ## getCSVIterator Description... ``` CSVApi.getCSVImportIterator(String id, int limit) or CSVApi.getCSVImportIterator(String id, int limit, List> mappings) or CSVApi.getCSVImportIterator(String id, String modelClassName, int limit, List> mappings) ``` #### Parameters ``` id limit mappings modelClassName ``` #### Returns ``` Object ``` ## getCSVIterator Description... ``` CSVApi.csvWriteFile(String fileName, String separatorStr, List columnNames, int columnNameLine, List> rows) or CSVApi.csvWriteFile(String fileName, char separatorChar, List columnNames, int columnNameLine, List> rows) ``` #### Parameters ``` fileName separatorStr separatorChar columnNames columnNameLine rows ``` #### Returns ``` Result ```