Hi,
I am using Aspose.Excel version 3.0.5.0. I am reading a spreadsheet and every few tries one of the cells gets corrupted, i.e. it gets some spurious data in it. I attach the relevant spreadsheet. When I convert the resultant datatable into XML format I get what’s listed below. The ‘corrupt’ cell is Column1 in the 6th row from the end. This should have a date in it. Has anyone come across this problem before?
TIA,
Mark
12/04/2005
003630W
11
BHX
782154033000
08109095 90
TH
15
14.00
12/04/2005
003630W
11
BHX
782154033000
07099090 90
TH
16
367.00
15/04/2005
004679X
11
BHX
775390204000
08071900 10
PK
1
400.00
K
15/04/2005
004679X
11
BHX
775390204000
08071900 10
PK
1
400.00
15/04/2005
004679X
11
BHX
775390204000
08045000 21
PK
2
396.00
15/04/2005
004679X
11
BHX
775390204000
07081000 00
PK
4
420.00
K
15/04/2005
004679X
11
BHX
775390204000
07081000 00
PK
4
420.00
15/04/2005
004679X
11
BHX
775390204000
07099090 90
PK
5
480.00
15/04/2005
004697V
11
BHX
782154033000
07093000 00
TH
1
17.00
K
15/04/2005
004697V
11
BHX
782154033000
07094000 10
TH
2
2.00
K
cvtwbpp
004697V
11
BHX
782154033000
07096099 00
TH
3
17.00
15/04/2005
004697V
11
BHX
782154033000
08030011 00
TH
4
10.00
15/04/2005
004697V
11
BHX
782154033000
07082000 90
TH
5
7.00
15/04/2005
004697V
11
BHX
782154033000
07099090 40
TH
7
3.00
15/04/2005
004697V
11
BHX
782154033000
08072000 00
TH
8
30.00
15/04/2005
004697V
11
BHX
782154033000
08045000 91
TH
9
35.00