在 Java 中將 CSV 轉換為 JSON

import com.aspose.barcode.api.BarcodeApi;
import com.aspose.barcode.client.ApiException;
import org.json.JSONArray;
import org.json.JSONObject;

import java.io.*;
import java.util.concurrent.*;

public class CsvToJsonConverter {

private static final String CLIENT_ID = "YOUR_CLIENT_ID";
    private static final String CLIENT_SECRET = "YOUR_CLIENT_SECRET";
    private static final String BUCKET = "my-bucket";
    private static final String INPUT_CSV = "input.csv";
    private static final String OUTPUT_JSON = "output.json";

public static void main(String[] args) throws IOException, ApiException, InterruptedException {
        // Initialize API client
        BarcodeApi api = new BarcodeApi();
        api.getApiClient().setBasePath("https://api.aspose.cloud");
        api.getApiClient().setClientId(CLIENT_ID);
        api.getApiClient().setClientSecret(CLIENT_SECRET);

// Upload CSV to cloud storage
        api.uploadFile(BUCKET, INPUT_CSV, new File("src/main/resources/" + INPUT_CSV));

// Download CSV as stream
        InputStream csvStream = api.downloadFile(BUCKET, INPUT_CSV);
        BufferedReader reader = new BufferedReader(new InputStreamReader(csvStream));

// Prepare thread pool for multithreaded processing
        ExecutorService executor = Executors.newFixedThreadPool(Runtime.getRuntime().availableProcessors());
        CompletionService<JSONArray> completionService = new ExecutorCompletionService<>(executor);

// Submit parsing tasks (each task processes a chunk of lines)
        final int CHUNK_SIZE = 5000; // lines per chunk
        String line;
        int lineCount = 0;
        StringBuilder chunkBuilder = new StringBuilder();

while ((line = reader.readLine()) != null) {
            chunkBuilder.append(line).append("\n");
            lineCount++;
            if (lineCount % CHUNK_SIZE == 0) {
                final String chunk = chunkBuilder.toString();
                completionService.submit(() -> parseChunk(chunk));
                chunkBuilder.setLength(0);
            }
        }
        // Process remaining lines
        if (chunkBuilder.length() > 0) {
            final String chunk = chunkBuilder.toString();
            completionService.submit(() -> parseChunk(chunk));
        }

// Gather results
        JSONArray finalArray = new JSONArray();
        int tasks = (lineCount / CHUNK_SIZE) + (chunkBuilder.length() > 0 ? 1 : 0);
        for (int i = 0; i < tasks; i++) {
            try {
                JSONArray partial = completionService.take().get();
                for (int j = 0; j < partial.length(); j++) {
                    finalArray.put(partial.getJSONObject(j));
                }
            } catch (ExecutionException e) {
                e.printStackTrace();
            }
        }
        executor.shutdown();

// Upload final JSON
        String jsonString = finalArray.toString(4);
        api.uploadFile(BUCKET, OUTPUT_JSON,
                new ByteArrayInputStream(jsonString.getBytes()));

System.out.println("Conversion completed successfully.");
    }

// Helper method to parse a CSV chunk into a JSONArray
    private static JSONArray parseChunk(String csvChunk) {
        JSONArray array = new JSONArray();
        BufferedReader br = new BufferedReader(new StringReader(csvChunk));
        String line;
        try {
            while ((line = br.readLine()) != null) {
                String[] cols = line.split(",");
                JSONObject obj = new JSONObject();
                obj.put("column1", cols.length > 0 ? cols[0] : JSONObject.NULL);
                obj.put("column2", cols.length > 1 ? cols[1] : JSONObject.NULL);
                // Add more columns as needed
                array.put(obj);
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
        return array;
    }
}

curl -X POST "https://api.aspose.cloud/v3.0/oauth2/token" \
     -H "Content-Type: application/x-www-form-urlencoded" \
     -d "grant_type=client_credentials&client_id=YOUR_CLIENT_ID&client_secret=YOUR_CLIENT_SECRET"

curl -X PUT "https://api.aspose.cloud/v3.0/barcode/storage/file/{bucket}/input.csv" \
     -H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
     -H "Content-Type: text/csv" \
     --data-binary "@path/to/input.csv"

curl -X POST "https://api.aspose.cloud/v3.0/barcode/custom/csvtojson" \
     -H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
     -H "Content-Type: application/json" \
     -d '{"bucket":"my-bucket","inputFile":"input.csv","outputFile":"output.json"}'

curl -X GET "https://api.aspose.cloud/v3.0/barcode/storage/file/{bucket}/output.json" \
     -H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
     -o output.json

<dependency>
    <groupId>com.aspose</groupId>
    <artifactId>aspose-barcode-cloud</artifactId>
    <version>23.12</version>
</dependency>