inserting values to frontend

Question

0.00/5 (No votes)

See more:

Hi,
I have exported values from datatable to excel using list.. I have inserted values to the list and passed that in a grid and using ExporttoExcel() i have exported it to excel..
here is the code for list...

C#

protected void Page_Load(object sender, EventArgs e)
        {
            List<student> Students = new List<student>(){
                new Student() { Name = "Jack", Age = 15, StudentId = 100 },
                new Student() { Name = "Smith", Age = 15, StudentId =101 },           
                new Student() { Name = "Smit", Age = 15, StudentId = 102 },
                new Student() { Name = "Anusha", Age = 23, StudentId = 104 }
            };
            ListtoDataTableConverter converter = new ListtoDataTableConverter();
            dt = converter.ToDataTable(Students);
            GridView_Result.DataSource = Students;
            GridView_Result.DataBind();
        }

now, i want to insert values from front end and i want that to be saved in excel.. instead of using grid, i will use a text field and after entering value and if u click insert button, it should be saved in excel sheet...is there any ways to do so ...

thanks a ton..!!

Posted 9-Sep-12 19:10pm

Anusha Sridhar

Updated 9-Sep-12 19:11pm

JF2015

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Menon Santosh · Answer 1 · 2012-09-09T22:48:00

check this code

C#

//namespace for excel
using excel = Microsoft.Office.Interop.Excel;



	    excel.Application eApp = new excel.Application();
            excel.Worksheet eWs = new excel.Worksheet();
            excel.Workbook eWs1;
            eWs1 = (excel.Workbook)(eApp.Workbooks.Add([Excel Path]));
            eWs = (excel.Worksheet)eWs1.Worksheets[0];
            eApp.Visible = true;

	    DataTable dt = new DataTable();

            //fill data table here
            //make current sheet active

            eWs.Select(Type.Missing);

		int iRow = 1;
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    
                    
                    eWs.Cells[iRow, 1] = Convert.ToString(dr["column1"]);
                    eWs.Cells[iRow, 2] = Convert.ToString(dr["column2"]);
                    eWs.Cells[iRow, 3] = Convert.ToString(dr["column3"]);
                    eWs.Cells[iRow, 4] = Convert.ToString(dr["column4"]);
                     iRow++;
                 }
             }
//save the workbook

eWs1.SaveAs([Excel Path], Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);