How to save copied data from a website to an excel sheet in a windows form application?

Question

0.00/5 (No votes)

See more:

In my application, I want to create an automation software using C#.NET which works in two steps:

1. Select particular data and copy it from a page of a website. I have done it using web browser control for SelectAll. The data is not HTML data but databound data.
2. Next, I want to save the copied contents of the page to an to excel sheet directly. There is no datatable or gridview to export, just the copied content directly from a page. I urgently need help for this code section.

I'll be grateful for your immediate help.

Posted 16-Jun-14 20:58pm

Member 10872859

Updated 16-Jun-14 21:46pm

v5

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)

Kareem Abou Saad · Accepted Answer · 2014-06-16T21:55:00

Concerning the copied data you can access it using the Clipboard class ... Details on how to use it are available on MSDN here

To export copied data to an excel sheet, follow these steps:

1- Convert the copied data to a 2-dimensional string (you can do this by parsing the strings in nested for loops).

2- Create an instance of Microsoft Excel and implement the DisplayInExcel method:

C#

using System;
using Excel = Microsoft.Office.Interop.Excel;
using System.Reflection;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;

public class ExcelDemo
{
        private Excel.Application xlApp;
        private Excel._Workbook xlBook;
        private Excel._Worksheet xlSheet;
        private object misValue = Missing.Value;

        public void DisplayInExcel(string[,] Data)
         {
            Excel.Workbooks xlBooks;
            Excel.Sheets xlSheets;
            Excel.Range range;

            try
            {
                // Instantiate Excel and start a new workbook.
                xlApp = new Excel.Application();
                xlBooks = xlApp.Workbooks;
                xlBook = xlBooks.Add(Missing.Value);
                xlSheets = xlBook.Worksheets;
                xlSheet = (Excel._Worksheet)xlSheets.get_Item(1);

                //Set the default location for saving files
                xlApp.DefaultFilePath = @"C:\test";

                //Get the range where the starting cell has the address
                //m_sStartingCell and its dimensions are m_iNumRows x m_iNumCols.
                range = xlSheet.get_Range("A2", misValue);
                range = range.get_Resize(Data.GetLength(0), Data.GetLength(1));

                //Set the range value to the array.
                range.set_Value(Missing.Value, Data);

                //Autofit
                xlSheet.Rows.AutoFit();
                xlSheet.Columns.AutoFit();

                //Save the workbook
                string timeStamp = DateTime.Now.ToString("ddMMyyyymmss");
                string save = string.Concat("test1", timeStamp, ".xls");

                //Save as
                xlBook.SaveAs(save, Excel.XlFileFormat.xlWorkbookNormal, misValue,
                misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue,  misValue,
                misValue, misValue, misValue);

           }
           catch(Exception ex)
             {
               //Log exception
             }
       }
}