locked
Show Excel Data In Gridview With Our Required Alignment Using Asp.net 2.0 C# RRS feed

  • Question

  • User2033107836 posted

    Hello

    I have Excel In That Excel Data Will Be Like This Below Format

    Emp. Code : 0016  Ramesh           Department : 0001 PER - STAFFS      
                       
    Date   Shift Code Log IN Early In Late IN Log Out Early Out Late Out Wrk. Hrs
                       
    01/12/2017   GS 09:49   01:19 22:24   04:24 12:35
    02/12/2017   GS 06:18 02:12   22:26   04:26 16:08
    03/12/2017   GS 06:56 01:34   14:22 03:38   07:26
    04/12/2017   GS 08:58   00:28 22:31   04:31 13:33
    05/12/2017   GS 06:44 01:46   22:27   04:27 15:43
    Emp. Code : 0019  John           Department : 0001 PER - STAFFS      
                       
    Date   Shift Code Log IN Early In Late IN Log Out Early Out Late Out Wrk. Hrs
                       
    01/12/2017   GS 10:05   01:35 21:08   03:08 11:03
    02/12/2017   GS 09:42   01:12 20:23   02:23 10:41
    03/12/2017   GS 11:53   03:23 17:15 00:45   05:22
    04/12/2017   GS 07:08 01:22   22:33   04:33 15:25
    05/12/2017   GS 09:54   01:24 21:26   03:26 11:32

    I Want Data To Show In Gridview Like This

    Date Emp Code Shift Code Log IN Early In Late IN Log Out Early Out Late Out Wrk. Hrs
                       
    01/12/2017  0016  Ramesh GS 09:49   01:19 22:24   04:24 12:35
    02/12/2017  0016  Ramesh GS 06:18 02:12   22:26   04:26 16:08
    03/12/2017  0016  Ramesh GS 06:56 01:34   14:22 03:38   07:26
    04/12/2017  0016  Ramesh GS 08:58   00:28 22:31   04:31 13:33
    05/12/2017  0016  Ramesh GS 06:44 01:46   22:27   04:27 15:43
    01/12/2017 0019  John GS 10:05   01:35 21:08   03:08 11:03
    02/12/2017 0019  John GS 09:42   01:12 20:23   02:23 10:41
    03/12/2017 0019  John GS 11:53   03:23 17:15 00:45   05:22
    04/12/2017 0019  John GS 07:08 01:22   22:33   04:33 15:25
    05/12/2017 0019  John GS 09:54   01:24 21:26   03:26 11:32

    How To Do So using asp.net 2.0 C#..?

    Thursday, February 8, 2018 10:56 AM

Answers