ادغام و تقسیم CSV با استفاده از C#

// Import necessary namespaces
using System;
using System.IO;

namespace GroupDocs.Merger.Examples.CSharp.BasicUsage
{
    /// <summary>
    /// This example demonstrates how to merge multiple CSV files into a single file.
    /// </summary>
    internal static class MergeCsv
    {
        public static void Run()
        {
            Console.WriteLine("=======================================================================");
            Console.WriteLine("Example Basic Usage: MergeCsv");
            Console.WriteLine();

            // Define the output folder and file name
            string outputFolder = Constants.GetOutputDirectoryPath();
            string outputFile = Path.Combine(outputFolder, "merged.csv");
            
            // Load the source CSV file using the Merger class
            using (var merger = new GroupDocs.Merger.Merger(Constants.SAMPLE_CSV))
            {
                // Add another CSV file to merge
                merger.Join(Constants.SAMPLE_CSV_2);
                
                // Merge CSV files and save the result to 'merged.csv'
                merger.Save(outputFile);
            }

            Console.WriteLine("CSV files merge completed successfully.");
            Console.WriteLine($"Check output in {outputFolder}");
        }
    }
}

// Import necessary namespaces
using System;
using System.IO;
using GroupDocs.Merger.Domain.Options;

namespace GroupDocs.Merger.Examples.CSharp.BasicUsage
{
    /// <summary>
    /// This example demonstrates how to split a CSV file into separate documents.
    /// </summary>
    public class SplitCsv
    {
        public static void Run()
        {
            Console.WriteLine("=======================================================================");
            Console.WriteLine("Example Basic Usage: SplitCsv");
            Console.WriteLine();

            // Define the path to the CSV file
            string filePath = Constants.SAMPLE_CSV;
            // Define the output path with a naming pattern
            string filePathOut = Path.Combine(Constants.GetOutputDirectoryPath(), "line_{0}.csv");

            // Create split options to define how to split
            TextSplitOptions splitOptions = new TextSplitOptions(filePathOut, new int[] { 1, 2, 3 });

            using (Merger merger = new Merger(filePath))
            {
                // Split the CSV file according to the specified options
                merger.Split(splitOptions);
            }

            Console.WriteLine("Source document was split successfully.");
            Console.WriteLine($"Check output at {filePathOut}.");
        }
    }
}

using System;
using System.IO;

namespace GroupDocs.Merger.Examples.CSharp.BasicUsage
{
    internal static class MergeMultipleCsvFiles
    {
        public static void Run()
        {
            Console.WriteLine("Merging multiple CSV files.");

            // Define the output folder and output file name for the merged CSV
            string outputFolder = Constants.GetOutputDirectoryPath();
            string outputFile = Path.Combine(outputFolder, "merged_result.csv");
            
            // Start merging process
            using (var merger = new GroupDocs.Merger.Merger(Constants.SAMPLE_CSV))
            {
                merger.Join(Constants.SAMPLE_CSV_2); // Add second CSV file
                merger.Join(Constants.SAMPLE_CSV_3); // Add third CSV file
                merger.Save(outputFile); // Save combined result
            }

            Console.WriteLine($"Successfully merged CSV files into {outputFile}");
        }
    }
}

using System;
using System.IO;
using GroupDocs.Merger.Domain.Options;

namespace GroupDocs.Merger.Examples.CSharp.BasicUsage
{
    public class SplitCsvToLines
    {
        public static void Run()
        {
            Console.WriteLine("Splitting a CSV file into individual line files.");

            // Specify the path of the source CSV file
            string filePath = Constants.SAMPLE_CSV;
            // Define output file naming pattern for split result
            string outputFilePath = Path.Combine(Constants.GetOutputDirectoryPath(), "line_{0}.csv");

            // Set up split options based on desired line numbers
            TextSplitOptions splitOptions = new TextSplitOptions(outputFilePath, new int[] { 1, 2, 3 });

            using (Merger merger = new Merger(filePath))
            {
                merger.Split(splitOptions); // Split the file based on options
            }

            Console.WriteLine($"Successfully split the source document into individual line files.");
        }
    }
}