Hi, I am doing some calculation based on my excel input. This Excel user can select from the particular path and then select the file. But, now client wants, they don't want to select excel file from the path. Instead of that, they will mention the file path in the INI file. While loading the form, first it should read the INI File and then read and convert into datatable. I am new to use INI File. Can anyone suggest how to write code to read the file from INI and convert those file into datatable See my current code below..
private void btnbrowse_Click(object sender, EventArgs e) { this.openFileDialog1.Filter = "Excel file (*.xls;)|*.xlsx"; this.openFileDialog1.Multiselect = true; this.openFileDialog1.Title = "Select Excel"; DialogResult dr = this.openFileDialog1.ShowDialog(); DataTable dataTable1 = new DataTable(); if (dr == System.Windows.Forms.DialogResult.OK) { foreach (String file in openFileDialog1.FileNames) { Excelname = file; txtXLfile.Text = Excelname; } } dtproject = getXLDatatable(Excelname, dataTable1); DataRow dr1; dr1 = dtproject.NewRow(); dr1.ItemArray = new object[] { 0, "Select Project" }; dtproject.Rows.InsertAt(dr1, 0); cmbProject.ValueMember = "EmployeeName"; cmbProject.DisplayMember = "EmployeeName"; cmbProject.DataSource = dtproject; } private static DataTable getXLDatatable(string XLbroname, DataTable dataTable1) { FileStream fstream1 = new FileStream(XLbroname, FileMode.Open); Workbook workbook1 = new Workbook(fstream1); Worksheet worksheet1 = workbook1.Worksheets[0]; dataTable1.AcceptChanges(); DataSet ds1 = new DataSet(); DataTable dt2 = new DataTable(); ds1.Tables.Add(dataTable1); dataTable1 = worksheet1.Cells.ExportDataTable(1, 0, worksheet1.Cells.MaxRow + 1, worksheet1.Cells.MaxColumn + 1); dataTable1.TableName = "tableXL"; dataTable1.Columns[0].ColumnName = "Id"; dataTable1.Columns[1].ColumnName = "EmployeeName"; dataTable1.Columns[2].ColumnName = "Dept"; dataTable1.Columns[3].ColumnName = "Section"; dt2 = dataTable1; return dt2; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)