Value was either too large or too small for an Int32 - Value was either too large or too small for an Int32 - Problem Saving Xlsx File

Aspose.Cells Product Family
1

Hi,

Hi thank you for your modification.I changed my code.

But the other problem is continue.I changed my code to

if (extention.ToLower() == ".xlsx")

{
workbook.Save(su.MapPath("../../QDMSFiles/TEMPFOL/") + tempFileName, Aspose.Cells.SaveFormat.Xlsx);

}

But the error mesage is the same.

I'm using this codes;

workbook.Open(su.MapPath("../../QDMSFiles/TEMPFOL/") + tempFileName);
foreach (Worksheet sheet in workbook.Worksheets)
{
sheet.Replace("", bsat001.ADI + " " + bsat001.SOYADI);
sheet.Replace("", bsat001.SICIL_NO);
sheet.Replace("", DateTime.Today.ToShortDateString());
sheet.Replace("", DateTime.Today.ToString());
}
workbook.FileName = tempFileName;
if (extention.ToLower() == ".xlsx")
workbook.Save(su.MapPath("../../QDMSFiles/TEMPFOL/") + tempFileName,Aspose.Cells.SaveFormat.Xlsx);
else
workbook.Save(su.MapPath("../../QDMSFiles/TEMPFOL/") + tempFileName);

Is there any wrong thing?

2

Hi,

We have found the issue of saving xlsx file.

We will fix it soon.

3

Hi,

Please download and try the latest version:
Aspose.Cells
for .NET v7.1.2.1 and provide me your feedback.

Also, I have split this thread and added your comment in our database with issue id: CELLSNET-40487

4

Hi,I tried and my problem seems as fixed now.

Thank you for your reply

5

Hi,

Thanks for your feedback.

It’s good to know your issue has been fixed. We have closed this thread.

If you get any other question, please post it, we will help you asap.

Always use newer threads for your newer problems.