Error in Excel file after save with MemoryStream

[oleksa.dovbush]

Hello, I'm getting the error:

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Repaired Records: Drawing from /xl/drawings/drawing2.xml part (Drawing shape)
Repaired Records: Drawing from /xl/drawings/drawing3.xml part (Drawing shape)

when I'm saving the file with Spire.XLS:

Code: Select all

Workbook workbook = new Workbook();
workbook.LoadFromFile(filePath);
Stream memoryStream = new MemoryStream();
workbook.SaveToStream(memoryStream);
return ((MemoryStream)memoryStream).ToArray();


What should I do?
File in attachment
Thank you

[Herman.Yan]

Hi oleksa.dovbush,

Thanks for your message.
Sorry I didn't receive your attached documents,please help to upload them again or send them to us via email ([email protected]). Thanks in advance.

Best Regards,
Herman
E-iceblue support team

[oleksa.dovbush]

Oh, I don't know why it wasn't uploaded.
Here it is.

AnalyticsTemplate.zip

template

(132.15 KiB) Downloaded 373 times

[Herman.Yan]

Hi，

Thanks for your message.
I tested your case using our latest Spire.XLS 13.3.2 , but I didn't reproduce your error. If you were using an old version, I suggest you upgrade to the latest one to try again. If the issue still exists after trying, To help us have a further investigation, please share the following more information with us, thanks in advance.
1.The target platform of your project(E.g.. NET Framework4.8 ) ,
2.Your system information (E.g. Win10, 64 bit) and region setting (E.g. China, Chinese).

Best Regards,
Herman
E-iceblue support team

[oleksa.dovbush]

Sorry, maybe I wasn't clear.
I'm using SpireXLSstandard.
The last version which I can see for Standard is 12.8.0.

[Herman.Yan]

Hi,oleksa

Thanks for your message,
I just tested your case using our latest SpireXLSstandard 12.8.0, but I still haven't reproduced your error. Here, I uploaded my testing program. You can directly run it on your side. If the issue still occurs, please share your system information (E.g. Win10, 64 bit) and region setting (E.g. China, Chinese) with us for further testing.

Best Regards,
Herman
E-iceblue support team

[oleksa.dovbush]

Hello,
I've tried your code and save file to the another place.
You can see my changes in the code I've received the error while I open the new file.
Please, try it once more.
Thank you.

Code: Select all

static void Main(string[] args)
        {
            File.WriteAllBytes("analytic2.xlsx", Test());
            Console.ReadLine();
        }

        public static byte[] Test()
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("AnalyticsTemplate.xlsx");
            Stream memoryStream = new MemoryStream();
            workbook.SaveToStream(memoryStream);
            return ((MemoryStream)memoryStream).ToArray();
        }

[Herman.Yan]

Hi,

Thank you for your message.
I ran your project and did reproduce your issue with the Spire.Xls Standard Edition 12.8.0. I have logged this issue into our tracking system with the ticket SPIREXLS-4571. Our Dev team will do further investigation and fixing. If the issue is resolved, I will notify you immediately.
Meanwhile, I found this issue didn't occur when using our pro version(Spire.XLS Pack(Hotfix) Version:13.3.2). We have checked our records, but we didn't find the order based on your email address. Did your company purchased our Spire.Xls Standard Edition? Could you please provide your purchase information such as order number or license registration email for us reference? Thanks in advance.

Best Regards,
Herman
E-iceblue support team

[oleksa.dovbush]

Sure:
<Type>Temporary</Type>
<Username>Oleksii Polovynka</Username>
<Email>[email protected]</Email>
<Organization>CustomerPlus</Organization>
<LicensedDate>2023-03-09T12:00:00Z</LicensedDate>
<ExpiredDate>2023-04-09T12:00:00Z</ExpiredDate>
<Products>
<Product>
<Name>Spire.XLS Standard Edition</Name>
<Version>12.12</Version>
<Subscription>
<Name>Developer Subscription</Name>
<NumberOfPermittedDeveloper>1</NumberOfPermittedDeveloper>
<NumberOfPermittedSite>1</NumberOfPermittedSite>
</Subscription>
</Product>
</Products>

[Lisa.Li]

Hello,

Thanks for your more information.
I noticed that this is a temporary license of Spire.XLS for .NET Standard Edition. Kindly note that our Spire.XLS for .NET Standard Edition only can be used for .NET and doesn't support the print and conversion function. Our Spire.XLS Pro version supports printing, converting files from Excel to PDF, HTML, Excel to CSV, Excel to Text, Excel to Image ..., and working on .NET Core. If your desired features are only supported in the Pro Edition, you could upgrade to use the Pro version.
Anyway, once there is any update of SPIREXLS-4571, we will keep you informed asap.

Sincerely,
Lisa
E-iceblue support team

[oleksa.dovbush]

Thank you, I don't need any of those, only the issue, which I've noticed. Thanks

[Herman.Yan]

Hi,

Thanks for your patience!
Glad to inform you that we just released Spire.XLS for .NET Standard Edition Version:12.12 which fixes the issue with SPIREXLS-4571.Please download the new version from the following link to test.Website download link:https://www.e-iceblue.com/Download/download-excel-for-net-now.html

Best Regards,
Herman
E-iceblue support team