After I import my datatable into a worksheet, I would like to be able to get the the column index based on the string that is in the first row of the column. What is the best way to do this?
Please find attached the sample code for your requirement, you may adjust it accordingly.
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets;
//Your code regarding Importing DataTable goes here.
string mystring = “Your string goes here”;
Aspose.Cells.Cell fcell = worksheet.Cells.FindString(mystring, null);
Column col = fcell.Column;