Generate CSV File

we can make the code more flexible by allowing users to specify the number of decimal places for formatting. Here's the improved version:

using System;
using System.IO;
using System.Globalization;

class Program
{
    static void Main(string[] args)
    {
        // Sample data
        double[] amounts = { 50.000000, 0.882700, 49.370000 };

        // File path
        string filePath = "output.csv";

        // Write data to CSV file
        WriteDataToCSV(filePath, amounts, decimalPlaces: 6);

        Console.WriteLine("CSV file generated successfully.");
    }

    static void WriteDataToCSV(string filePath, double[] data, int decimalPlaces)
    {
        // Create StreamWriter with specified file path
        using (StreamWriter writer = new StreamWriter(filePath))
        {
            // Write header
            writer.WriteLine("Amount");

            // Write data rows with specified formatting
            foreach (double value in data)
            {
                // Format the value with specified number of decimal places
                string formattedValue = FormatNumber(value, decimalPlaces);

                // Write formatted value to CSV file
                writer.WriteLine(formattedValue);
            }
        }
    }

    static string FormatNumber(double number, int decimalPlaces)
    {
        // Construct format string based on the number of decimal places
        string format = "0." + new string('0', decimalPlaces);

        // Format the number with specified decimal places using InvariantCulture
        return number.ToString(format, CultureInfo.InvariantCulture);
    }
}

1. Encapsulated formatting logic: Created a separate method FormatNumber to encapsulate the formatting logic, making the code more modular and easier to understand.
2. Added flexibility: Allowed users to specify the number of decimal places for formatting when writing data to the CSV file.
3. Improved method abstraction: Introduced a new method WriteDataToCSV to handle the process of writing data to the CSV file, enhancing code readability and maintainability.

To ensure that numeric values are written with specific formatting, such as keeping trailing zeros, when writing to a CSV file using StreamWriter in C#, you can specify the formatting options while writing the data. Here's a sample code snippet demonstrating how you can achieve this:

using System;
using System.IO;
using System.Globalization;

class Program
{
    static void Main(string[] args)
    {
        // Sample data
        double[] amounts = { 50.000000, 0.882700, 49.370000 };

        // File path
        string filePath = "output.csv";

        // Write data to CSV file
        using (StreamWriter writer = new StreamWriter(filePath))
        {
            // Write header
            writer.WriteLine("Amount");

            // Write data rows
            foreach (double amount in amounts)
            {
                // Write formatted amount
                writer.WriteLine(amount.ToString("0.000000", CultureInfo.InvariantCulture));
            }
        }

        Console.WriteLine("CSV file generated successfully.");
    }
}

In this code:

• amount.ToString("0.000000", CultureInfo.InvariantCulture) is used to format the amount with six decimal places and using the invariant culture to ensure consistent formatting across different systems.
• StreamWriter is used to write the formatted amounts to the CSV file.

This should ensure that numeric values are written with the specified formatting to the CSV file.