xls file read error

[fugees]

i have a xls file ,contains 10 columns.use spire.xls version 5.82 read this xls file,but read 9 columns.lost one column data.
this file has the pringsetting:PageSetup.CenterHeader、PageSetup.CenterLeft、PageSetup.CenterRight etc.
the file in attachments
please help me, thanks!

[iceblue support]

Hi,

Thanks for your inquiry.
please try:

Code: Select all

            Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
            workbook.LoadFromFile(@"PDA.xls");
            Spire.Xls.Worksheet worksheet = workbook.Worksheets[0];
            String label = worksheet.Range["J1"].Text;   // or worksheet.Range["J1"].Value
            String count = worksheet.Range["J2"].Value; // or double count = (double)worksheet.Range["J2"].Value2, worksheet.Range["J2"].NumberValue