Converting excel to html and setting max height and width for cells

Aspose.Cells Product Family
1

Hi, I am using the below code to convert my excel file to a html file. When there is a lot of text in the cells, the cells in the html file will be very large. However, I would like to set a maximum height and width for the cells in the html file. Is there any way I can do this. Thanks.

Aspose.Cells.Workbook w = new Aspose.Cells.Workbook(originalFilePath);
w.Save(originalFilePathHtml, Aspose.Cells.SaveFormat.Html);

2

@kellytan2001,
I am afraid that there is no direct mechanism to make row/height pleasing to eyes. However you may please use following sample code to change the column width and set wraptext to true.

Aspose.Cells.Workbook w = new Aspose.Cells.Workbook("originalFilePath");
Worksheet sheet = w.Worksheets[0];

// Create a Style object using CellsFactory class
CellsFactory cf = new CellsFactory();
Style st = cf.CreateStyle();
st.IsTextWrapped = true;
sheet.Cells.Columns[1].ApplyStyle(st, new StyleFlag() { WrapText = true });
sheet.Cells.Columns[1].Width = 10;
w.Save(originalFilePathHtml, Aspose.Cells.SaveFormat.Html);

If you need further help then share your input and output files for our analysis.