Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Thu Mar 23, 2023 6:43 am

Hi Team,

I am trying to read and update my .xlsb binary excel file with Spire.xls. Post updating the file it is giving below popup of "Error with content"
My application is .net core with .net 5.0 framework within windows 11
I am using Spire.xls 13.3.2.0 downloaded from Nuget

Below is the code I have used.
private void ReadFilewithSpire() {

// Directory path of input and output files.
string dirPath = "B:\\Census upload project/";

Workbook workbook = new Workbook();
workbook.LoadFromFile(dirPath + "InputLargeGroupModel_UW1_Test.xlsb");

//Edit Text
Worksheet sheet = workbook.Worksheets[0];
sheet.Range["D2"].Text = "Kelly Cooper";
sheet.Range["D2"].Style.Font.FontName = "Arial Narrow";
sheet.Range["D2"].Style.Font.Color = Color.DarkBlue;

//Edit Cell Value
sheet.Range["E2"].Value = "00-1-285-7901742";
sheet.Range["E2"].Style.Font.FontName = "Book Antiqua";
sheet.Range["E2"].Style.Font.Color = Color.DarkOrange;

string data = sheet.Range["E72"].Value;

Worksheet sheet2 = workbook.Worksheets["Additional Prospect Inputs"];
sheet2.Range["B5"].Value = data;

//Save and Launch
workbook.SaveToFile(dirPath + "InputLargeGroupModel_UW1_Test.xlsb", ExcelVersion.Xlsb2010);
//System.Diagnostics.Process.Start(dirPath + "InputLargeGroupModel_UW1_Test.xlsb");
}

Attached is the input file I am using to update and error popup screenshot.

Please do let me know if you need anything else.



Thanks and regards
Heeralal Tiwari
Empoweredmargins Pvt. Ltd.
Attachments
InputLargeGroupModel_UW1_Test.zip
(1.15 MiB) Downloaded 401 times
Error in content.png
Error in content.png (12.38 KiB) Viewed 1172 times

heeralal
 
Posts: 1
Joined: Thu Mar 23, 2023 6:27 am

Fri Mar 24, 2023 7:45 am

Hi ,

Thank you for your message.
I did reproduce your issue and have logged this issue into our tracking system with the ticket SPIREXLS-4583, our Dev team will do further investigation and fixing. Once there is any update, we will keep you informed. Sorry for the inconvenience caused.

Best Regards,
Herman
E-iceblue support team
User avatar

Herman.Yan
 
Posts: 115
Joined: Wed Mar 08, 2023 2:00 am

Tue Apr 11, 2023 1:13 am

Hi,

Thanks for your patience!
Glad to inform you that we just released Spire.XLS 13.4.0 which fixes the issue of SPIREXLS-4583.Please download the new version from the following links to test.
Website link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html.
Nuget link: https://www.nuget.org/packages/Spire.XLS/13.4.0.

Best Regards,
Herman
E-iceblue support tea
User avatar

Herman.Yan
 
Posts: 115
Joined: Wed Mar 08, 2023 2:00 am

Return to Spire.XLS