How to move columns to other locations

Aspose.Cells Product Family
1

1、How to move columns to other locations？
2、How do I add other strings at the front of a string in a cell? When I use the following code, the format of the original string of the cell is gone.
cells[0, 0].PutValue(“A”+ cells0, 0].StringValue);

Thanks!

2

@IORInet

You can move columns by copying columns and deleting the existing one. Please see this documentation article for more help.

For the other issue, we tested your issue with sample code and no formatting was lost. Please provide us your Excel file which exhibit this issue. We will look into it and help you asap.

3

Second problems have been solved. The method is to change StringValue to HtmlString
Because the method of StringValue is just getting cell strings

thanks

4

@IORInet

Thanks for your feedback and considering Aspose APIs.

It is good to know that you were able to sort out second problem with HtmlString property. Let us know if you encounter any other issue, we will be glad to look into it and help you further.