Format data functions

Hi,

I am trying to get a format data function with Aspose.Cells.

I have in my dataset a field: "Datos.Estado". I would like get this information with upper format before the aspose converse.

How can I do it? I am not interesting in two columns, only one.

I tried &=&=UPPER(&=Datos.Estado) and &=&=UPPER(Datos.Estado) but it doesnt work.

Thanks,

IASOFT.

Hi,


Well, dynamic formulas does not work in this way, it work in the following way.

e.g
A B

&=Datos.Estado &=&=UPPER(A{r})


I think you may also try to use UPPER function in your SQL Query / Statement while extracting data from the back end table.
e.g
SELECT UPPER(Estado) FROM Datos

Thank you.