1
Answer

want to update the data in excel to db.but small change

i am uploading excel sheet 
 
city categoryname
 metadescription
karaikudi
 belts
 Discover the hottest trends in leather, designer belts at Basics to keep up with you! Choosfrom the brand’s range and stay stylish in every season. Get yours at Karaikudi's best men's accessories store, Basics near you.
karaikudi blazers
 Sport the sharpest, trendiest men's blazers f roBasics. The blazers add the perfect finish to formal and casual outfits, ensuring you are in vogue! Get yours at Karaikudi's best men's clothing store, Basics near you.
 
like that columname and its description should save in database 
 
my code::
 
public ActionResult categoryimp()
{
_Workbook workBook = null;
_Worksheet workSheet = null;
Range cellsRange = null;
Range columnRange = null;
Range rowRange = null;
int numberOfColumns = 0;
int numberOfRows = 0;
var excelApp = new Application();
List<Categorydescription> obj = new List<Categorydescription>();
List<Categorydescription> items = new List<Categorydescription>();
try
{
workBook = excelApp.Workbooks.Open("D:/excelnew", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
workSheet = (Worksheet)workBook.Worksheets.get_Item(1);
cellsRange = workSheet.Cells;
columnRange = cellsRange.Columns;
rowRange = cellsRange.Rows;
numberOfColumns = columnRange.Count;
numberOfRows = rowRange.Count;
Range objRange = null;
object[] data = null;
int totalColumns = workSheet.UsedRange.Cells.Columns.Count + 1;
//Iterating from row 2 because first row contains HeaderNames
Categorydescription item = new Categorydescription();
for (int row = 2; row < workSheet.UsedRange.Cells.Rows.Count; row++)
{
item = new Categorydescription();
data = new object[totalColumns - 1];
for (int col = 1; col < totalColumns; col++)
{
objRange = workSheet.Cells[row, col];
if (objRange.MergeCells)
{
data[col - 1] = Convert.ToString(((Range)objRange.MergeArea[1, 1]).Text).Trim();
}
else
{
data[col - 1] = Convert.ToString(objRange.Text).Trim();
}
if (col == 1)
{
item.city= Convert.ToString(objRange.Text).Trim();
}
if (col == 2)
{
item.belts= Convert.ToString(objRange.Text).Trim();
}
if (col == 3)
{
item.Metadescription = Convert.ToString(objRange.Text).Trim();
}
}
items.Add(item);
}
string s = String.Format(
"There are {0} columns and {1} rows in the Worksheet",
numberOfColumns, numberOfRows);
}
finally
{
}
CategorydescDataContext db = new CategorydescDataContext();
db.Categorydescriptions.InsertAllOnSubmit(items);
db.SubmitChanges();
return View();
}
}
}
 

Answers (1)