Proper format for a CSV file : The Official Microsoft ASP.NET Forums

private void CreateNewCSVFile(List<ProductWrapper> products, string saveFilePath, string excelFileMapperPath)
{
try
{
/*
* The license file is an embedded resource in the NopCommon.dll
*/
License license = new License();
license.SetLicense("Aspose.Cells.lic"); // Aspose_Cells

Workbook workbook = new Workbook(excelFileMapperPath);

// Open the 1st Worksheet and go to work
Worksheet worksheet = workbook.Worksheets[0];

int rowIndex = 1;

foreach (var product in products)
{

worksheet.Cells[rowIndex, 2].PutValue(product.FirstName);
worksheet.Cells[rowIndex, 3].PutValue(product.LastName);


rowIndex++;
}

// to create a physical file for testing
workbook.Save(saveFilePath, SaveFormat.CSV);

workbook = null;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}

*** If this post helps you, then Mark this post as Answer ***

Reply

Specs

Member

618 Points

152 Posts

Re: Proper format for a CSV file

Jul 18, 2012 02:46 PM|LINK

Or you can try this:

// CSV rules: http://en.wikipedia.org/wiki/Comma-separated_values#Basic_rules
        // From the rules:
        // 1. if the data has quote, escape the quote in the data
        // 2. if the data contains the delimiter (in our case ','), double-quote it
        // 3. if the data contains the new-line, double-quote it.

        if (data.Contains("\""))
        {
            data = data.Replace("\"", "\"\"");
        }

        if (data.Contains(","))
        {
            data = String.Format("\"{0}\"", data);
        }

        if (data.Contains(System.Environment.NewLine))
        {
            data = String.Format("\"{0}\"", data);
        }

*** If this post helps you, then Mark this post as Answer ***