How To Convert CSV Files with multiline support in C# on Windows

You can use TotalCSVConverterX solution

Total CSV ConverterX

CSV to DOC, PDF, HTML, TXT, XLS, DBF, XML or OpenOffice formats via command line

Windows
2000/2003/Vista/7/8/10
and
2012/2016/2019 Server

Convert CSV to DOC, PDF, HTML, TXT, XLS, DBF, XML or OpenOffice formats on a web-server with Total CSV ConverterX. It also supports TSV files. The program has no graphic user interface so you do not get any interrupting messages. It can be setup as a standalone client-server application available for users of your local network or serve as a web service available online.

A powerful engine of Total CSV ConverterX allows to convert very large volumes of CSV files as fast as possible. When you convert several folders with CSV files the program keeps folder structure.

Total CSV ConverterX is very flexible. You can set the input and putput formats of the resulting files to your needs (integer, float, separators, etc.)

Total CSV ConverterX includes ActiveX so that you could integrate the converter into a web interface.

You can select the CSV data to be converted or skip some rows.

Test Total CSV ConverterX with ActiveX before purchasing for free. Download your 30-day evaluation version here.

Download Now!

(includes 30 day FREE trial)

Buy License

(only $850.00)

Examples of Total CSV ConverterX

Convert CSV files With TotalCSVConverterX and .NET

string src="C:\\test\\Source.csv";
string dest="C:\\test\\Dest.PDF";

CSVConverterX Cnv = new CSVConverterX();
Cnv.Convert(src, dest, "-c PDF -log c:\\test\\CSV.log");

MessageBox.Show("Convert complete!");

Download .NET CSV Covnerter example

Convert CSV Files On Web Servers With Total CSV ConverterX

dim C
Set C=CreateObject("CSVConverter.CSVConverterX")
C.Convert "c:\test\source.csv", "c:\test\dest.pdf", "-cPDF -log c:\test\CSV.log"
Response.Write C.ErrorMessage
set C = nothing

Example2 ASP: directly stream the resulting PDF

dim C
Set C=CreateObject("CSVConverter.CSVConverterX")
Response.Clear
Response.AddHeader "Content-Type", "binary/octet-stream"
Rresponse.AddHeader "Content-Disposition", "attachment; filename=test.pdf"
Response.BinaryWrite c.ConvertToStream("C:\www\ASP\Source.csv", "C:\www\ASP", "-cpdf  -log c:\test\csv.log")
set C = nothing

Convert CSV files With Total CSV ConverterX and PHP

$src="C:\\test\\test.csv";
$dest="C:\\test\\test.xlsx";
if (file_exists($dest)) unlink($dest);
$c= new COM("CSVConverter.CSVConverterX");
$c->convert($src,$dest, "-c pdf -log c:\\test\\csv.log");
if (file_exists($dest)) echo "OK"; else echo "fail:".$c->ErrorMessage;

Convert CSV files With Total CSV ConverterX and Ruby

require 'win32ole'
c = WIN32OLE.new('CSVConverter.CSVConverterX')

src="C:\\test\\test.csv";
dest="C:\\test\\test.pdf";

c.convert(src,dest, "-c PDF -log c:\\test\\CSV.log");

if not File.exist?(dest)
  puts c.ErrorMessage
end

Convert CSV files With Total CSV ConverterX and Python

import win32com.client
import os.path

c = win32com.client.Dispatch("CSVConverter.CSVConverterX")

src="C:\\test\\test.csv";
dest="C:\\test\\test.pdf";

c.convert(src, dest, "-c PDF -log c:\\test\\CSV.log");

if not os.path.exists(file_path):
  print(c.ErrorMessage)

Convert CSV files With Pascal and Total CSV ConverterX

uses Dialogs, Vcl.OleAuto;

var
  c: OleVariant;
begin
  c:=CreateOleObject('CSVConverter.CSVConverterX');
  C.Convert('c:\test\source.csv', 'c:\test\dest.pdf', '-cPDF -log c:\test\CSV.log');
  IF c.ErrorMessage<> Then
    ShowMessage(c.ErrorMessage);
end;

Convert CSV files With Total CSV ConverterX and JavaScript

var c = new ActiveXObject("CSVConverter.CSVConverterX");
c.Convert("C:\\test\\source.csv", "C:\\test\\dest.pdf", "-c PDF");
if (c.ErrorMessage!="")
  alert(c.ErrorMessage)

Convert CSV files With Total CSV ConverterX and Perl

use Win32::OLE;

my $src="C:\\test\\test.csv";
my $dest="C:\\test\\test.pdf";

my $c = CreateObject Win32::OLE 'CSVConverter.CSVConverterX';
$c->convert($src,$dest, "-c pdf  -log c:\\test\\CSV.log");
print $c->ErrorMessage if -e $dest;

Total CSV ConverterX Customer Reviews 2021

Rated 4.7/5 based on customer reviews

"I convert a CSV file to an XLS file on the windows command line. I was open to installing Office but Total CSV Converter managed the task without it. A good piece of software, thank you!"

5 Star Ron Duggs
Consumer Settlements

"We had a need to extract several CSV files from different worksheets. Tried several converters, but only this one worked fine. Thank you!"

5 Star Gilbert L.

Download Now!

Updated Sat, 17 Oct 2020

Buy License

(only $850.00)