Csvtoxml
Author: b | 2025-04-23
Download CSVtoXML latest version for Windows free. CSVtoXML latest update: Ap This is the Windows app named CSVtoXML whose latest release can be downloaded as CSVtoXML-V1.3_Cross-platform.zip. It can be run online in the free hosting provider OnWorks
csvtoxml - Browse /csvtoxml at SourceForge.net
I wrote a simple class that will help you convert a CSV file to XML. Ican hear you asking "that's nice JP, but why would I want to convert mysimple CSV to that messy text format from the early 2000's?" You woulddo this because you want to use LINQ with CSV files... that's why.Here is the crux of the algorithm:public void Convert() { var tempLines = File.ReadAllLines(this.CsvFile); string[] lines = null; _columnNames = null; if (this.HasColumnNames) { _columnNames = Csv.RecordSplit(tempLines[0], this.RecordDelimiter, this.TextQualifier); lines = new string[tempLines.Length - 1]; Array.Copy(tempLines, 1, lines, 0, lines.Length); } else { var columnCount = Csv.RecordSplit(tempLines[0], this.RecordDelimiter, this.TextQualifier).Length; _columnNames = new string[columnCount]; for (int x = 0; x _columnNames.Length; ++x) _columnNames[x] = "Column" + (x+1); lines = tempLines; } this.XmlData = new XElement("Records", from line in lines let fields = Csv.RecordSplit(line, this.RecordDelimiter, this.TextQualifier) select new XElement("Record", from fieldData in fields let i = fields.ToList().FindIndex(f => f == fieldData) select new XElement(_columnNames[i], fieldData) ) );}You can look at the full code in my C# CommonLiblibrary.As you can see, the code is really straightforward.Let's assume that your CSV file looks like this:'Product','Price','DateStocked' 'Pepsi','4.50','2010-05-04' 'Coke','3.00','2010-09-22' 'Cheetos','7.25','2009-01-13'You can then run Csv2Xml like this:var csv = new CsvToXml(csvFile);csv.RecordDelimiter = ','; csv.TextQualifier = ''';csv.HasColumnNames = false;csv.Convert();var actualXml = csv.XmlString;The output XML will look like this: Pepsi 4.50 2010-05-04 Coke 3.00 2010-09-22 Cheetos 7.25 2009-01-13 If you set "HasColumnNames" to "True", your XML output will look likethis: Pepsi 4.50 2010-05-04 Coke 3.00 2010-09-22 Cheetos 7.25 2009-01-13 Pretty nifty huh? In the next post, I'll explain how you can use thiswith LINQ. If you made it this far, you should follow me on Twitter. Follow @jprichardson!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+'://platform.twitter.com/widgets.js';fjs.parentNode.insertBefore(js,fjs);}}(document, 'script', 'twitter-wjs');-->If you made it this far, you should follow me on Twitter. -JPWant to test-drive Bitcoin without any risk? Check out my bitcoin wallet Coinbolt. It includes test coins for free. comments powered by
CSVtoXML download for Windows - OnWorks
CSVTOXML (free) download Windows version
. Download CSVtoXML latest version for Windows free. CSVtoXML latest update: Ap This is the Windows app named CSVtoXML whose latest release can be downloaded as CSVtoXML-V1.3_Cross-platform.zip. It can be run online in the free hosting provider OnWorksGitHub - MarkWattsBoomi/boomi-script-CSVtoXML: A generic
CSVtoXML for Windows - Free download and software reviews
Large Mailbox PST Exports - Using the CSVtoXML Tool with
. Download CSVtoXML latest version for Windows free. CSVtoXML latest update: Ap This is the Windows app named CSVtoXML whose latest release can be downloaded as CSVtoXML-V1.3_Cross-platform.zip. It can be run online in the free hosting provider OnWorksComments
I wrote a simple class that will help you convert a CSV file to XML. Ican hear you asking "that's nice JP, but why would I want to convert mysimple CSV to that messy text format from the early 2000's?" You woulddo this because you want to use LINQ with CSV files... that's why.Here is the crux of the algorithm:public void Convert() { var tempLines = File.ReadAllLines(this.CsvFile); string[] lines = null; _columnNames = null; if (this.HasColumnNames) { _columnNames = Csv.RecordSplit(tempLines[0], this.RecordDelimiter, this.TextQualifier); lines = new string[tempLines.Length - 1]; Array.Copy(tempLines, 1, lines, 0, lines.Length); } else { var columnCount = Csv.RecordSplit(tempLines[0], this.RecordDelimiter, this.TextQualifier).Length; _columnNames = new string[columnCount]; for (int x = 0; x _columnNames.Length; ++x) _columnNames[x] = "Column" + (x+1); lines = tempLines; } this.XmlData = new XElement("Records", from line in lines let fields = Csv.RecordSplit(line, this.RecordDelimiter, this.TextQualifier) select new XElement("Record", from fieldData in fields let i = fields.ToList().FindIndex(f => f == fieldData) select new XElement(_columnNames[i], fieldData) ) );}You can look at the full code in my C# CommonLiblibrary.As you can see, the code is really straightforward.Let's assume that your CSV file looks like this:'Product','Price','DateStocked' 'Pepsi','4.50','2010-05-04' 'Coke','3.00','2010-09-22' 'Cheetos','7.25','2009-01-13'You can then run Csv2Xml like this:var csv = new CsvToXml(csvFile);csv.RecordDelimiter = ','; csv.TextQualifier = ''';csv.HasColumnNames = false;csv.Convert();var actualXml = csv.XmlString;The output XML will look like this: Pepsi 4.50 2010-05-04 Coke 3.00 2010-09-22 Cheetos 7.25 2009-01-13 If you set "HasColumnNames" to "True", your XML output will look likethis: Pepsi 4.50 2010-05-04 Coke 3.00 2010-09-22 Cheetos 7.25 2009-01-13 Pretty nifty huh? In the next post, I'll explain how you can use thiswith LINQ. If you made it this far, you should follow me on Twitter. Follow @jprichardson!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^http:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+'://platform.twitter.com/widgets.js';fjs.parentNode.insertBefore(js,fjs);}}(document, 'script', 'twitter-wjs');-->If you made it this far, you should follow me on Twitter. -JPWant to test-drive Bitcoin without any risk? Check out my bitcoin wallet Coinbolt. It includes test coins for free. comments powered by
2025-04-09