Prakash Mondal

Prakash Mondal

  • NA
  • 288
  • 208.2k

Hou to upload multiple Excel file in c# windows form applica

Dec 1 2018 7:35 AM
I have multiple excel file where contains salary sheet data. like that..
 
EMP1001.xls or EMP1001.xlsx    ---- here EMP1001 is a employee no of a employee
month
basic
 dahra
 total
 jan 20000 150003000
 38000
 feb 19800 140002860
 36660
 mar 23200 160003050
 42250
 
EMP1002.xls or EMP1002.xlsx
 
 month basic dahra
 total
 jan 8000 140002500
 24500
 feb
 9000 170002100
 28100
 mar
 10000 190001800
 30800
 
 I create a database table and extract excel data
 
emp_nomonth
 basic da hra net
 EMP1001jan
 20000 15000 3000 38000
EMP1001
feb
19800
14000
2860
36660
EMP1001
mar
23200
16000
3050
42250
EMP1002
jan
8000
14000
2500
24500
EMP1002
feb
9000
17000
2100
28100
EMP1002
mar
10000
19000
1800
30800
 
Actually I done all of these process with single file upload.
 
I want to upload multiple excel file and insert these data into database from excel file.
 
Please help me.
 

Answers (3)