selcting excel range or cells & export to sql using asp.net

I want to import data from Excel using range or cell, like data from row '9' to column 'G'...all the data within these rows and columns will be Exported from excel to sql data table, and this i want to achieve through asp.net.

it is like using X axis and Y axis .

i have code to import the whole file

string csvPath = Server.MapPath("~/Files/") + Path.GetFileName(FileUpload1.PostedFile.FileName);
FileUpload1.SaveAs(csvPath);

DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] { new DataColumn("KPI", typeof(string)),
new DataColumn("KPIPN", typeof(string)),
new DataColumn("KPIPV", typeof(string))});
string csvData = File.ReadAllText(csvPath);
foreach (string row in csvData.Split('\n'))
{
if (!string.IsNullOrEmpty(row))
{
dt.Rows.Add();
int i = 0;
foreach (string cell in row.Split(','))
{
dt.Rows[dt.Rows.Count - 1][i] = cell;
i++;
}
using (SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(con))
{
sqlbulkcopy.DestinationTableName = "dbo.csv";

sqlbulkcopy.WriteToServer(dt);
con.Close();
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Riddhi Valecha10y ago
Hi..make sure that -
1. Data will be always in first sheet of the excel (Sheet 1)
2. The first row will be column names
3. Make sure of values (E.g. - datetime value will not be inserted in varchar column, etc)

Rest, I see no issue in this code...

I have also used the same code in my portal for inserting csv file data to sql server.