How to change the cell width for excel export in asp.net ?

Question

Hi All , How to change the cell width for excel export in asp.net ? this is my sample code : string style = @" .textmode { mso-number-format:\@;font-size:15px; width:100%; } "; Thanks in advance

Sangeetha S · Answer

string table = @" Column 1 Column 2 Data 1 Data 2 ";

Daniel Wright · Answer

To change the cell width for Excel export in ASP.NET, you can modify the style attributes within your code snippet. In the provided sample code, the style definition seems to include a class called "textmode" with a specified font size and width. However, the width property may not directly affect the cell width in Excel. To adjust the cell width for Excel export, you typically need to use specific Excel formatting properties. One common approach is to define the column width in the Excel file itself during export. Here's an example of how you can modify the code snippet to set the cell width: // Define the Excel column width in the style string style = @" .textmode { mso-number-format:\@; font-size:15px; } .colWidth { mso-width-source:auto; mso-width-alt:200px; width:200px; } "; // Apply the style to your Excel content // Adjust the width based on your requirements In this adjusted code snippet, a new class "colWidth" is introduced to set the specific width for the Excel cell. You can customize the `width` property value to set the desired width for the Excel columns during export. By incorporating the appropriate Excel styling within your ASP.NET application, you can effectively control the cell width for Excel exports. Make sure to test the exported Excel file to ensure that the cell widths meet your expectations. Let me know if you need further assistance or more detailed guidance on this topic!

How to change the cell width for excel export in asp.net ?

Answers (2)