How to convert Column format to Text

I am using Aspose Cells and i need to convert a particular column to Text format, as the column consists of both numbers and Text by default the column is taken as number format. I have used



Aspose.Cells.Style style = worksheet.Cells[“A3”].GetStyle();
<div class=“line number29 index28 alt2” style=“font-family: Consolas, “Bitstream Vera Sans Mono”, “Courier New”, Courier, monospace; font-size: 14px; white-space: pre-wrap; color: rgb(51, 51, 51); border-radius: 0px !important; background-image: none !important; background-position: initial !important; background-size: initial !important; background-repeat: initial !important; background-attachment: initial !important; background-origin: initial !important; background-clip: initial !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 20px !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em 0px 0em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important;”><code class=“csharp plain” style=“font-family: Consolas, “Bitstream Vera Sans Mono”, “Courier New”, Courier, monospace !important; border-radius: 0px !important; background-image: none !important; background-position: initial !important; background-size: initial !important; background-repeat: initial !important; background-attachment: initial !important; background-origin: initial !important; background-clip: initial !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 20px !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; color: rgb(0, 0, 0) !important; background-color: rgb(211, 211, 211);”> style.Number = 49;
<div class=“line number29 index28 alt2” style=“font-family: Consolas, “Bitstream Vera Sans Mono”, “Courier New”, Courier, monospace; font-size: 14px; white-space: pre-wrap; color: rgb(51, 51, 51); border-radius: 0px !important; background-image: none !important; background-position: initial !important; background-size: initial !important; background-repeat: initial !important; background-attachment: initial !important; background-origin: initial !important; background-clip: initial !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 20px !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em 0px 0em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important;”><code class=“csharp plain” style=“background-image: none !important; background-position: initial !important; background-size: initial !important; background-repeat: initial !important; background-attachment: initial !important; background-origin: initial !important; background-clip: initial !important; font-family: Consolas, “Bitstream Vera Sans Mono”, “Courier New”, Courier, monospace !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 20px !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; color: rgb(0, 0, 0) !important;”> worksheet.Cells[<code class=“csharp string” style=“background-image: none !important; background-position: initial !important; background-size: initial !important; background-repeat: initial !important; background-attachment: initial !important; background-origin: initial !important; background-clip: initial !important; font-family: Consolas, “Bitstream Vera Sans Mono”, “Courier New”, Courier, monospace !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 20px !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; color: rgb(0, 51, 102) !important;”>“A3”<code class=“csharp plain” style=“background-image: none !important; background-position: initial !important; background-size: initial !important; background-repeat: initial !important; background-attachment: initial !important; background-origin: initial !important; background-clip: initial !important; font-family: Consolas, “Bitstream Vera Sans Mono”, “Courier New”, Courier, monospace !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 20px !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; color: rgb(0, 0, 0) !important;”>].SetStyle(style);<div class=“line number29 index28 alt2” style=“font-family: Consolas, “Bitstream Vera Sans Mono”, “Courier New”, Courier, monospace; font-size: 14px; white-space: pre-wrap; color: rgb(51, 51, 51); border-radius: 0px !important; background: none rgb(255, 255, 255) !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 20px !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em 0px 0em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important;”><code class=“csharp plain” style=“font-family: Consolas, “Bitstream Vera Sans Mono”, “Courier New”, Courier, monospace !important; border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 20px !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; color: rgb(0, 0, 0) !important;”>
<div class=“line number29 index28 alt2” style=“font-family: Consolas, “Bitstream Vera Sans Mono”, “Courier New”, Courier, monospace; font-size: 14px; white-space: pre-wrap; color: rgb(51, 51, 51); border-radius: 0px !important; background: none rgb(255, 255, 255) !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 20px !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em 0px 0em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important;”><code class=“csharp plain” style=“font-family: Consolas, “Bitstream Vera Sans Mono”, “Courier New”, Courier, monospace !important; border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 20px !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; color: rgb(0, 0, 0) !important;”>this code works only for particular Cell but i need to Set Text format entire column, I have tried using this<div class=“line number29 index28 alt2” style=“font-family: Consolas, “Bitstream Vera Sans Mono”, “Courier New”, Courier, monospace; font-size: 14px; white-space: pre-wrap; color: rgb(51, 51, 51); border-radius: 0px !important; background: none rgb(255, 255, 255) !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 20px !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em 0px 0em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important;”><code class=“csharp plain” style=“font-family: Consolas, “Bitstream Vera Sans Mono”, “Courier New”, Courier, monospace !important; border-radius: 0px !important; background: none !important; border: 0px !important; bottom: auto !important; float: none !important; height: auto !important; left: auto !important; line-height: 20px !important; margin: 0px !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; color: rgb(0, 0, 0) !important;”>
Aspose.Cells.Style style = workbook.Styles[workbook.Styles.Add()];
style.Number = 48; //Sets the Text format.
StyleFlag flag = new StyleFlag();
worksheet.Cells.ApplyColumnStyle(0, style, flag);
worksheet.Cells.ApplyColumnStyle(1, style, flag);

the above code not working. Is there any other way to fix this?

Thanks in Advance

Hi,


Thanks for your posting and using Aspose.Cells.

Please see the following sample code, its sample excel file and its output excel file. It should help you resolve your issue. Let us know your feedback.

C#
//Load excel file
Workbook wb = new Workbook(“sample.xlsx”);

//Access first worksheet
Worksheet ws = wb.Worksheets[0];

//Create style object, number 49 means Text format
Style st = wb.CreateStyle();
st.Number = 49;

//Style flag, we only want to change number format
StyleFlag flag = new StyleFlag();
flag.NumberFormat = true;

//Apply the text format to column A
ws.Cells.Columns[0].ApplyStyle(st, flag);

//Save the workbook
wb.Save(“output.xlsx”);

Thanks Shakeel Faiz, code works fine… :slight_smile:

could have have this in vb.net language?

@an9elia

Thanks for using Aspose APIs.

Please try the following VB.NET code for your needs.

VB.NET

Dim wb As Workbook = New Workbook("sample.xlsx")

Dim ws As Worksheet = wb.Worksheets(0)

Dim st As Style = wb.CreateStyle
st.Number = 49

Dim flag As StyleFlag = New StyleFlag
flag.NumberFormat = true

'Apply the text format to column A
ws.Cells.Columns(0).ApplyStyle(st, flag)

'Save the workbook
wb.Save("output.xlsx")
1 Like