Free Support Forum - aspose.com

Wrap text error

Hi, We have an excel file this is a template file and it has some tags like <ALAN599_ACK> Column style property is Wrap text.
When we use replace method and replace <ALAN599_ACK> to "TOPRAK KİRLİLİĞİNİN KONTROLÜ VE NOKTASAL KAYNAKLI KİRLENMİŞ SAHALARA DAİR YÖNETMELİK-08.06.2010-27605, Atık Yönetimi Yönetmeliği-02.04.2015-29314 "
We are waiting to see all data but wrap text property doesn’t work. How can we set column height to see al data.Because when we convert this file to pdf we lose the data
kardemir.zip (653.7 KB)

@srmbimser,

Please use the:

worksheet.AutoFitRows();

after replacing the contents as shown in the code sample below:

Workbook workbook = new Workbook("kardemircbep.xls");

// Using the Sheet 1 in Workbook
Worksheet worksheet = workbook.Worksheets[0];
            
worksheet.Replace("<ALAN599_ACK>", "TOPRAK KİRLİLİĞİNİN KONTROLÜ VE NOKTASAL KAYNAKLI KİRLENMİŞ SAHALARA DAİR YÖNETMELİK-08.06.2010-27605, Atık Yönetimi Yönetmeliği-02.04.2015-29314");

worksheet.AutoFitRows();

workbook.Save("kardemircbep_out.pdf", SaveFormat.Pdf);