How to fetch data from perticular column in excel using C# ?

Question

Suppose I have Excel sheet where that excel sheet contain 1000 record with A to Z column but i just want only select perticular column from excel sheet . ie I want to select column S to W . How I do with bulkcoppy of data ? If any one has solution please kindly guide me.? thank you.

Altaf Ansari · Answer

try This : Excel.Application aplicacion = new Excel.Application(); //Use Existing Sheet Excel.Workbook workbook1 = aplicacion.Workbooks.Open( Path/ExcelFile.xlsx ); Excel.Worksheet worksheet = (Excel.Worksheet)workbook1.Worksheets.get_Item(1); Microsoft.Office.Interop.Excel.Range SomeCell = (Excel.Range)worksheet.Cells[1 10];

Ramesh Palanivel · Answer

int startColumn = Header.Cells.Column; int startRow = header.Cells.Row + 1; Excel.Range startCell = this .sheet.Cells[startRow startColumn]; int endColumn = startColumn + 1; int endRow = 65536; Excel.Range endCell = this .sheet.Cells[endRow endColumn]; Excel.Range myRange = this .sheet.Range[startCell endCell]; Hi Sumit try this

Uehara Ayaka · Answer

If you use Spire.XLS you can copy the data from the range S1:W1000 to clipboard like this [STAThread] static void Main( string [] args) { //load Excel file Workbook wb = new Workbook(); wb.LoadFromFile( data.xlsx ); //get the first sheet Worksheet sheet = wb.Worksheets[0]; //copy data to clipboard sheet.Range[ S1:W1000 ].CopyToClipboard(); }

Srikant Maruwada · Answer

using XLS = Microsoft.Office.Interop.Excel; XLS.Application myapp= new XLS.ApplicationClass(); XLS.Workbook wb = myapp.Workbooks.Open(@ d:\Mapping.xls ); XLS.Worksheet sheet = (XLS.Worksheet)wb.Worksheets.get_Item(1); var cell = (XLS.Range)sheet.Cells[35]; Console.Write(cell.Value2); Try to use Interop. Excel add a reference to it.

Sumit Ringane · Answer

hi Ramesh. I am using interop service library.

Ramesh Palanivel · Answer

Hi Sumit may I know which dll you are using to read the data from excel.Using any thrid party dll to read data? or interop service library?