We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose.Cells to support worksheet name with smart marker

We have a requirement to change a worksheet name based on smart marker value. is it possible to support this feature for Aspose.Cells for .net.

The Excel template worksheet name is defined as a smark marker, and the final output worksheet name will be updated to the value of the smart marker.

Sample image attached.
sample1.bmp.png (4.2 KB)



Thanks for the screenshot.

Well, it is not possible directly and the smart marker inserted in worksheet (tab) name won’t be processed. I think you may easily accomplish the task by inserting a temporary smart marker (for worksheet name) into some cell in the worksheet in your code first. Then after processing the markers, you will get the value from the temp marker cell and set it as worksheet’s name in your code via Aspose.Cells APIs. Furthermore, you will even choose some distant cell in the worksheet for temp smart marker and later on you will remove the marker before saving the file.

Hope, this helps a bit.