Open Filename : = "C:\path\to\file.tsv" ' Select the entire data range Sub ConvertTSVToCSV ( ) ' Open the tab separated file Choose "CSV (Comma delimited)" as the file type.Click on "File" in the ribbon, then click "Save As".Choose the format for each column or leave it as "General".Check the box next to "Tab" and uncheck all other delimiters.In the "Convert Text to Columns Wizard", select "Delimited" and click "Next".
Select the entire data range by clicking on the top-left cell and dragging to the bottom-right cell.Method 1: Using Excel to Convert TSV to CSV In order to use a TSV file in Excel or another program that only supports CSV, the file will need to be converted. TSV and CSV are both popular formats for storing and sharing data, but they use different characters to separate the values within a row. One common conversion that may be needed is to convert a tab-separated file (TSV) to a comma-separated file (CSV). Var worksheet = working with data in Excel, it is often necessary to convert files from one format to another. I don't know how you're building sb so I can't really help with that.
If you already have it in one string, you'll have to first split by line breaks (possibly using csvItem.Split(Environment.NewLine)). There's no need to build the StringBuilder string if you're going to do this. But if you really need to, what I use to create Excel Sheets is EP Plus. First of all, Excel can open CSV files natively so you really don't have to convert the file to Excel.
0 kommentar(er)
