Free Support Forum - aspose.com

AutoFitColumns in Excel when column include Chinese string using Aspose.Cells for .NET in C#

Dear Sir,
AutoFitColumns don't work when column include chinese string.

The following code open a xlsx and save after call autoFitColumns.

Aspose.Cells.Workbook workbook = new Workbook(@"D:\excelFitColumns.xlsx");
Worksheet worksheet = workbook.Worksheets[0];
AutoFitterOptions options = new AutoFitterOptions();
options.AutoFitMergedCells = true;
worksheet.AutoFitColumns(options);
workbook.Save(@"D:\excelFitColumns-out.xlsx");

I use the latest version of the Aspose.Cells (16.11.0.0).
Attach zip file contains excelFitColumns.xlsx and result file excelFitColumns-out.xlsx.
Thank for your help.

Hi,


Thanks for your posting and using Aspose.Cells.

Please download and try the latest version: Aspose.Cells for .NET (Latest Version) it should fix your issue. Let us know your feedback.

If you still have the problem, please share with us the source file named “excelFitColumns.xlsx” in your sample code.

Dear Sir,

It’s worked.
Thank for your help.

Best Regards,
Rainmaker.
Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest version. Let us know if you encounter any other issue, we will be glad to look into it and help you further.