Question

Excel Cell Formatting

  • 31 August 2021
  • 1 reply
  • 23 views

Badge

Hi,

Does anyone know if I can format excel cells from AIMMS? The data that I export contains date and excel automatically converts it to its own date format and changes the defaults AIMMS format. Is it possible to set it as string when writing? 

Thanks,


1 reply

Userlevel 5
Badge +2

@mohammadansari set the cell format as “Text” in Excel and then use the axll:keepexistingcellformats function to preserve the string formatting.

 

Just set the value of this function as 1 before writing out data. 

 

axll::KeepExistingCellFormats := 1

 

PublicSection — AIMMSXLLibrary documentation

Reply


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator