Write text file from excel using C#

Question

New at C# using visual studio 2010 and trying to get output in a text file from an excel sheet. The excel sheet contains only one column with numeric values like this:

ColumnA
-------
222
333
444
555
666
777
888
999
877
566
767
678
767

I am trying to get the output in the text file like this:

222, 333, 444, 
555, 666, 777, 
888, 999, 877, 
566, 767, 678,
767

Thanks in advance.

Use the Excel Interop to get access to the excel file, then format and write it to your file in C#. Also, remember Excel cells are 1-based indexes, rather than 0. — Thelonias
– Thelonias, Commented Jul 17, 2012 at 18:41

David Kroukamp · Accepted Answer · 2012-07-20 20:55:26Z

1

This should do it using the BytesCout SpreadSheet SDK:

using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
using Bytescout.Spreadsheet;

namespace Converting_XLS_to_TXT
{
class Program
{
static void Main(string[] args)
{
// Create new Spreadsheet from SimpleReport.xls file
Spreadsheet document = new Spreadsheet("SimpleReport.xls");

// delete output file if exists already
if (File.Exists("SimpleReport.txt")){
File.Delete("SimpleReport.txt");
}

// save into TXT
document.Workbook.Worksheets[0].SaveAsTXT("SimpleReport.txt");

}
}
}

References:

BytesCout SpreadSheet Tutorial

edited Jul 20, 2012 at 20:55

answered Jul 17, 2012 at 18:43

David Kroukamp

36.4k13 gold badges85 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rs. Over a year ago

he want to write that to text file. I think Datalist with repeat column is correct control to display this data in required format on webpage and not gridview

Collectives™ on Stack Overflow

Write text file from excel using C#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related