I have an excel sheet, in that i have lot data to importing into the oracle database directly thorugh a .net application. Here I have plenty of data in excel sheet, so we have to read this data and inserting into the oracle database directly using .net application. I want a .net application, here we browse that data content excel sheet with browse button, so we have to capture these excel sheet data and inserted into the oracle table directly.
Here data is columns as rows & rows as columns. So how to read in this case.
firstname vijay vikram vikek varun
lastame kumar rathod goshal kandari
mobile 45425 456546 54656 454615
like above my data in excel sheet so how capture this kind of data. please let me know.
please anybody have the solution about my requirement? please let me inform.
In Advance Thanks...
Thanks & Regards, Vinod Bheemisetty
Hi Vinod, you can build an app for Office that reads selected data in an Excel spreadsheet and send it to a .Net application or to the database, depending on how it's implemented. You can learn more about apps for Office in this topic. To get data currently selected by the user please refer to the Document.getSelectedDataAsync method.
You may see this similar discussion first.
An Alternative based on a .NET Excel components. Code Samples:
//Create a workbook Workbook workbook = new Workbook(); //Load the file workbook.LoadFromFile("DataTableSample.xls"); //Initailize worksheet Worksheet sheet = workbook.Worksheets; //Export datatable DataTable dataTable = sheet.ExportDataTable();
- แก้ไขโดย Green823 18 กรกฎาคม 2555 5:40