Results 1 to 5 of 5

How to read Excel data in a sheet

Threaded View

sdondeti How to read Excel data in a... 08-14-2009, 09:41 AM
stanleydgromjr Re: How to read Excel data in... 08-14-2009, 10:00 AM
sdondeti Re: How to read Excel data in... 08-14-2009, 10:16 AM
sdondeti Re: How to read Excel data in... 08-14-2009, 10:57 AM
stanleydgromjr Re: How to read Excel data in... 08-15-2009, 03:55 PM
  1. #1
    Registered User
    Join Date
    08-14-2009
    Location
    Newark, Delaware
    MS-Off Ver
    Excel 2003
    Posts
    6

    How to read Excel data in a sheet

    Hi Friends,

    I got an excel workbook consists of 4 sheets and each sheet has got 15 columns & 100's of rows data.
    Now my task is to read these columns of data from the 4 sheets and open a new excel sheet and generate a report of these values.
    There is no need to insert data into a table, data from 4 sheets of data to be copied to new excel sheet as required formate with header 5 lines and footer 2 lines and inbetween data formate is needed.

    And this report should be automated and able to generate a report every month.

    Can you please help me to develop this program, i am new to excel programming hope this is my first program to start up. I got good skills in .net, c# programming so it will be easy for me to understand.

    Please find the excel file attached, from sheet1(RawData) data is copied and generated a report which is shown in sheet5(std&qc). This report was generated manually, now we need to automate this.

    If possible please send me a sample code.

    Thanks for your support,
    SDondeti
    Attached Files Attached Files
    Last edited by sdondeti; 08-14-2009 at 10:12 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1