Solved

Excel Cell Formatting

  • 31 August 2021
  • 1 reply
  • 51 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,

icon

Best answer by mohansx 2 September 2021, 19:59

View original

1 reply

Userlevel 5
Badge +5

@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