How to include seconds using &T using Aspose cell api for Java

Aspose.Cells Product Family
1

@amjad.sahi

How to display seconds using &T using Aspose cell api for Java.

Now getting only hour and minutes using &T

Thanks
Sabarish

2

@sabkan,

Thanks for your query.

I think you are referring to the script command “&T” to set the current time when setting headers/footers for Excel worksheets. Please note that you cannot include seconds when setting the time, as Microsoft Excel does not allow this option. Aspose.Cells follows Microsoft Excel standards and specifications when applying headers/footers using PageSetup options. If a feature or option cannot be done with Microsoft Excel, Aspose.Cells also cannot do it. If you still believe this can be done manually in Microsoft Excel, please provide a sample Excel file (zipped) that has your desired time header/footer set, including seconds, and we will check how to do it using Aspose.Cells APIs.

3

@amjad.sahi

You are right using &T in footer.

Thanks for the detailed explanation.

Sabarish

4

@sabkan,

You are welcome. If you have any further queries or comments, please feel free to write us back.