Excel Sheet has wrong number of columns

[Brian Richards]

I'm trying to import the attached sheet but it doesn't get the last column. If i open the file in excel and resave it gets the column. Any ideas?

Code Snippet
/********************/
XLS.ExcelUtils.ThrowNotSavedOnDestroy = false;
XLS.IWorkbook excelBook = XLS.ExcelUtils.Open(inputStream);

IDataService dataService = ServiceManager.DataService;

IWorkbook workbook = null;

if (hasMultiplNonEmptyWorksheets(excelBook))
{
workbook = dataService.CreateWorkbook();
}

IWorksheet worksheet = null;

for (int index = 0; index < excelBook.Worksheets.Count; index++)
{
XLS.IWorksheet excelSheet = excelBook.Worksheets[index];

// excelSheet.UsedRange Cells and Column counts do not include the last column
}

BUG_754_columnError2.zip

[Melba Winshia]

Hi Brian,

Thank you for your interest in Essential XlsIO.

I was able to reproduce the problem. Could you please provide some more information regarding the spreadsheet [BUG_754_columnError2.xls]?

1) Was this file [BUG_754_columnError2.xls] generated by using MS Excel or XlsIO?

a) Please mention the Office version, if MS Excel generated this [BUG_754_columnError2.xls] file?

b) Please mention the version of Essential XlsIO, if XlsIO generated this [BUG_754_columnError2.xls] file?

2) Was this file [BUG_754_columnError2.xls] generated by third party tool?

The above details would help us in investigating this issue further. And also, could you please open a new direct – trac incident with subject line as Forum 62507 - Excel Sheet has wrong number of columns ? So that it would be possible for us to provide more details regarding this issue.

Thanks,
Melba

[Brian Richards]

I opened a Direct Trac incident.

[Melba Winshia]

Hi Brian,

Your direct-trac incident has been updated.

Kindly let me know if you have any other questions.

Thanks,
Melba