Can I extract all text from a Excel file?


#1

Can I extract all text from a Excel file using Aspose.Cells?

Is there any example programm?


#2

Sure you can:

Workbook workbook = new Workbook();

workbook.Open(templateFile);

for(int i = 0; i < workbook.Worksheets.Count; i ++)

{

Cells cells = workbook.WorksheetsIdea [I].Cells;

for(int j = 0; j < cells.Count; j ++)

{

Cell cell = cells[j];

if(cell.Type == CellValueType.IsString)

{

string text = cell.StringValue;

//do something here

......

}

}

}


#3

Thank you very much