Ungroup Excel Column
-
Hello, i have excel from which i need to read the data though c# code. Excel having groued columns so iam not able to read those columns. can any one tell me how to un group excel column and save tht changed excel. My code is as follwes which failed :( private void UnGroupRowsAndColumns(Workbook workbook) { Worksheet worksheet = workbook.Worksheets[0]; worksheet.Cells.UngroupRows(0, 9); worksheet.Cells.UngroupColumns(0, 1); }
-
Hello, i have excel from which i need to read the data though c# code. Excel having groued columns so iam not able to read those columns. can any one tell me how to un group excel column and save tht changed excel. My code is as follwes which failed :( private void UnGroupRowsAndColumns(Workbook workbook) { Worksheet worksheet = workbook.Worksheets[0]; worksheet.Cells.UngroupRows(0, 9); worksheet.Cells.UngroupColumns(0, 1); }