read data from LibreOffice excel sheet and bind to gridview

Question

read data from LibreOffice excel sheet and bind that data to grid view can any one please send me the code for it

darjeam nh · Answer

Alternatively solution: //Create a new workbook Workbook workbook = new Workbook(); //Load a file and imports its data workbook.LoadFromFile(@”..\FandH.xlsx”); //Initialize worksheet Worksheet sheet = workbook.Worksheets[0]; // get the data source that the grid is displaying data for this.dataGridView1.DataSource = sheet.ExportDataTable(); reference: http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Import/Export-Import-Data-from-Excel-to-Datatable.html