Excel Sheet Name Problem

[Sabit]

Hi,

When I open excel file (version 97 to 2003) that rise exception (File does not contain workbook stream') . because sheetname like this (name.rpd) ,that contains dot

how can we solve this?

using (ExcelEngine excelEngine = new ExcelEngine())

                    {

                        IApplication app = excelEngine.Excel;

                        app.IgnoreSheetNameException = false;

                        IWorkbook workbook = app.Workbooks.Open(headFilePath);

                        workbook.Version = ExcelVersion.Excel97to2003;

                        IWorksheet worksheet = workbook.Worksheets[0];

                        worksheet.UsedRangeIncludesFormatting = true;

                        int rowCount = worksheet.UsedRange.LastRow;

                        int colCount = worksheet.UsedRange.LastColumn;

[Ramya Sivakumar]

Hi Sabit,

Greetings from Syncfusion.

We are unable to reproduce the issue at our end. We have shared a sample that we tried at our end, and it can be downloaded from the below link.

Sample link - https://www.syncfusion.com/downloads/support/directtrac/general/ze/F-1764991911405010

We request you share the issue reproducing sample or else modify this sample to reproduce the issue and share us along with the issue reproducing input documents. It will help us to proceed further and provide you with a solution at the earliest.

And, please confirm the Syncfusion XlsIO version you are using at your end.

Regards,

Ramya.