read data from LibreOffice excel sheet and bind to gridview
read data from LibreOffice excel sheet and bind that data to grid view can any one please send me the code for it
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rahul PrasadPosted Apr 21, 2016, 11:55 PM
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();