Open Excel file with multiple charts

[TaeWook Kang]

There is a method to upload Excel and open another Excel file.

This is the process to write the contents of the uploaded Excel to the existing Excel.

If you have chart data in Excel, you cannot open Excel.

The chart in Excel doesn't mean much. However, even if there is a chart in Excel, we want to be able to open the file and write it.

               string formulaFile = ConnectionInformation.BasePath + $@"{separator}TEMPLATE{separator}chart test.xlsx";
 
               //계산 되어있는 엑셀 시트
               ExcelEngine writeExcelEngine = new ExcelEngine();
               IApplication writeApplication = writeExcelEngine.Excel;
               FileStream formulaStream = new FileStream(formulaFile, FileMode.Open, FileAccess.ReadWrite);
               IWorkbook writeWorkbook = null;
               writeWorkbook = writeApplication.Workbooks.Open(formulaStream);

Attachment: chart_test_7a3d75a5.zip

[Konduru Keerthi Konduru Ravichandra Raju]

Hi TaeWook,

We are able to reproduce the reported issue and validating it currently. We will share the validation details on May 17^th, 2023.

Regards,

Keerthi.

[Konduru Keerthi Konduru Ravichandra Raju]

TaeWook, we have confirmed the issue as an Exception is thrown while positioning the chart in the Excel document and logged a defect report. We will include the fix for this issue in our weekly NuGet release scheduled for May 30^th, 2023.

You can track the status of this defect report through below feedback link.

https://www.syncfusion.com/feedback/43772/exception-is-thrown-while-positioning-chart-in-excel-document

Disclaimer: Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.

[Konduru Keerthi Konduru Ravichandra Raju]

TaeWook, we have resolved the issue Exception is thrown while positioning the chart in the Excel document and included the fix in our weekly NuGet release version 21.2.8. We suggest you to upgrade to this latest 21.2.8 version and let us know if the issue is resolved.

Latest NuGet Package: https://www.nuget.org/packages/Syncfusion.XlsIO.Net.Core/21.2.8