I am using CSV Helper to create a CSV file as follows:
<code>for (int i = 0; i < dsData.Rows.Count; i++)
{
DateTime invDate = Convert.ToDateTime(dsData.Rows[i]["DocDate"].ToString());
string invoiceDate = invDate.ToString("yyyyMMdd");
invoices.Add(new Invoices
{
Recordtype = "DIALSALES01ZA",
DistributorCode = 161457,
InvoiceNumber = dsData.Rows[i]["DocNum"].ToString(),
InvDate = invoiceDate,
SCJProductCode = dsData.Rows[i]["CardCode"].ToString(),
DistributorProductCode = dsData.Rows[i]["CardCode"].ToString(),
SalesmanCode = dsData.Rows[i]["SlpCode"].ToString(),
SalesmanName = dsData.Rows[i]["SlpName"].ToString(),
SupervisorCode = "Kinyanjui",
SupervisorName = "Kamau",
WarehouseCode = dsData.Rows[i]["WhsCode"].ToString(),
WarehouseName = dsData.Rows[i]["WhsName"].ToString(),
OutletTypeCode = "Mini mart",
OutletTypeName = "Mini mart",
ClientInternalCode = dsData.Rows[i]["CardCode"].ToString(),
ClientFederalID = dsData.Rows[i]["CardCode"].ToString(),
ClientName = dsData.Rows[i]["CardName"].ToString(),
City = dsData.Rows[i]["City"].ToString(),
ZipCode = 0,
DeliveryAddress = dsData.Rows[i]["Address"].ToString(),
Quantity = Convert.ToDouble(dsData.Rows[i]["U_PCs"].ToString()),
GrossValue = Convert.ToDouble(dsData.Rows[i]["GTotal"].ToString()),
NetValue = Convert.ToDouble(dsData.Rows[i]["LineTotal"].ToString()),
Fraction = 1,
EANCode = "1",
});
}
DateTime dateTimeNow = DateTime.Now;
Random rnd = new Random();
double num = rnd.Next(1, 10000000);
string filename = dateTimeNow.ToString("yyyyMMdd") + num.ToString() + ".csv";
var csvPath = "C:/Integrations/RAISONS/SCJohnsonIntegration/Invoices_CSVs/" + filename + "";
using (var streamWriter = new StreamWriter(csvPath))
{
using (var csvWriter = new CsvWriter(streamWriter, CultureInfo.InvariantCulture))
{
csvWriter.WriteRecords(invoices);
}
}
}
</code>
<code>for (int i = 0; i < dsData.Rows.Count; i++)
{
DateTime invDate = Convert.ToDateTime(dsData.Rows[i]["DocDate"].ToString());
string invoiceDate = invDate.ToString("yyyyMMdd");
invoices.Add(new Invoices
{
Recordtype = "DIALSALES01ZA",
DistributorCode = 161457,
InvoiceNumber = dsData.Rows[i]["DocNum"].ToString(),
InvDate = invoiceDate,
SCJProductCode = dsData.Rows[i]["CardCode"].ToString(),
DistributorProductCode = dsData.Rows[i]["CardCode"].ToString(),
SalesmanCode = dsData.Rows[i]["SlpCode"].ToString(),
SalesmanName = dsData.Rows[i]["SlpName"].ToString(),
SupervisorCode = "Kinyanjui",
SupervisorName = "Kamau",
WarehouseCode = dsData.Rows[i]["WhsCode"].ToString(),
WarehouseName = dsData.Rows[i]["WhsName"].ToString(),
OutletTypeCode = "Mini mart",
OutletTypeName = "Mini mart",
ClientInternalCode = dsData.Rows[i]["CardCode"].ToString(),
ClientFederalID = dsData.Rows[i]["CardCode"].ToString(),
ClientName = dsData.Rows[i]["CardName"].ToString(),
City = dsData.Rows[i]["City"].ToString(),
ZipCode = 0,
DeliveryAddress = dsData.Rows[i]["Address"].ToString(),
Quantity = Convert.ToDouble(dsData.Rows[i]["U_PCs"].ToString()),
GrossValue = Convert.ToDouble(dsData.Rows[i]["GTotal"].ToString()),
NetValue = Convert.ToDouble(dsData.Rows[i]["LineTotal"].ToString()),
Fraction = 1,
EANCode = "1",
});
}
DateTime dateTimeNow = DateTime.Now;
Random rnd = new Random();
double num = rnd.Next(1, 10000000);
string filename = dateTimeNow.ToString("yyyyMMdd") + num.ToString() + ".csv";
var csvPath = "C:/Integrations/RAISONS/SCJohnsonIntegration/Invoices_CSVs/" + filename + "";
using (var streamWriter = new StreamWriter(csvPath))
{
using (var csvWriter = new CsvWriter(streamWriter, CultureInfo.InvariantCulture))
{
csvWriter.WriteRecords(invoices);
}
}
}
</code>
for (int i = 0; i < dsData.Rows.Count; i++)
{
DateTime invDate = Convert.ToDateTime(dsData.Rows[i]["DocDate"].ToString());
string invoiceDate = invDate.ToString("yyyyMMdd");
invoices.Add(new Invoices
{
Recordtype = "DIALSALES01ZA",
DistributorCode = 161457,
InvoiceNumber = dsData.Rows[i]["DocNum"].ToString(),
InvDate = invoiceDate,
SCJProductCode = dsData.Rows[i]["CardCode"].ToString(),
DistributorProductCode = dsData.Rows[i]["CardCode"].ToString(),
SalesmanCode = dsData.Rows[i]["SlpCode"].ToString(),
SalesmanName = dsData.Rows[i]["SlpName"].ToString(),
SupervisorCode = "Kinyanjui",
SupervisorName = "Kamau",
WarehouseCode = dsData.Rows[i]["WhsCode"].ToString(),
WarehouseName = dsData.Rows[i]["WhsName"].ToString(),
OutletTypeCode = "Mini mart",
OutletTypeName = "Mini mart",
ClientInternalCode = dsData.Rows[i]["CardCode"].ToString(),
ClientFederalID = dsData.Rows[i]["CardCode"].ToString(),
ClientName = dsData.Rows[i]["CardName"].ToString(),
City = dsData.Rows[i]["City"].ToString(),
ZipCode = 0,
DeliveryAddress = dsData.Rows[i]["Address"].ToString(),
Quantity = Convert.ToDouble(dsData.Rows[i]["U_PCs"].ToString()),
GrossValue = Convert.ToDouble(dsData.Rows[i]["GTotal"].ToString()),
NetValue = Convert.ToDouble(dsData.Rows[i]["LineTotal"].ToString()),
Fraction = 1,
EANCode = "1",
});
}
DateTime dateTimeNow = DateTime.Now;
Random rnd = new Random();
double num = rnd.Next(1, 10000000);
string filename = dateTimeNow.ToString("yyyyMMdd") + num.ToString() + ".csv";
var csvPath = "C:/Integrations/RAISONS/SCJohnsonIntegration/Invoices_CSVs/" + filename + "";
using (var streamWriter = new StreamWriter(csvPath))
{
using (var csvWriter = new CsvWriter(streamWriter, CultureInfo.InvariantCulture))
{
csvWriter.WriteRecords(invoices);
}
}
}
It creates the following CSV and you can see the Quantity column is “General”. I would like to make this column as “Number”. How do I acheve this?