I am using Aspose 126.96.36.199, and I have an error “Input string was not in a correct format” ,
I get this eception in two situations;
1- when I try to open a workbook:
Workbook workbook = new Workbook(FilePath);
Worksheet sheet = workbook.Worksheets;
after investigations, the “E-” is causing that problem, but , the same value in another workbook doesn’t causing the same problem !!! so Is there a special format to check or to avoid ??
bellow some examples of values :
not accepted values :
2-the second situation is when i copy a sheet to another :
Workbook _template = new Workbook(templateFilePath);
Worksheet _template_DecoSheet = _template.Worksheets[“Deco”];
Workbook _parentBook = new Workbook();
Worksheet _workSheetDeco = _parentBook.Worksheets;
_workSheetDeco.Copy(_template_DecoSheet); //Exception here
_workSheetDeco.Name = templateSheetDecomp1.Name;
So the question; how can I avoid this error; it’s very blocking for me, if the format of one cell is not correct, why to prevent to read all the sheet ?? could you help me please.
thanks in advance.