Skip to main content

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,

@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


Terms & Conditions

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

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