writing to excel file with text template in C#

Question

I want to write a template file (*.tt) to write data to an XLS file in C#. How can I write the data in separate columns? For example I want to an excel file with 3 column as below

column1   column2   column3
sss         ttt       rrr
www         qqq        aaa

but I can't insert them in separate column

<#= "sss " #><#= "ttt " #><#= "," #><#= "rrr" #>
<#= "www " #><#= "qqq " #><#= "," #><#= "aaa" #>

and the output in excel file is like this

column1
sss ttt rrr
www qqq aaa

and all data are inserted at the first column

define the rage and then use loop for inserting the values in different column using this range object. — user3217843, Dec 01 '14 at 06:21
@fasadat What mechanism do you use currently for creating the XLS file in C#? — MNS, Dec 01 '14 at 06:24
@fasadat I suggest using Excel Interop using C#. You can do almost anything you want. — MNS, Dec 01 '14 at 06:29
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/65930/discussion-between-fasadat-and-mns). — fasadat, Dec 01 '14 at 07:01
Check http://stackoverflow.com/questions/151005/create-excel-xls-and-xlsx-file-from-c-sharp — Vojtěch Dohnal, Dec 01 '14 at 08:39

score 0 · Answer 1 · answered Dec 01 '14 at 09:45

If you opt for using Excel Interop, then following is a demonstration of putting data in separate columns of an Excel worksheet. You can refer this for more details on Excel Object model reference.

using Excel = Microsoft.Office.Interop.Excel;

namespace ExcelInterop
{
    class Program
    {
        static void Main(string[] args)
        {
            Excel.Application xlApp = null;
            Excel.Workbook xlWorkBook = null;

            xlApp = new Excel.Application();
            xlWorkBook = xlApp.Workbooks.Add();
            Excel.Worksheet newWorksheet = null;
            newWorksheet = (Excel.Worksheet)xlApp.Application.Worksheets.Add();
            xlApp.ScreenUpdating = false;
            Excel.Range excelRange = newWorksheet.UsedRange;

            // Column 1
            excelRange.Cells.set_Item(1, 1, "Column 1");

            // Column 1 Data
            excelRange.Cells.set_Item(2, 1, "sss");

            // Column 2
            excelRange.Cells.set_Item(1, 2, "Column 2");

            // Column 1 Data
            excelRange.Cells.set_Item(2, 2, "ttt");


            // Save it as .xls
            newWorksheet.SaveAs("D:\\ExcelInterop", Excel.XlFileFormat.xlExcel7);

            // Clean up
            xlWorkBook.Close();
            xlApp.Quit();
            System.Runtime.InteropServices.Marshal.ReleaseComObject(xlWorkBook);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp);

        }
    }
}

writing to excel file with text template in C#

1 Answers1