Writing TextBox data to MS Excel document

Question

0.00/5 (No votes)

See more:

I have a doubt related to asp.net c#. I am developing a web project, in which, there is a web form, that has a number of textbox entries and a submit button.

After entering the data in the textboxes and clicking submit button, all the data should be read from the Textboxes and inserted in to an Excel document designed in the form of a "form". The Excel document has texboxes, which need to be populated from the asp.net webform. How is this possible ?

I have a concept in mind :- I will upload a copy of the Excel sheet into the website. When a user fills the form and click on submit, an instance of the Excel document is called, and data is inserted. After that, the Excel sheet instance is renamed as "username" and saved somewhere. Is it possible to create instances of Excel sheets like this ?

Posted 16-Aug-13 6:42am

Gee Varghese

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)

Gee Varghese · Answer 1 · 2013-08-16T07:15:00

Sorry for not doing that.
I could create a new blank instance of the excel spreadsheet, but I don't know how to open an existing file, create a duplicate of that file, insert data and save it in a new name.

The code that I used to write data to a blank file is :-

protected void btnSubmission_Click(object sender, EventArgs e)
{
    Microsoft.Office.Interop.Excel.Application xlapp = new Microsoft.Office.Interop.Excel.Application();
    Workbook wb = xlapp.Workbooks.Add(XlSheetType.xlWorksheet);
    Worksheet ws = (Worksheet)xlapp.ActiveSheet;

    xlapp.Visible = true;

    String s1 = TextBox2.Text;
    ws.Cells[4,4]=s1;
}