Steps to Edit CSV in Java

GroupDocs.Editor for Java provides an easy and straightforward way for developers to edit the CSV files using a few lines of code.

Create an instance of Editor class with mandatory file path or byte stream and load the CSV file
Create the DelimitedTextEditOptions class instance for the CSV file format and specify a mandatory string separator in the constructor
Call Editor.Edit() method and obtain CSV document in HTML format that is easily editable with any WYSIWYG-editor
Call Editor.Save() method and save edited CSV file using the DelimitedTextSaveOptions class instance with desired separator

System Requirements

A basic document editing with GroupDocs.Editor for Java APIs can be done by implementing a few easy steps. Our APIs are supported on all major platforms and operating systems. Before executing the code below, please make sure that you have the following prerequisites installed on your system.

Operating Systems: Microsoft Windows, Linux, MacOS
Development Environments: NetBeans, IntelliJ IDEA, Eclipse
Frameworks: Java 7 (1.7) and above
Get the latest version of GroupDocs.Editor for Java downloaded from Maven

// Load the CSV file into Editor with no extra loading options
Editor editor = new Editor("source.csv");

// Create edit options for delimited text and specify a mandatory separator in the constructor
DelimitedTextEditOptions editOptions = new DelimitedTextEditOptions(",");        

// Open input CSV document for edit — obtain an intermediate document, that can be edited
EditableDocument beforeEdit = editor.edit(editOptions);

// Grab CSV document content and associated resources from editable document
string content = beforeEdit.getContent();

// Send the content to WYSIWYG-editor, edit it there, and send edited content back to the server-side
// This step simulates a such operation
string updatedContent = content.replace("Cell Text", "Edited Cell Text");

// Grab edited content and resources from WYSIWYG-editor and create a new EditableDocument instance from it
EditableDocument afterEdit = EditableDocument.fromMarkup(updatedContent, null);

// Create save options for delimited text and specify a mandatory separator in the constructor
DelimitedTextSaveOptions saveOptions = new DelimitedTextSaveOptions(",");

// Save edited CSV document to the file
editor.save(afterEdit, "edited.csv", saveOptions);