转换为.XLS制表符分隔.TXT [英] Convert .XLS to tab separated .TXT

问题描述

我可以以某种方式转换成Excel的.xls文件为TXT-TSV（制表符分隔值）文件，使用C＃？

Can I somehow convert Excel .XLS file to txt-tsv (tab-separated-values) file, using C#?

推荐答案

您可以读取方便地通过OLEDB（ADO.NET提供商）的XLS文件，并创建一个的StreamWriter 对象将数据写入到文本/ TSV文件。

You may read that XLS file easily via OleDb (ADO.NET provider) and create a StreamWriter object to write data into the Text/TSV file.

using (OleDbConnection cn = new OleDbConnection())
        {
            using (OleDbCommand cmd = new OleDbCommand())
            {
                cn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @"C:\path\file.xls" + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";";
                cmd.Connection = cn;
                cmd.CommandText = "select * from [Sheet1$]";
                using (OleDbDataAdapter adp = new OleDbDataAdapter(cmd))
                {
                    DataTable dt = new DataTable();
                    adp.Fill(dt);
                    using (StreamWriter wr = new StreamWriter(@"C:\path\flie.tsv"))
                    {
                        foreach (DataRow row in dt.Rows)
                        {
                            wr.WriteLine(row[0] + "\t" + row[1]);
                        }
                    }
                }
            }
        }

这篇关于转换为.XLS制表符分隔.TXT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！